Book Image

Entity Framework Tutorial (Update) - Second Edition

By : Joydip Kanjilal
Book Image

Entity Framework Tutorial (Update) - Second Edition

By: Joydip Kanjilal

Overview of this book

The ADO.NET Entity Framework from Microsoft is a new ADO.NET development framework that provides a level of abstraction for data access strategies and solves the impedance mismatch issues that exist between different data models This book explores Microsoft’s Entity Framework and explains how it can used to build enterprise level applications. It will also teach you how you can work with RESTful Services and Google’s Protocol Buffers with Entity Framework and WCF. You will explore how to use Entity Framework with ASP.NET Web API and also how to consume the data exposed by Entity Framework from client applications of varying types, i.e., ASP.NET MVC, WPF and Silverlight. You will familiarize yourself with the new features and improvements introduced in Entity Framework including enhanced POCO support, template-based code generation, tooling consolidation and connection resiliency. By the end of the book, you will be able to successfully extend the new functionalities of Entity framework into your project.
Table of Contents (16 chapters)
Entity Framework Tutorial Second Edition
About the Author
About the Reviewers

Mapping stored procedures to functions in the EDM

Stored procedures are represented as functions in the EDM. To use these functions, they should be mapped to a corresponding insert, update, or delete operation on the entity. To do this, you need to first create a function import and then use the designer to create its mapping. In this section, you will learn how to create these function imports for your EDM.

To begin, let's refer to the EDM we created earlier in this chapter. To create function imports, follow these steps:

  1. Switch to the Model Browser of the Payroll Entity Data Model.

  2. Expand the Entity Container and right-click on Function Imports.

  3. When you select Create Function Import, the New Function Import dialog appears and allows you to select the stored procedure you want from the list of available stored procedures.

  4. Now, map the Employee_Insert stored procedure to a corresponding function import by selecting the stored procedure name, the function import name, and the return type. Note...