Good grief... it's hard to decide which technologies to use, so I would love some input from those experienced.
Scenario: (assuming - mvc 2, iis 7, sql server 2008)
1) Web application user creates an entry
2) Entry is stored on sql server
3) The entry is evaluated and based on certain criteria an email should be sent to one or more individuals
Let's see... we have msmq, wcf, service broker, windows service, and probably others i'm not considering
From the research we've done to date, it seems the best approach would be...
> sql server action triggers service broker > service broker performs data analysis and calls a service hosted in iis with the keys identifying the record to send an email
this could be run on a single server or distributed out on multiple servers.
Yes? No? Maybe? Not even close?
View Complete Post