Querying the Entity Framework

 

 

Overview of Querying Options in Entity Framework

 

 

 

 

 

 

 

 

 

 

 

 

 

LINQ to Entity and Query Execution

 

 

 

 

 

 

 

 

 

 

Demo of LINQ to Entity

 

 

 

 

 

 

 

 

 

 

Note: Above approach will degrade performance of Query

 

 

 

Solution of Above problem

 

 

 

 

 

 

 

 

 

 

 

 

LINQ methods with LAMBDAS

 

 

 

 

 

 

 

 

 

Entity SQL

 

Entity SQL is more dynamic in nature.  If you want to provide functionality like below which dynamic in nature.  It should be selected in runtime by users.  Then better choice is Entity SQL.

 

 

 

 

 

 

 

 

 

 

 

 

 

Entity SQL Query Builder Methods

 

 

 

 

 

Returning Streamed data with Entity SQL

 

 

 

 

 

Database queries created by Entity Framework

 

 

 

 

 

 

 

 

 

 

 

 

Digging Deeper into LINQ to Entities

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Query Projections

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Navigation properties in Queries

 

 

 

 

 

 

 

Entity Collection Logic in Queries

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Nested Queries and Joins

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Grouping

 

 

 

 

 

 

 

 

 

Using Single and First in Queries

 

 

 

 

 

First method in queries

 

 

 

Note: It will throw exception when there is no rows in result set.

 

 

 

 

 

 

 

Single Method in Queries

 

 

 

 

 

 

 

 

 

 

 

Using Get Object By Key

 

 

 

 

 

 

 

 

 

 

 

 

Note: TryGetObjectByKey will not return any error if it does’t find any objects in-memory or DB.

 

 

 

 

 

Blogger Labels: Framework,Overview,Options,LINQ,Query,Execution,Demo,Note,Above,performance,Solution,LAMBDAS,users,Builder,Methods,data,Database,Deeper,Entities,Projections,Navigation,properties,Queries,Collection,Logic,Joins,Single,method,exception,Object,TryGetObjectByKey,error,memory