Book Image

Entity Framework Tutorial

By : Joydip Kanjilal
Book Image

Entity Framework Tutorial

By: Joydip Kanjilal

Overview of this book

<p>The ADO.NET Entity Framework is a new way to build the data access layer of your Windows or web applications. It's an Object Relational Mapping (ORM) technology that makes it easy to tie together the data in your database with the objects in your applications, by abstracting the object model of an application from its relational or logical model.<br /><br />This clear and concise book gets you started with the Entity Framework and carefully gives you the skills to speed up your application development by constructing a better data access layer. It shows you how to get the most from the ADO.NET Entity Framework to perform CRUD operations with complex data in your applications.<br /><br />This tutorial starts out with the basics of the Entity Framework, showing plenty of examples to get you started using it in your own code. You will learn how to create an Entity Data Model, and then take this further with Entity types. You will also learn about the Entity Client data provider, learn how to create statements in Entity SQL, and get to grips with ADO.NET Data Services, also known as Project Astoria.</p>

Related Content you might be interested in

Current Title:

Small book image
Entity Framework Tutorial
Joydip Kanjilal
Oct, 2008 | 228 pages
No titles found
Table of Contents (13 chapters)
Entity Framework Tutorial
Entity Framework Tutorial
Credits
Credits
About the Author
About the Author
About the Reviewer
About the Reviewer
Preface
Preface
Free Chapter
1
Introducing the ADO.NET Entity Framework
Introducing the ADO.NET Entity Framework
What You should Know
Looking Back
What is ADO.NET Entity Framework?
The ADO.NET Entity Framework Architectural Components
The Entity Data Model (EDM)
Installing the Prerequisites
Designing the Payroll Database
Summary
Glossary
2
Getting Started
Getting Started
Creating an Entity Data Model
The ADO.NET Entity Data Source Control
Implementing Our First Application Using the Entity Framework
Summary
3
Entities, Relationships, and the Entity Data Model
Entities, Relationships, and the Entity Data Model
Entities, Entity Types, and Relationships in the ADO.NET Entity Data Model (EDM)
Exploring the Payroll Entity Data Model
Summary
4
Working with Stored Procedures in the Entity Data Model
Working with Stored Procedures in the Entity Data Model
Mapping Stored Procedures to Functions in the EDM
Using Stored Procedures
Mapping Stored Procedures that Return Custom Entity Types
Summary
5
Working with Entity Client and Entity SQL
Working with Entity Client and Entity SQL
An Overview of the Entity SQL Language
Data Paging Using Entity SQL
Working with the ADO.NET Entity Client
Other Operations with Entity SQL
Summary
6
Working with LINQ to Entities
Working with LINQ to Entities
Introducing LINQ
Understanding the LINQ Architecture
Operators in LINQ
Querying Data Using LINQ
Summary
7
Working with the Object Services Layer
Working with the Object Services Layer
What are Object Services?
Adding, Modifying, and Deleting Objects
Attaching and Detaching Objects to and from the Object Context
Serializing and De-Serializing Entity Instances
Change Tracking and Identity Resolution Using ObjectContext
Inheritance in the Entity Framework
Implementing Complex Types in the EDM
Summary
8
Introducing ADO.NET Data Services
Introducing ADO.NET Data Services
Introducing ADO.NET Data Services
Prerequisites
Exposing Data as a Service Using ADO.NET Data Services
Understanding the System.Services.Data Namespace
Restricting Access to Resources
Working with the ADO.NET Data Service Client Library
Handling Exceptions in ADO.NET Data Services
Batching ADO.NET Data Services Requests to Improve Performance
References
Summary

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

In the previous chapter, we learned about the ADO.NET Entity Data Model (EDM), a conceptual model, that can be used to design the data access layer of your application. In this chapter, we will discuss how to map stored procedures in the EDM and use them in our applications. We will discuss the following points:

  • Mapping Stored Procedures to Functions in the EDM

  • Using Stored Procedures

  • Mapping Stored Procedures that return Custom Entity Types

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, we will learn how to create these Function Imports for our EDM.

To begin, let's refer to the Entity Data Model we created in chapter 2:

To create Function...

Previous Section
End of Section 1
Next Section