草庐IT

Alt-left

全部标签

关于c#:Linq to SQL Left Join, Order and Group By Count

LinqtoSQLLeftJoin,OrderandGroupByCount我的这个查询运行良好:12345SELECTB.ID,B.NAME,COUNT(BU.ID)ASTOTALFROMBuildingBLEFTJOINBuildingUserBUONBU.ID_BUILDING=B.ID  GROUPBYB.ID,B.NAMEORDERBYCOUNT(BU.ID)DESC,B.NAME但是,当我将它转换为Linq时,我没有得到预期的结果。当左连接返回null时,它返回count=1。所以,我一直在尝试这个查询:12345678910111213141516varlist1=(frombu