Microsoft ADO.NET Entity Framework Step by Step

Chapter 8. Interaction with stored procedures

After completing the chapter, you’ll be able to

• Understanding stored procedures

• Adding stored procedures to your model

• Building an application using stored procedures

• Creating a basic stored procedure example

Stored procedures provide a means of storing data management code directly on the server in the SQL language. Unlike other forms of application code described in this book, a stored procedure is accessible by anyone who has access to the server and the required security privileges. It doesn’t matter what language you’re using outside of Microsoft SQL Server, or whether you’re using another language at all. In short, stored procedures provide the best general-purpose method of creating data management ...