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?
Understanding CSDL, SSDL and MSL
Querying the EDM XML
Code Generation Options
ObjectContext vs DBContext
Mapping Stored Procedures
Adding to the Model
Working with many to many relationships
Understanding LINQ and language features
Implicitly Typed Local Variables
Using Linq to Entities
Using Entity Sql
Using the EntityClient, EntityCommand and ExecuteReader
Creating Complex Types
What are Migrations?
Creating the Database
Querying Across Associations
Joins and Nested Queries
Deferred and Eager Loading
Getting a Single Entity
Wrapping and Unwrapping
ObjectContext and DBContext
Inserting Parents and Children
EntityKey and EntityState
Validation and DataAnnotations
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....
Bring a JBI course to your office
and train a whole team onsite
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"
Subscribe to our Newsletter – Receive the latest info on Tech courses & insights Subscribe