Description

During this internship, you will gain an understanding of all of the Entity Framework services, and see how to use them to simplify access to data in your .NET applications. You will learn how to perfect your queries and obtain optimal execution times.

Who is this training for ?

For whom ?

Developer in charge of data access in .NET applications. Project manager, software architect wishing to have a complete view of the possibilities of the Entity Framework solution.

Prerequisites

Training objectives

Training program

• Entity Framework
  • - Principle and Interest of Object Relational Mapping.
  • - Entity Framework Architecture.
  • - Getting started with the Visual Studio designer.
  • - Exercise: Creating a data model.
• LINQ
  • - Architecture and operation.
  • - Lambda expressions and extension methods.
  • - Executing queries using LINQ expressions and operators.
  • - Exercise: Creating LINQ To Objects and LINQ To Entities queries.
• Entity Data Model
  • - Introduction to VS.
  • - Schema of the EDMX file.
  • - Choice of a method (BaseFirst, ModelFirst, Code First).
  • - Services associated with the designer in VS.
  • - Comparison with other tools.
  • - Exercise: Manipulating the model.
• From the relational model to the object model
  • - Principles.
  • - Data mapping.
  • - The EDMX file.
  • - Conditional mapping.
  • - Inheritance.
  • - Customize entity validation.
  • - Complex and enumerated types.
  • - Exercise: Add entities to the model.
  • - Customize data mapping.
• Query with LINQ to Entities and Entity SQL
  • - SQL generation mechanism.
  • - LINQ To Entities queries.
  • - Use of Entity SQL.
  • - Loading data and related entities .
  • - Refreshing loaded data.
  • - Using stored procedures from the Entity Framework.
  • - Exercise: Common queries with the different scenarios loading related entities and updating loaded data.
• Data updates and customization of model generation
  • - Insertion, deletion, modification.
  • - Transactions.
  • - Competitive conflicts.
  • - Stored procedures.
  • - The code T4.
  • - Generate the base according to a model.
  • - POCO classes.
  • - Entity Framework 5 and 6 improvements.
  • - Model First Approach and Code First Approach (Annotations and Fluent API).
  • - Exercise: Perform data update operations with or without a stored procedure.
  • - Create POCO classes.
• Different uses of Entity Framework
  • - Linking to data in ASP.
  • - NET.
  • - Principle of a Dynamic Data site.
  • - Principle of a data service data.
  • - Data bindings in WPF, Silverlight and Windows Phone.
  • - Exercise: Using a data model in an ASP application.
  • - NET, with validation from the model.