EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE


Entity Framework Training Course


Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Entity Framework training course (code: ENTFRM)

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


SEE MORE COURSES IN THIS CATEGORY

TRAINING COURSE OVERVIEW

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.


AUDIENCE

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



DETAILHIGHLIGHTS

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

 

  • 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

Call our Tech Team :  0800 028 6400  request info



PUBLIC COURSES (LONDON, UK)
 

26th Jun 2017 - 3 days £1495 see discount £1346
Book

see all dates


X

Show Discount for this course



PRIVATE COURSES


  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




 

 

view all case studies

 

 

Our inspiring and up-to-date courses gain exceptional feedback

►"great tips to help reduce build times"
► "we got access to exclusive content"
► "intensive 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