EF之连表操作
UserChangeRecords.Where(c => c.UserID == userid)
.Join(ChangeRecords, a => a.RecordIndex, b => b.ID, (a, b) => new { a.ChangeMoney, b.RoomID })
.Join(GameRoomInfos, a => a.RoomID, b => b.RoomID, (a, b) => new { a.ChangeMoney, b.GameNameID })
.Join(GameInfos, a => a.GameNameID, b => b.NameID, (a, b) => new { b.ComName, a.ChangeMoney })
.GroupBy(a => a.ComName)
.Select(a => new { Summoney = a.Sum(c => c.ChangeMoney),ComName= a.Key });
我写了个如上的EF查询,解析不出来。也查不到转成什么sql了。
之前我碰到这些都是直接写的sql.今天有个新想法想试试,结果就EF这一块就这样了。网上关于EF连表的都只是写简单的Sql,关于join和groupby的都不是很详细