MVC 知识点学习3（linq to sql）

1、通过DbContext对象的Database.SqlQuery执行sql语句

string query = "SELECT EnrollmentDate, COUNT(*) AS StudentCount "
+ "FROM Person "
+ "WHERE Discriminator = ‘Student‘ "
+ "GROUP BY EnrollmentDate";
IEnumerable<EnrollmentDateGroup> data = db.Database.SqlQuery<EnrollmentDateGroup>(query);

return View(data.ToList());

MVC 知识点学习3（linq to sql）

原文：http://www.cnblogs.com/yhhdream/p/4465359.html