我是Linq查询的新手,我想将我的数据库查询转换为Linq。
这是我简单的SQL查询:
var query = "SELECT EnrollmentDate, COUNT(*) AS StudentCount "
+ "FROM Person "
+ "WHERE EnrollmentDate IS NOT NULL "
+ "GROUP BY EnrollmentDate";
var data = db.Database.SqlQuery<EnrollmentDateGroup>(query);
它正常运行,但是如何在Linq中编写此查询?我无法将group by
语句转换为Linq。这似乎有些棘手。
有人可以帮我吗?