Entity Framework 4 in Action

Chapter 10. Working with stored procedures

 

This chapter covers

• Mapping stored procedures in the EDM
• Retrieving data using stored procedures
• Embedding SQL commands in the EDM
• Updating data using stored procedures

 

Now that you’ve mastered Entity SQL, we can move forward and take a closer look at another advanced feature of Entity Framework: the use of stored procedures.

Because LINQ to Entities makes it so easy to write queries, leaving the burden of creating SQL code to the framework, you may think that stored procedures are no longer needed. From a developer’s point of view, writing queries against the domain model with LINQ to Entities is more natural than writing a stored procedure that returns raw data. But there is another side to ...