• Online, Self-Paced
Course 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.

Learning Objectives

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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.