Using Entity Framework with stored procedures

Stored procedures are a way to define the data access functionality in the database itself. The major benefit of using stored procedures is that if we have multiple applications using the same database, then using stored procedures ensures that the data access functionality is consistent across all the applications since it is defined in the data layer itself. Also, stored procedures allow better performance and better encapsulation. Stored procedures also shield us from the SQL injection security concerns, so they allow better security.


Stored procedures are far more powerful than views. Views should only be used to read data from the database. View are more like virtual tables from the database ...

Get Mastering Entity Framework now with O’Reilly online learning.

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