MN314

Master the ADO.NET Entity Framework

Everything you need to know about Entity Framework, the open-source ORM from Microsoft.

85%

overall satisfaction for this course

?Average calculated from scores obtained from 12 participants who took this course.
  • Duration 2 days
  • Regular fee 945
  • Preferential fee 795?
  • Locations
    • Quebec City
    • Montreal
  • Laboratory
    course
SUMMARY
DETAILS

Objectives

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

Targeted audience

All development positions.

Prerequisite

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

Customer Testimonials

Relevant training exposing the different possibilities and benefits of Entity Framework.

Thomas G. / Analyste-Programmeur, ACCEO Solutions Inc.

Content

  • 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 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)

DATES*

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

    October 30 to October 31 2017

  • Montreal

    January 18 to January 19 2018

  • Quebec City

    March 8 to March 9 2018

  • Montreal

    April 12 to April 13 2018

Trainer(s) assigned(s)

Other course(s) in this category