I have a site that offers a free sample of our product. Currently someone fills out the form and it is written to a sql database on another server. We are going to launch a new site and was wondering if there are any online options through a 3rd party provider that can handle sample requests and allow us to do searches for marketing, such as a chart showing age ranges or a map showing where people requests samples from.
I also want to get away from the single sql database that could go down more easily than a cloud solution.
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…