是否可以使用LINQ-to-SQL查询表达式或延迟可执行的方法链生成以下SQL查询? 数据结构 alt text http://www.freeimagehosting.net/uploads/e062a48837.jpgSelect Distinct ClassRoomTitle, Count(*) Over(Partition By ClassRoomNo) As [No Sessions Per Room], TeacherName, Count(*) Over(Partition By ClassRoomNo, TeacherName) As [No Sessions Per Teacher] From ClassRoom预期结果 alt text http://www.freeimagehosting.net...