Deep Dive Into The Ado.net Entity Framework

Deep Dive into the ADO.NET Entity Framework

Agenda Entity Data Model Advanced Mapping

Advanced querying Entity SQL Object Services

ADO.NET Metadata

Advanced Mapping Complex Types Table-Per-Hierarchy (TPH) Table-Per-Type (TPT) Query Views Defining Queries

Complex Types Customer FirstName LastName AddressLine1 AddressLine2

Customer FirstName LastName Address Address

City

AddressLine1

State

AddressLine2

Zip

City State Zip

Table Per Hierarchy Customer

Person

FirstName

FirstName

LastName

LastName

AddressLine1 AddressLine2 City State Zip CustomerType

Customer AddressLine1 AddressLine2 City State Zip

Discriminator

Table Per Type Person PersonID FirstName LastName

Customer PersonID AddressLine AddressLine2 1 City State Zip

Person FirstName LastName

Customer AddressLine1 AddressLine2 City State Zip

Query Views Customer FirstName LastName Address Entity SQL

City

Defining Queries Customer FirstName LastName Address T-SQL

City

Demo Advanced Mapping

Entity SQL Functions Canonical Store-specific

Paging TOP SKIP/LIMIT

Grouping

Canonical Functions Aggregate Bitwise Date/Time Math String

Demo Entity SQL

Object Services Transactions Optimistic Concurrency Compiled Queries

Demo LINQ To Entities

ADO.NET Metadata Exposes metadata Exposed from ObjectContext EdmConnection EdmDataReader

Metadata Workspace O-Space OC-Space C-Space CS-Space S-Space

Demo ADO.NET Metadata

Summary Entity Data Model Advanced Mapping

Advanced querying Entity SQL Object Services

ADO.NET Metadata