Entity Framework with Object / Relational Mapping in .NET Training Course
| Course code: |
ENTFRM |
| Details: |
|
| Onsite | Enquire about bringing this course to your offices |
| Who should attend: |
Developers who wish to create commercial .NET applications that rely on Object / Relational Mapping using the .NET Entity Framework |
| Prerequisite skills: |
Application Development experience in a .NET Language (e.g. C# / VB.NET) |
Course Outline
The ADO.NET Entity Framework provides LINQ data transfer capability for relational databases. The data model is 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. The resultant data model can be used across high-level functions such as query and retrieval, reporting, caching, replication, and Business Intelligence activities.
Entity Framework with Object / Relational Mapping in .NET Training Course Outline
Designing and Creating an Entity Data Model
Motivation
Best practices
Understanding CSDL, SSDL and MSL
Querying the EDM XML
Code Generation
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
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
Querying the EDM Structures with the MetaDataWorkspace API
Editing and Updating Entity Data
Object Services & ObjectContext
Change Tracking
SaveChanges Method
Inserting Parents and Children
EntityKey and EntityState
Transaction Support
Customising Entities
Adding business and validation logic through:
- Partial Classes
- Customisable methods
- Customisable Event Handlers
- Custom Properties
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 designer
Creating Complex Types
Using QueryView
