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
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Chapter 4. Working with Stored Procedures in the Entity Data Model

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

Note

Note that as of this writing, support for stored procedures is not yet included in Entity Framework 7. However...