Entity Framework 触发原始 SQL 查询

 

通过一下代码可以实现在Entity Framework 触发原始 SQL 查询

DBCL.DBEntities db = new DBCL.DBEntities();
var sql = "select sum(BQty) from BookTb1";
BookStockLbl.Text = db.Database.SqlQuery<int>(sql).Single() + "";

 其中db为数据库对象

BookStockLbl为前端接收数据的Lbl

 

参考博客——

https://blog.csdn.net/a859745210b66a6/article/details/133441722

 DBCL.DBEntities db = new DBCL.DBEntities(); var sql = "select sum(BQty) from BookTb1"; BookStockLbl.Text = db.Database.SqlQuery<int>(sql).Single() + "";