linq内联左联
内联:没有into
左联:有into
例子:
from GoodsStore in this.GetCurrentDbSession.Tbl_OfficeSupplies_GoodsStoreDLL.LoadEntities(a => (Guid.Empty==GoodsID?true:a.GoodsID==GoodsID))
join goods in GetCurrentDbSession.Tbl_OfficeSupplies_GoodsDLL.LoadEntities(a => (Guid.Empty == GoodsCategoryID ? true : a.GoodsCategoryID == GoodsCategoryID) && (Guid.Empty == GoodsID ? true : a.ID == GoodsID))
on GoodsStore.GoodsID equals goods.ID
join goodscategory in this.GetCurrentDbSession.Tbl_OfficeSupplies_GoodsCategoryDLL.LoadEntities(a => (Guid.Empty == GoodsCategoryID ? true : a.ID == GoodsCategoryID))
on goods.GoodsCategoryID equals goodscategory.ID
join goodsSpecifications in GetCurrentDbSession.Tbl_OfficeSupplies_GoodsSpecificationDLL.LoadEntities(a => true)
on GoodsStore.GoodsSpecificationID equals goodsSpecifications.ID
join goodsUnit in GetCurrentDbSession.Tbl_OfficeSupplies_GoodsUnitDLL.LoadEntities(a => true)
on goods.UnitID equals goodsUnit.ID into tmp1
from tt in tmp1.DefaultIfEmpty()
select new
{
GoodsID = goods.ID == null ? Guid.Empty : tt.ID,
GoodsName = goods.Name,
GoodsCategoryName = goodscategory.Name,
GoodsSpecificationID = goodsSpecifications.ID == null ? Guid.Empty : goodsSpecifications.ID,
GoodsSpecificationName = goodsSpecifications.Name,
GoodsUnitName = tt.Name,
Count= GoodsStore.Count,
ProcurementCount=GoodsStore.ProcurementCount,
ApplyCount= GoodsStore.ApplyCount
};
最新文章
- 判断是否安装APP
- SpringMVC框架下实现JSON(类方法中回传数据到jsp页面,使用jQuery方法回传)
- spring bean生命周期管理--转
- css3-新属性-用户界面
- EncryptTransform
- ThinkPHP邮件发送函数示例
- mysql的事务处理与锁表
- [OJ] Find Minimum in Rotated Sorted Array
- NIOS中双CPU系统的构建
- hnsd11348tree(并查集)
- leetcode24,交换链表相邻的节点
- File 常用方法
- 为Lua5.3编写C模块简单示例
- 使用grafana provisioning通过配置方式添加datasource和dashboard
- DATEADD日期函数的使用
- vuex-Mutation(同步)
- 猫眼电影爬取(三):requests+pyquery,并将数据存储到mysql数据库
- (转载)Fiddler调式使用知多少(一)深入研究
- (转)Python数据分析之numpy学习
- Linux中下载、解压、安装文件(转)