Entity Framework training course

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

NEXT COURSE 9 December (3 days £1795 + VAT) BOOK NOW

JBI training course London UK

  • Introduction to Entity Framework 
  • Design and create an Entity Data Model
  • Learn Querying Entity Data Models
  • Use Code First to create entities and complex types
  • Learn Entity queries in depth
  • Learn to Edit and Update Entity Data
  • ObjectContext and DBContext
  • Learn Validation and Customization
  • How to Customise the Data Model

FULL COURSE DETAILS

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.


FULL COURSE DETAILS
JBI training course London UK
JBI training course London UK

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

FULL COURSE DETAILS

Related Courses

Entity Framework Introduction

What is Entity Framework?

Approaches:

  • Database First
  • Model First
  • Code First 

Designing and Creating an Entity Data Model

Motivation 
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
Functions
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
Defaults
Attributes (DataAnnotations)
Navigation Properties
What are Migrations?
Enabling Migrations
Creating DBContext
Creating the Database

Entity queries in depth

Projections 
Querying Across Associations 
Joins and Nested Queries 
Grouping 
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
MetaData
Partial Methods

Customising the Data Model

Inheritance 
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

 

 
Course Updates & Newsletter
 
 

Receive the latest version of this course by email & subscribe to our Newsletter



CONTACT
0800 028 6400

enquiries@jbinternational.co.uk

SHARE

Corporate Policies     Terms & Conditions
JB International Training Ltd  -  Company number 08458005

Registered address 1345 High Road, London, N20 9HR