ADO.NET Entity Framework Marcus Tillett - Microsoft Download Center

ADO.NET Entity Framework

Marcus Tillett

Overview

•
Introduction to ADO.NET Entity Framework


•
Using
the Visual Studio Tools


OO
Architect
vs.
Data
A
rchitect

•
Requirement

–
to use an OO language to manipulate entities

–
persist these in a relational database


•
Impedance mismatch

ADO.NET
Entity Framework

Mapping
Logical
Conceptual
Logical
Model

•
Logical layer stored as
schema definition
language (SSDL)

Mapping
Logical
Conceptual
Table
Conceptual
Model

•
Conceptual model is
an Entity Data Model
(EDM) schema stored
using conceptual
schema definition
language (CSDL)

Mapping
Logical
Conceptual
Entity
Mapping

•
A mapping
specification uses
mapping specification
language (MSL) to
connect the types
declared in CSDL to
the database
metadata declared in
SSDL

Mapping
Logical
Conceptual
Entity
Table
MSL Mapping

Business Logic

Business
Mapping
Logical
Conceptual
Entity
Table
Object
Example: Required Entity Model

Table per
Type

http://martinfowler.com

Table per
Type

Person
Applicant
Employee
Broker
Person
Applicant
Employee
Broker
Visual Studio
Designer

Remove Relation

Adding Inheritance

Mapping Entities

Using the Entities

Table per
Hierarchy

Person
Applicant
Employee
Broker
Person
Summary

•
ADO.NET
Entity Framework
provides a
separation between the data and the
entity


•
Supports different inheritance modelling patterns


•
Enables refactoring
of data model

Summary

•
http://www.vistasquad.co.uk


•
More information
http://blogs.msdn.com/adonet/