EntityFramework優(yōu)于LinqToSQL的小知識點(diǎn)
Find方法:
//Find方法
//用于通過主鍵查找單個(gè)對象。
//優(yōu)點(diǎn):Find會首先在Context的緩存中查找,如果查找到,則直接返回,避免的數(shù)據(jù)庫的查詢。FirstOrDefault會始終進(jìn)行數(shù)據(jù)庫查詢,而不管緩存中是否已經(jīng)存在
Guid actionItemId = Guid.NewGuid();
ActionItem actionItem = context.ActionItems.Find(actionItemId);
//用于通過主鍵查找單個(gè)對象。
//優(yōu)點(diǎn):Find會首先在Context的緩存中查找,如果查找到,則直接返回,避免的數(shù)據(jù)庫的查詢。FirstOrDefault會始終進(jìn)行數(shù)據(jù)庫查詢,而不管緩存中是否已經(jīng)存在
Guid actionItemId = Guid.NewGuid();
ActionItem actionItem = context.ActionItems.Find(actionItemId);
Include方法
//Include方法(首先引用System.Data.Entity命名空間)
//用于進(jìn)行一次查詢,便將相關(guān)的對象都一次性查找到。
//優(yōu)點(diǎn):可極大地減少數(shù)據(jù)庫查詢次數(shù),極大地提高頁面性能。
IEnumerable<ActionItem> actionItems = context.ActionItems
.Include(item => item.Histories)
.Include(item => item.ActionItemMembers)
.Where(item => item.AssigneeId == this.User.Identity.Name);
//以下是MSDN對Include的用法的描述
//To include a single reference: query.Include(e => e.Level1Reference).
//To include a single collection: query.Include(e => e.Level1Collection).
//To include a reference and then a reference one level down: query.Include(e => e.Level1Reference.Level2Reference).
//To include a reference and then a collection one level down: query.Include(e => e.Level1Reference.Level2Collection).
//To include a collection and then a reference one level down: query.Include(e => e.Level1Collection.Select(l1 => l1.Level2Reference)).
//To include a collection and then a collection one level down: query.Include(e => e.Level1Collection.Select(l1 => l1.Level2Collection)).
//To include a collection, a reference, and a reference two levels down: query.Include(e => e.Level1Collection.Select(l1 => l1.Level2Reference.Level3Reference)).
//To include a collection, a collection, and a reference two levels down: query.Include(e => e.Level1Collection.Select(l1 => l1.Level2Collection.Select(l2 => l2.Level3Reference))).
//用于進(jìn)行一次查詢,便將相關(guān)的對象都一次性查找到。
//優(yōu)點(diǎn):可極大地減少數(shù)據(jù)庫查詢次數(shù),極大地提高頁面性能。
IEnumerable<ActionItem> actionItems = context.ActionItems
.Include(item => item.Histories)
.Include(item => item.ActionItemMembers)
.Where(item => item.AssigneeId == this.User.Identity.Name);
//以下是MSDN對Include的用法的描述
//To include a single reference: query.Include(e => e.Level1Reference).
//To include a single collection: query.Include(e => e.Level1Collection).
//To include a reference and then a reference one level down: query.Include(e => e.Level1Reference.Level2Reference).
//To include a reference and then a collection one level down: query.Include(e => e.Level1Reference.Level2Collection).
//To include a collection and then a reference one level down: query.Include(e => e.Level1Collection.Select(l1 => l1.Level2Reference)).
//To include a collection and then a collection one level down: query.Include(e => e.Level1Collection.Select(l1 => l1.Level2Collection)).
//To include a collection, a reference, and a reference two levels down: query.Include(e => e.Level1Collection.Select(l1 => l1.Level2Reference.Level3Reference)).
//To include a collection, a collection, and a reference two levels down: query.Include(e => e.Level1Collection.Select(l1 => l1.Level2Collection.Select(l2 => l2.Level3Reference))).
EntityFunctions類
//EntityFunctions類(首先引用System.Data.Objects命名空間)
//有些Linq To Entity不支持的查詢,需用EntityFunctions里的方法
context.ActionItems.Where(item => EntityFunctions.TruncateTime(item.CreateTime) == DateTime.Today);
//有些Linq To Entity不支持的查詢,需用EntityFunctions里的方法
context.ActionItems.Where(item => EntityFunctions.TruncateTime(item.CreateTime) == DateTime.Today);

浙公網(wǎng)安備 33010602011771號