Architecture and technologies of access to data
Object relational mapping
Presentation of the framework, tools
Entity framework vs other ORMs (NHibernate)
Entity Data Model vs Code First
Context and connection chain

Workshop: Setting up the Entity Framework in a project in Visual Studio

Definition of the context class (DbContext), life cycle
Log management
Definition of model classes and addition in the context
Database initializers Available
conventions, additions, management of datetime2
Mapping of tables: Attributes and Fluent API
Management of primary keys: simple, compound
Concurrency management: Concurrency Check, Timestamp
Mapping of calculated columns
Relations: OneToMany / ManyToOne, OneToOne, ManyToMany Inheritance
mapping strategies: TPH, TPC, TPS

Workshop: Creation, modification of a complete data model

Migrations: definition, interests
Activation of migrations, initial migration
Adding a migration and modification of the code: SQL queries
Applying a migration: update or regression of version
Going into production at a specified migration

Workshop: Creation of database manipulation with migrations

Understand the execution of queries
Management of connections
Control of transactions
Passage of an existing connection
Methods available from the DbContext: Creation, update and deletion
Management of association loads: Lazy vs Eager
Generation of stored procedures for the entities of the model and use
Optimizing the context cache, mistakes to avoid

Workshop: Updating data and modifying the model

Overview of available data retrieval methods
Using LINQ to Entities, errors to avoid
Queries with Entity SQL
Stored procedures and handling multiple results
Queries and changes to data using ADO.Net commands
Using DataSets
Using LINQ to SQL
Managing performance

Workshop: Writing multiple queries and processing results

Build Optimized Solutions Using Object Services

Using Design-

Generated Entity Framework Views Performance Monitoring

Perform Asynchronous Data Changes

Offline Data Caching Using XML

Using Sync Framework

Workshop: Query optimizations, offline data monitoring and caching