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/
Enter the password to open this PDF file:
File name:
-
File size:
-
Title:
-
Author:
-
Subject:
-
Keywords:
-
Creation Date:
-
Modification Date:
-
Creator:
-
PDF Producer:
-
PDF Version:
-
Page Count:
-
Preparing document for printing…
0%
Comments 0
Log in to post a comment