 |
|
|
|
|
|
ADO.NET Entity Framework
(24 Hours)
Course Description:
Data access is one of the crucial building blocks of every application.
The new Visual Studio 2008 brought with it big changes to the world of data access by introducing technologies like Entity Framework, Data Services and more.
The course will introduce and give a deep dive into ADO.Net Entity Framework features.
Trainer:
Eyal Vardi is a Microsoft Most Valuable Professional – MVP. Eyal lectures in the Interdisciplinary Center in Herzelia, and participated in many Microsoft technical conferances and discussion groups. Eyal has been part of cutting-edge software industry projects: he co-founded R-U-Sure (managed by Yossi Vardi of ICQ), TreeWay and VCI, where he has several different senior responsibilities managing development, product and business development.
Course Content:
 Module 1: Entity Framework Introduction
- Programming Against a Model
- The Entity in 'Entity Framework'
- Entity Framework Backend
- Entity Framework Features
|
Module 2: Exploring the Entity Data Model
- The EDM Within the Entity Framework
- The EDM in the Designer Window
- Inspecting the Model's XML
- CSDL: The Conceptual Schema Definition Language
- SSDL: The Store Schema Definition Language
- MSL: The Mappings
- Code Generation from EDM to Classes
|
Module 3: Querying Entity Data Models
- Querying the Model
- LINQ to Entities Queries
- Entity SQL Queries
- EntityClient Queries
- Translation of Queries to Database Queries
- Projections
- Querying Across Associations
- Shaped Data Returned by Queries
- Deferred Loading and Eager Loading Queries
|
Module 4: CUD Operations in Entity Framework
- How ObjectContext Manages Entities
- Adding New Entities
- Updating entities
- Deleting Entities
|
Module 5: Using Stored Procedures with the EDM
- Adding Stored Procedures to the Model
- Working with Functions
- Implementing Functions
|
Module 6: Working with the Object Services
- Query Processing
- Object Materialization
- The ObjectContext
- State Management and ObjectStateEntry
- Relationship Management
|
Module 7: Customizing Entities
- Partial Classes
- Customizable Methods
- Customizable Event Handlers
|
Module 8: Customizing Entity Data Models
- Mapping Table per Type Inheritance
- Implementing Table per Hierarchy Inheritance
- Mapping Table per Concrete (TPC) Type Inheritance
- Using Entity Splitting to Map a Single Entity to More Than One Table
- Using Conditional Mapping
- Creating Complex Types
- Using DefiningQuery
- Using QueryView
|
Module 9: Relationships and Associations
- Deconstructing Relationships in the Entity Data Model
- Defining Relationships Between Entities
|
|
|
|
|
|