EF里单个实体的增查改删以及主从表关联数据的各种增删改查课案.docx

EF里单个实体的增查改删以及主从表关联数据的各种增删改查?本文目录EF对单个实体的增查改删增加单个实体查询单个实体修改单个实体删除单个实体EF里主从表关联数据的各种增删改查 增加（增加从表数据、增加主从表数据）查询（根据主表找从表数据、根据从表找主表数据）修改（修改从表的外键）删除（删除主从表关系、删除主表数据、删除主从表数据、修改从表数据外键）补充内容 SaveChanges方法提交多次操作DbSet.Add方法返回当前实体源码和系列文章导航注：本章节多次演示了各种删除，要重复查看效果，需要解开注释初始化数据方法。一、EF对单个实体的增查改删?增加单个实体：///summary/// 增加单个实体////summaryprivatestaticvoidAddMachuPicchu() {using (var context = newDbContexts.DataAccess.BreakAwayContext()) {varmauchuPicchu = newDbContexts.Model.Destination { Name = Machu Picchu, Country = Peru };context.Destinations.Add(mauchuPicchu);context.SaveChanges(); } }产生的insert sql：execsp_executesqlNinsert [baga].[Locations]([LocationName], [Country], [Description], [Photo], [TravelWarnings], [ClimateInfo])values (@0, @1, null, null, null, null)select [LocationID]from [baga].[Locations]where @@ROWCOUNT 0 and [LocationID] = scope_identity(),N@0 nvarchar(200),@1 nvarchar(max) ,@0=NMachu Picchu,@1=NPeru查询单个实体：///summary/// 查询单个实体////summaryprivatestaticvoidGetGreatBarrierReef() {using (var context = newDbContexts.DataAccess.BreakAwayContext()) {var destination = context.Destinations.Find(4);Console.WriteLine(destination.Name); } }生成的select sql（find方法生成的查询sql略复杂点，普通的linq查询或者Lambda表达式写法就简单许多了）：execsp_executesql NSELECT [Limit1].[LocationID] AS [LocationID], [Limit1].[LocationName] AS [LocationName], [Limit1].[Country] AS [Country], [Limit1].[Description] AS [Description], [Limit1].[Photo] AS [Photo], [Limit1].[TravelWarnings] AS [TravelWarnings], [Limit1].[ClimateInfo] AS [ClimateInfo]FROM ( SELECT TOP (2) [Extent1].[LocationID] AS [LocationID], [Extent1].[LocationName] AS [LocationName], [Extent1].[Country] AS [Country], [Extent1].[Description] AS [Description], [Extent1].[Photo] AS [Photo], [Extent1].[TravelWarnings] AS [TravelWarnings], [Extent1].[ClimateInfo] AS [ClimateInfo] FROM [baga].[Locations] AS