我该如何重写为更LINQy？
|
我这里有这组数据。事件的属性为“ 0”，类型为“ 1”
List<Events> e;
List<Groups> g;
// Get the data from the database using dapper
using( var con = DataAccessMaster.GetOpenConnection( ) ) {
using( var multi = con.QueryMultiple( sprocname, new { StartDate = fromDate, EndDate = toDate }, commandType:CommandType.StoredProcedure ) ) {
e = multi.Read<Events>( ).ToList( );
g = multi.Read<Groups>().ToList();
}
}
// Only put the groups that belong to one another within the related event so that when we goto bind it will be painless
foreach ( var ev in e ) {
ev.EventGroups = new List<Groups>();
foreach ( Groups group in g.Where( Groups => ( ev.EventID == Groups.EventID ) ) ) {
ev.EventGroups.Add( group );
}
}
return e;
没有找到相关结果
已邀请:
3 个回复
恋卡
foreach (var ev in e) { ev.EventGroups = g.Where(groups => ev.EventID == groups.EventID) .ToList(); }课刊灭似
折叠内部循环。foreach ( var ev in e ) { ev.EventGroups = g.Where( Groups => ( ev.EventID == Groups.EventID ) ).ToList(); }抬澈帅沮
浮现在脑海。