Stored procedures sometimes get a bad rap from developers, given their long history. But we need to remember that, often, they are the most effective way to coalesce complex queries. Just don't let them store business logic.
We will be using the
NuGet Package Manager to install the Entity Framework 4.1 assemblies.
The package installer can be found at http://nuget.org.
We will also be using a database for connecting the data and updating it.
Open the Improving Stored Procedures solution in the included source code examples.
TransactionTeststo the test project. We make a test that connects to the database, adds an object, and then retrieves a count with ...