报错不支持ToList()!怎么实现这种子查询? 返回
SqlSugar
老数据
2
2352
悬赏:0 飞吻
var list = db.DataBase
.Queryable<Store, StoreSelectGoods, Goods>((a, b, c) => a.Id == StoreId && b.StoreId == a.Id && c.Id == b.GoodsId)
.Select((a, b, c) => new ShowGoods() {
BrandId = c.BrandId,
CategoryId = c.CategoryId,
Images = db.DataBase.Queryable<GoodsImg>().Where(d=>d.GoodsId==c.Id).Select(d=>new GoodsImg()).ToList(),
CreateTime = c.CreateTime,
ExpressAmount = c.ExpressAmount,
ExpressRemak = c.ExpressRemak,
GoodsNo = c.GoodsNo,
GoodsStatus = c.GoodsStatus,
Id = c.Id,
Name = c.Name,
PlatformId = c.PlatformId,
Title = c.Title,
Sale = db.Sale.GetSingle(d => d.GoodsId == c.Id),
UploadTime = c.UploadTime,
DefaultSku = db.DataBase.Queryable<GoodsSku>().OrderBy(d=>d.Sort,OrderByType.Asc).Take(1).ToList().SingleOrDefault()
}).ToList();
热忱回答(2)
-
fate stay night VIP0
2018/5/18不支持一对多查询目前
0 回复 -
fate stay night VIP0
2018/5/18子查询用法看文档
0 回复