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.
What is Entity Framework?
Approaches:
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
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
Creating Entities
Creating Complex Types
Defaults
Attributes (DataAnnotations)
Navigation Properties
What are Migrations?
Enabling Migrations
Creating DBContext
Creating the Database
Projections
Querying Across Associations
Joins and Nested Queries
Grouping
Shaping results
Deferred and Eager Loading
Getting a Single Entity
Wrapping and Unwrapping
ObjectContext and DBContext
Change Tracking
SaveChanges Method
Inserting Parents and Children
EntityKey and EntityState
Transaction Support
Validation and DataAnnotations
Partial Classes
MetaData
Partial Methods
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
See why people choose JBI
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...
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...
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...
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...
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....
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....
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
MVC - ASP.NET Core 1/Core 2
.NET Introduction
Reactive Extensions Rx
Advanced ASP.NET 4.5
Xamarin
ASP.NET Web Development
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"
Subscribe to our Newsletter – Receive the latest info on Tech courses & insights Subscribe