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

Mapping Stored Procedures that Return Custom Entity Types

In this section, we will discuss how we can use the EDM to map stored procedures that return miscellaneous data. Let's consider a scenario where we need to create an entity that returns the EmployeeID, FirstName, and LastName of all employees who are no longer working in the organization.

To do this, follow these steps:

  1. 1. Create a stored procedure called OldEmployees. Here is the script:

    Create procedure OldEmployees
as
Select EmployeeID, FirstName, LastName from Employee where LeavingDate is not null

  2. 2. Create an Entity called OldEmployees in the EDM with the property names matching the corresponding field names of the stored procedure.

  3. 3. Create an EntityType called OldEmployees in the CSDL

    <EntityType Name="OldEmployees">
<Key>
<PropertyRef Name="EmployeeID" />
</Key>
<Property Name="EmployeeID" Type="Int32" Nullable="false" />
<Property Name="FirstName" Type="Int32" Nullable="true" />
<Property...
Previous Section
End of Section 4
Next Section