EXCEPtional training for .NET developers

Entity Framework Training Course

Create Commercial .NET Applications That Use Object /Relational Mapping Using The .NET Framework

1 Apr London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Entity Framework training course (code: ENTFRM)


Our ADO.NET Entity Framework training course will show you how to apply LINQ data transfer capability for relational databases.  The Entity Framework can be used in a number of ways, be starting with an existing database, creating a model or by creating entities in code.  The data model can be moved up from the physical structure of relational tables to a conceptual model which reflects common business objects.  Using the Entity Framework, developers can map entities to relational data, enabling the creation of new business objects that provide an abstracted layer to isolate applications from naming as well as structural changes in the schema, making it portable to most SQL databases.


Developers who wish to create commercial .NET applications that rely on Object / Relational Mapping using the .NET Entity Framework


Entity Framework Introduction

What is Entity Framework?


  • Database First
  • Model First
  • Code First 

Designing and Creating an Entity Data Model

Best practices 
Understanding CSDL, SSDL and MSL 
Querying the EDM XML 
Code Generation Options
ObjectContext vs DBContext
Entity Properties 
Navigation properties 
Mapping Stored Procedures
Adding to the Model
Mapping Views 
Working with many to many relationships

Querying Entity Data Models

Understanding LINQ and language features 
Anonymous Types 
Object Initializers 
Implicitly Typed Local Variables 
Extension methods 
Lambda Expressions 
Query Expressions 
Using Linq to Entities 
Using Lambdas 
Using Entity Sql 
Parameterized ObjectQuery 
QueryBuilder methods 
Using the EntityClient, EntityCommand and ExecuteReader

Code First

Creating Entities
Creating Complex Types
Attributes (DataAnnotations)
Navigation Properties
What are Migrations?
Enabling Migrations
Creating DBContext
Creating the Database

Entity queries in depth

Querying Across Associations 
Joins and Nested Queries 
Shaping results 
Deferred and Eager Loading 
Getting a Single Entity 
Wrapping and Unwrapping 

Editing and Updating Entity Data

ObjectContext and DBContext
Change Tracking 
SaveChanges Method 
Inserting Parents and Children 
EntityKey and EntityState 
Transaction Support

Validation and Customization

Validation and DataAnnotations
Partial Classes
Partial Methods

Customising the Data Model

Table Per Type (TPT) 
Table Per Hierarchy (TPH) 
Table Per Concrete Type (TPC) 
Querying Inherited Types 
Using Conditional Mapping 
Customisations not supported in the design


  • Entity Framework Introduction
  • Designing and Creating an Entity Data Model
  • Querying Entity Data Models
  • Code First
  • Entity queries in depth
  • Editing and Updating Entity Data
  • Validation and Customization
  • Customising the Data Model
Receive the latest version of this course into your inbox

See why people choose JBI

"At jbi even the sales team are technical so you are able to ask questions before the course"

Garima Aon

Blog (Show All)

JBI training course London UK

C# Language - Moving Forward

31/07/2018: Since the first release of .NET (in 2002) much has changed, both in the .NET Framework and the .NET languages. Notable language features added...

JBI training course London UK

React vs Angular - which framework and therefore which Training Course?

16/01/2018: React vs Angular which framework best for my organisation Speed, security and extensibility are the hallmarks of a great web service, and your...

JBI training course London UK

ASP.NET Core 2 training course | 5 Reasons why upgrade

12/01/2018: ASP.NET Core 2 is the successor to ASP.NET Core 1 and continues the theme of providing a framework for rapid creation of Web Applications making...

Case Studies (Show All)

JBI training course London UK

ASP.NET Core skills to rewrite applications for the latest Web and Database access technologies

15/01/2018: A development team had developed a range of applications using a number of .NET technologies over many years. However, in recent years the challenge...

JBI training course London UK

New MVC Core 1 skills help improve web development effort

19/10/2017: Over many years the members of this Software Engineering team have developed web applications using the popular .NET technology of ASP.NET WebForms....

JBI training course London UK

Power BI allows corporate data manipulation & visualization

13/10/2017: This organisation needed their Supply Chain department to get fully involved with Microsoft’s Power BI reporting product as soon as possible....


1st Apr 2019 - 3 days £1795

see all dates


Show Discount for this course


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote

  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote

Get in touch
0800 028 6400

Excellent feedback, consistently !

►"great tips help reduce build times"
► "we got access to exclusive content"
► "Short course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"

Newsletter ! Get exclusive news about upcoming programs, technical insights & special offers