Basics of Entity Framework–Part 1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Entity Framework Architecture

 

 

 

 

 

Setting up the environment:

 

 

 

 

 

Create the First simple Entity Data Model (EDM):

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Querying with EDM:

 

 

 

 

 

 

 

 

 

 

 

Types of Entities in Entity Framework:

 

 

 

 

 

 

 

 

Note: Please Visit MSDN for more info.

 

 

 

 

 

 

 

 

 

 

 

 

Different type of Modelling Types in Entity Framework

 

Code First development with Entity Framework 4.1

 

 

 

Note: Please visit EF Code-First Tutorial to learn code first in detail.

 

 

 

 

 

 

Simple Code First Example:

 

 

 

 

 

 

 

 

Database Initialization:

 

 

 

 

 

 

 

 

Database Initialization Strategies in Code-First:

 

 

 

 

 

 

 

Turn off DB Initializer in Code-First:

 

 

 

Seed Database in Code-First:

 

 

 

 

 

Inheritance Strategy in Code-First:

 

 

TPH:
http://weblogs.asp.net/manavi/archive/2010/12/24/inheritance-mapping-strategies-with-entity-framework-code-first-ctp5-part-1-table-per-hierarchy-tph.aspx

TPT:
http://weblogs.asp.net/manavi/archive/2010/12/28/inheritance-mapping-strategies-with-entity-framework-code-first-ctp5-part-2-table-per-type-tpt.aspx

TPC:
http://weblogs.asp.net/manavi/archive/2011/01/03/inheritance-mapping-strategies-with-entity-framework-code-first-ctp5-part-3-table-per-concrete-type-tpc-and-choosing-strategy-guidelines.aspx

 

 

 

Configure Domain Classes in Code-First:

 

 

 

 

 

 

DataAnnotation in Code-First:

 

 

 

 

 

Fluent API in Code-First:

Visit MSDN for more information on DbModelBulder class.

 

 

EntityTypeConfiguration Class in Code-First:

 

Visit MSDN for more information on EntityTypeConfiguration class.

 

 

Fluent API Class Hierarchy:

 

 

 

Configure One-to-One Relationship:

 

 

 

 

 

 

 

 

 

Configure One-to-Many Relationship:

 

 

 

 

 

 

 

 

 

Configure Many-to-Many relationship:

 

 

 

 

 

 

 

 

 

Migration in Code-First:

 

 

 

Automated Migration:

 

 

 

 

 

 

 

 

Code-based Migration:

 

 

 

 

 

 

 

 

 

Model First development with Entity Framework

 

 

 

 

 

 

 

 

Database First development with Entity Framework 4.0

 

 

 

 

Entity Lifecycle:

 

 

 

 

ObjectStateManager:

 

 

 

 

 

Create POCO Entity:

 

 

 

 

 

 

 

 

 

 

 

Create Self-Tracking Entities:

 

 

 

 

 

Entity Relationships:

 

 

 

 

 

 

 

 

 

Querying Entity Graph:

 

 

 

 

 

 

 

 

Eager Loading with DBContext

 

 

 

 

 

 

 

 

 

 

Lazy Loading with DBContext

 

 

 

 

 

 

 

Explicit Loading with DBContext

 

 

 

 

 

 

 

Significance of SaveChanges:

 

 

 

 

 

Persistence in Entity Framework

 

 

 

 

Save New Entity with ObjectContext:

 

 

 

 

 

Update an Entity with ObjectContext:

 

 

 

 

 

 

 

Delete an Entity with ObjectContext:

 

 

 

 

 

 

 

 

DBContext vs ObjectContexts

 

 

 

 

 

Create EDM and DBContext in EF 4.3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

DBContext Class

 

 

 

 

 

 

DBSet Class

 

 

 

 

 

 

DBEntityEntry Class

 

 

 

 

 

Working with Entity Property Value

 

 

 

 

Local Data

 

 

 

 

 

Execute Raw SQL Query

 

 

 

 

 

 

 

Validate Entity

 

 

 

 

 

 

 

 

Add Entity using DBContext

 

 

 

 

 

 

 

Add One-to-One Relationship Entity Graph using DBContext

 

 

 

 

 

 

Add One-to-Many Relationship Entity Graph using DBContext

 

 

 

 

 

 

 

 

Add Many-to-Many Relationship Entity Graph using DBContext

 

 

 

 

 

 

Update Entity using DBContext

 

 

 

 

 

Update One-to-One Entity using DBContext

 

 

 

 

 

 

Update One-to-Many Entity using DBContext

 

 

 

 

 

 

 

Update Many-to-Many Entity using DBContext

 

 

 

 

 

 

Delete Entity using DBContext

 

 

 

 

 

 

Stored Procedure in Entity Framework:

 

 

 

 

Execute Stored Procedure using DBContext

 

 

 

 

 

 

 

 

 

 

Add/Update data using Stored Procedure:

 

 

 

 

 

 

 

DefiningQuery in Entity Framework:

 

 

 

 

 

 

 

 

Data binding with ASP.Net application:

 

 

 

 

 

 

Blogger Labels: Basics,Framework,Part,Architecture,environment,Create,Data,Model,Types,Entities,Note,Visit,MSDN,info,Different,Code,development,Tutorial,Simple,Example,Database,Initialization,Strategies,Turn,Initializer,Inheritance,Strategy,archive,hierarchy,guidelines,Configure,Domain,Classes,DataAnnotation,Fluent,information,DbModelBulder,EntityTypeConfiguration,Class,Relationship,Many,Migration,Lifecycle,ObjectStateManager,POCO,Self,Relationships,Graph,Eager,DBContext,Lazy,Explicit,Significance,SaveChanges,Persistence,Save,ObjectContext,Update,Delete,ObjectContexts,DBSet,DBEntityEntry,Value,Local,Execute,Query,Validate,Procedure,DefiningQuery,weblogs,manavi,aspx