110,534
社区成员
发帖
与我相关
我的任务
分享
string sql = @"select a.ID as FID,a.MODULENAME as FMODULENAME,a.ICON as FICON,b.ID as CID,b.MODULENAME as CMODULENAME,b.ICON as CICON,b.URL from (
select * from
b_commission a where a.pid=0
) a
inner join
(
select * from B_COMMISSION a where a.PID<>0
) b
on a.ID=b.PID";
IEnumerable<dynamic> list = db.Database.SqlQuery<dynamic>(sql);
foreach (var item in list)
{
//此时会报错,提示object未包含FID的定义。
Console.WriteLine(item.FID);
}