Master the ADO.NET Entity Framework

Everything about Entity Framework, the open-source ORM from Microsoft.

  • Duration 2 days
  • Regular fee 895
  • Preferential fee 750?
  • Locations
    • Quebec City
    • Montreal
  • New course
  • Laboratory


To provide the knowledge and skills required to develop database applications with the ADO.NET Entity Framework using .NET technologies from Microsoft.

Targeted audience

Application developers.


Experience with application development using Visual Basic .NET (Course MN204) or Visual C# .NET (Course MN201). Familiarity with database application development using ADO.NET.


  • Overview of ADO.NET
  • What is an ORM?
  • The history of Entity Framework
  • ObjectContext vs DbContext
  • Entity Framework and Entity Data Model
  • Creating and mapping a conceptual model using the designer and Code First
  • Entity Framework and conventions
  • Configuring and mapping properties and relations using annotations
  • Configuring and mapping properties and relations using the Fluent API
  • Using LINQ to query the model
  • Complex requests, and optimizing LINQ requests
  • Mapping complex types
  • Entity Framework and functions
  • Entity Framework and stored procedures
  • Generating the model starting from an existing database
  • Using Code First with an existing database
  • Using Code First to generate the database
  • Using migration files to update the database
  • New features in EF 7 (renamed Entity Framework Core 1.0)


*Unless stated otherwise, all sessions are in French.
  • Quebec City

    July 12 to July 13 2017

  • Montreal

    October 12 to October 13 2017

  • Quebec City

    October 30 to October 31 2017

Trainer(s) assigned(s)

Other course(s) in this category