Question

LINQ怎么写多表分组统计

select
KeyDB as 服务器名,
(select count(KeyDB) from CompanyTotal where CompanyTotal.KeyDB=t.KeyDB and CreateTime <= '2016-7-7' and (CompanyType != 'CarSynthesizeMonitor'and CompanyType != 'Service')) as '运输',
(select count(KeyDB) from CompanyTotal where CompanyTotal.KeyDB=t.KeyDB and CreateTime <= '2016-7-7' and (CompanyType = 'CarSynthesizeMonitor' or CompanyType = 'Service')) as '维修',
(select count(KeyDB) from UserTotal where UserTotal.KeyDB=t.KeyDB and CreateTime <= '2016-7-7' ) as '车辆',
(select count(KeyDB) from VehicleTotal where VehicleTotal.KeyDB=t.KeyDB and CreateTime <= '2016-7-7' ) as '人员'
from
(
select KeyDB from CompanyTotal group by KeyDB
union
select KeyDB from CompanyTotal group by KeyDB
union
select KeyDB from UserTotal group by KeyDB
union
select KeyDB from VehicleTotal group by KeyDB
) as t

该怎么改成LINQ？？？

Answer 1

这么复杂最好还是不要改成linq了 因为用linq写起来更复杂 你直接做成视图或者存储过程 更方便 一样能用linqToSQL调用