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
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