An Introduction To Entity Framework

Course: 34 Minutes

• Course Introduction
• What is the Entity Framework
• Downloading, Installing, and Updating Entity Framework
• Understanding the EF Modeling Languages
• Understanding DbContext vs. ObjectContext
• Entity Change Tracking
• Concurrency in Entity Framework

Working with LINQ To Entities

Course: 52 Minutes

• Reading Data with LINQ To Entities
• Updating Data with LINQ To Entities
• Using Functions with LINQ To Entities
• Using Stored Procedures with LINQ To Entities
• Implementing Transactions with LINQ To Entity Commands
• Understanding IQueryable vs. IEnumerable
• Validation in the DbContext

Working with Entity SQL

Course: 23 Minutes

• Connection, Command, and Reader
• Reading Data with Entity SQL
• Updating Data with Entity SQL
• Implementing Transactions with Entity SQL

Building Entity Data Models

Course: 1 Hour, 6 Minutes

• Using a Database-First Approach to EF Modeling
• Using a Model-First Approach to EF Modeling
• Using a Code-First Approach to EF Modeling
• Implementing Custom Code-First Database Mappings
• Code-First Entity Framework From an Existing Database
• Implementing Custom Code-First Conventions
• Implementing Custom Pluralization and Singularization
• Working with the Entity Framework Power Tools
• Database Migrations (Basic)

Implementing Hierarchies with Entity Framework

Course: 23 Minutes

• Table-per-Type Data Models with Entity Framework
• Table-per-Class Data Models with Entity Framework
• Table-per-Hierarchy Data Models with Entity Framework

Practice: Code-First Modeling and Queries

Course: 5 Minutes

• Exercise: Code-First Modeling and Executing Queries

Working with SQL Azure and Other Database Types

Course: 23 Minutes

• Course Introduction
• Working with SQL Azure
• Connection Resiliency Features
• Working with Non-Microsoft Databases

Configuring Entity Framework

Course: 47 Minutes

• Using Initializers and Factories
• Using Interceptors
• Code-Based Configuration
• Preparing for Production Configurations
• Custom Code Generation in Entity Framework
• Dependency Resolution in Entity Framework

Asynchronous and Deferred Queries in EF

Course: 16 Minutes

• Working with Asynchronous LINQ To Entities Commands
• Working with Asynchronous Entity SQL Commands
• Understanding Deferred Query Execution

Tuning Entity Framework Performance

Course: 49 Minutes

• Logging Queries and Database Commands
• Entity Caching in Entity Framework
• Understanding Lazy and Eager Loading
• Working with DbSet.AddRange/RemoveRange
• Creating a DbContext Using an Open Connection
• NGEN and Entity Framework Assemblies
• Pre-generating Views to Improve Performance
• .NET Assembly Interning for Production Environments

Integrating with Entity Framework

Course: 21 Minutes

• Building Web Sites and APIs with Entity Framework
• Integrating Entity Framework with WCF
• Unit Testing When Using Entity Framework

Practice: Performance Tuning

Course: 5 Minutes

• Exercise: Performance Tuning