The Entity Framework is an extended Object Relational Mapping (ORM) technology from Microsoft that abstracts the object model of an application from its relational or logical model. The newer versions of this framework provide you with many exciting features—model-first development being one of these things. In this chapter, we will explore how we can work with stored procedures in Entity Framework 6.
We will discuss the following points:
Creating a database using model-first development
Creating stored procedures for the database
Mapping stored procedures to functions in the EDM
Using the stored procedures in the Object Layer
Mapping stored procedures that return custom entity types
Adding stored procedures to the EDM
Mapping stored procedures to functions in the EDM
Mapping stored procedures that return custom entity types