EntityFramework调用scaler函数throws必须声明标量变量

Question

我有缩放器函数countAbsence，它将employeeID作为输入

我称之为

int count = db.Database.SqlQuery<int>("SELECT [dbo].[countAbsence](@employeeID)", employeeID).FirstOrDefault();

但我得到低于异常

System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@employeeID".rn

Answer 1

您应该使用SqlParameter指定参数。

int count = db.Database
.SqlQuery<int>("SELECT [dbo].[countAbsence](@employeeID)", new SqlParameter("@employeeID", employeeID))
.FirstOrDefault();