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

Exploring the Payroll Entity Data Model

The ADO.NET Entity Data Model allows the application to have its own view of the application's data.

Here again is the design view of the Payroll EDM we created in Chapter 2:

Note that the relationships and the respective fields are displayed along with their multiplicity. You can also see the Scalar and NavigationProperties. While the Scalar Properties section lists the attributes or the fields of the Entity, the NavigationProperties are those that denote the associations of a particular Entity with other entities. As an example, the Employee entity uses the Department and the Salary entities to relate its foreign keys DepartmentID and SalaryID respectively. Therefore, you can see that the Department and Salary entities are listed in the NavigationProperties section of the Employee entity.

The Mapping Details Window

Now we will take a look at the mappings details. That is, how the properties of the entities are mapped to the underlying database.

To...

Previous Section
End of Section 3
Next Section