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 ...

Get Entity Framework 4 in Action now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.