Entity Framework Training Course

Entity Framework Introduction

What is Entity Framework?

Approaches:

• Database First
• Model First
• Code First 

Designing and Creating an Entity Data Model

Motivation 
Best practices 
Understanding CSDL, SSDL and MSL 
Querying the EDM XML 
Code Generation Options
ObjectContext vs DBContext
Entity Properties 
Navigation properties 
Mapping Stored Procedures
Adding to the Model
Functions
Mapping Views 
Working with many to many relationships

Querying Entity Data Models

Understanding LINQ and language features 
Anonymous Types 
Object Initializers 
Implicitly Typed Local Variables 
Extension methods 
Lambda Expressions 
Query Expressions 
Using Linq to Entities 
Using Lambdas 
Using Entity Sql 
Parameterized ObjectQuery 
QueryBuilder methods 
Using the EntityClient, EntityCommand and ExecuteReader

Code First

Creating Entities
Creating Complex Types
Defaults
Attributes (DataAnnotations)
Navigation Properties
What are Migrations?
Enabling Migrations
Creating DBContext
Creating the Database

Entity queries in depth

Projections 
Querying Across Associations 
Joins and Nested Queries 
Grouping 
Shaping results 
Deferred and Eager Loading 
Getting a Single Entity 
Wrapping and Unwrapping 

Editing and Updating Entity Data

ObjectContext and DBContext
Change Tracking 
SaveChanges Method 
Inserting Parents and Children 
EntityKey and EntityState 
Transaction Support

Validation and Customization

Validation and DataAnnotations
Partial Classes
MetaData
Partial Methods

Customising the Data Model

Inheritance 
Table Per Type (TPT) 
Table Per Hierarchy (TPH) 
Table Per Concrete Type (TPC) 
Querying Inherited Types 
Using Conditional Mapping 
Customisations not supported in the design