Advanced Entity Framework

Developers wanting to learn more about the Entity Framework

Prerequisite
None

Expected Duration
160 minutes

Description
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.

Objective

Working with SQL Azure and Other Database Types

  • start the course
  • connect to a SQL Azure database with Entity Framework
  • recognize the default connection resiliency features of Entity Framework
  • use Entity Framework with non-Microsoft databases

Configuring Entity Framework

  • override default context initializers and factories with custom ones in Entity Framework
  • intercept calls to and responses from the database
  • configure Entity Framework using code instead of a config file
  • transform configuration files per environment in Entity Framework
  • use Entity Framework to generate entities and customize code generation
  • describe dependency resolution in Entity Framework

Asynchronous and Deferred Queries in EF

  • work with LINQ To Entity’s asynchronous commands
  • work with Entity SQL’s asynchronous commands
  • use deferred execution with LINQ To Entities

Tuning Entity Framework Performance

  • analyze various ways to log Entity Framework database queries and commands
  • learn how Entity Framework tracks the existence of entities to reduce database queries and handle updates
  • recognize the impact of lazy loading
  • use DbSet.AddRange and DbSet.RemoveRange to improve performance
  • use an existing connection to create a new DbContext
  • describe the use of NGEN in .NET
  • work with views in Entity Framework
  • use .NET assembly interning for Entity Framework deployments

Integrating with Entity Framework

  • integrate Entity Framework into an ASP.NET MVC and Web API project
  • integrate Entity Framework into a WCF project
  • implement unit testing of an application that uses Entity Framework

Practice: Performance Tuning

  • perform performance tuning and asynchronous operations in Entity Framework

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.