EntityFramework calling scaler function throws Must declare the scalar variable

Question

I have scaler function countAbsence that takes employeeID as input

I call it as below

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

But I get below exception

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

Answer 1

You should specify the parameters using SqlParameter.

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