一、延迟加载:LazyLoading使用延迟加载,关联的实体必须标注为virtual。 本例是标注Destination类里的Lodgings为virtual。因为先发sql去查询主键对象,然后根据主键id去从表里查相关联的数据。 private static void TestLazyLoading(){ using (var context = new CodeFirst.DataAccess.BreakAwayContext()) { var canyon = (from d in context.Destinations where d.Name == "Grand Canyon" select d).Single(); var distanceQuery = from l in canyon.Lodgings //延迟加载canyon的所有.Lodgings where l.Name == "HuangShan Hotel" select l; foreach (var lodging in distanceQuery) Console.WriteLine(lodging.Name); } } 改进:在数据库中操作,显示加载 private static void QueryLodgingDistancePro(){ using (var context = new CodeFirst.DataAccess.BreakAwayContext()) { var canyon = (from d in context.Destinations where d.Name == "Grand Canyon" select d).Single(); var lodgingQuery = context.Entry(canyon).Collection(d => d.Lodgings).Query();//接下来的查询在数据库中,包括Count()等 var distanceQuery = from l in lodgingQuery where l.Name == "HuangShan Hotel" select l; foreach (var lodging in distanceQuery) Console.WriteLine(lodging.Name); } } 二、贪婪加载:EagerLoadingprivate static void TestEagerLoading(){ using (var context = new CodeFirst.DataAccess.BreakAwayContext()) { // var allDestinations = context.Destinations.Include(d => d.Lodgings); var AustraliaDestination = context.Destinations.Include(d => d.Lodgings).Where(d => d.Name == "Bali"); //context.Lodgings.Include(l => l.PrimaryContact.Photo); //context.Destinations.Include(d => d.Lodgings.Select(l => l.PrimaryContact)); //context.Lodgings.Include(l => l.PrimaryContact).Include(l => l.SecondaryContact); foreach (var destination in AustraliaDestination) { foreach (var lodging in destination.Lodgings) Console.WriteLine(" - " + lodging.Name); } } } 三、显示加载:ExplicitLoading1、查找导航属性为一个集合的 private static void LoadRelateData(){ using (var context = new CodeFirst.DataAccess.BreakAwayContext()) { var canyon = (from d in context.Destinations where d.Name == "Grand Canyon" select d).Single(); context.Entry(canyon).Collection(d => d.Lodgings).Load(); //显示加载 foreach (var lodging in context.Lodgings.Local) Console.WriteLine(lodging.Name); } } 2、查找导航属性为一个实体对象的 private static void LoadPrimaryKeyData(){ using (var context = new CodeFirst.DataAccess.BreakAwayContext()) { var lodging = context.Lodgings.First(); context.Entry(lodging).Reference(l => l.Destination).Load(); foreach (var destination in context.Destinations.Local) //遍历的是内存中的Destinations数据 Console.WriteLine(destination.Name); } } 到此这篇关于Entity Framework主从表数据加载方式的文章就介绍到这了。希望对大家的学习有所帮助,也希望大家多多支持脚本之家。 |
本文实例为大家分享了C# GDI+实现时钟表盘的具体代码,供大家参考,具体内容如下一、...
目录一、正则表达式应用举例1、C#校验合法性:2、C#限制输入3、正则表达式匹配闭合HTM...
本文实例为大家分享了C#实现图形界面的时钟的具体代码,供大家参考,具体内容如下秒针...
目录一、ObjectContext对象上下文1、ObjectContext和DbContext的对比2、ObjectContext...
IronPython是一种在 .NET及 Mono上的 Python实现,由微软的 Jim Hugunin所发起,是一...
本文实例为大家分享了使用C#写一个时钟,供大家参考,具体内容如下时钟是这样的一共使...
一、介绍Topshelf是一个开源的跨平台的宿主服务框架,支持Windows和Mono,只需要几行...
本文实例为大家分享了C#实现动态数字时钟和日历的具体代码,供大家参考,具体内容如下...