Advanced Entity Framework

This course is included in our On-demand training solution.


This course explains and demonstrates how to integrate Entity Framework in a web project, how to improve and tune performance in various scenarios, how to configure Entity Framework, and how to work with other database types.

Target Audience

Developers wanting to learn more about the Entity Framework



Expected Duration

150 min.

Course Objectives

Course Introduction

Working with SQL Azure

  • connect to a SQL Azure database with Entity Framework
  • Connection Resiliency Features

  • recognize the default connection resiliency features of Entity Framework
  • Working with Non-Microsoft Databases

  • use Entity Framework with non-Microsoft databases
  • Using Initializers and Factories

  • override default context initializers and factories with custom ones in Entity Framework
  • Using Interceptors

  • intercept calls to and responses from the database
  • Code-Based Configuration

  • configure Entity Framework using code instead of a config file
  • Preparing for Production Configurations

  • transform configuration files per environment in Entity Framework
  • Custom Code Generation in Entity Framework

  • use Entity Framework to generate entities and customize code generation
  • Dependency Resolution in Entity Framework

  • describe dependency resolution in Entity Framework
  • Working with Asynchronous LINQ To Entities Commands

  • work with LINQ To Entity’s asynchronous commands
  • Working with Asynchronous Entity SQL Commands

  • work with Entity SQL’s asynchronous commands
  • Understanding Deferred Query Execution

  • use deferred execution with LINQ To Entities
  • Logging Queries and Database Commands

  • analyze various ways to log Entity Framework database queries and commands
  • Entity Caching in Entity Framework

  • learn how Entity Framework tracks the existence of entities to reduce database queries and handle updates
  • Understanding Lazy and Eager Loading

  • recognize the impact of lazy loading
  • Working with DbSet.AddRange/RemoveRange

  • use DbSet.AddRange and DbSet.RemoveRange to improve performance
  • Creating a DbContext Using an Open Connection

  • use an existing connection to create a new DbContext
  • NGEN and Entity Framework Assemblies

  • describe the use of NGEN in .NET
  • Pre-generating Views to Improve Performance

  • work with views in Entity Framework
  • .NET Assembly Interning for Production Environments

  • use .NET assembly interning for Entity Framework deployments
  • Building Web Sites and APIs with Entity Framework

  • integrate Entity Framework into an ASP.NET MVC and Web API project
  • Integrating Entity Framework with WCF

  • integrate Entity Framework into a WCF project
  • Unit Testing When Using Entity Framework

  • implement unit testing of an application that uses Entity Framework
  • Exercise: Performance Tuning