Call stored procedure using ExecuteSqlCommand (expects parameters which was not supplied)
c# entity-framework sql-server stored-procedures
Accepted Answer
The parameters in the SQL string you are performing are missing. Attempt setting up your parameters with a "@" before the name, and then alter the ExecuteSqlCommand call to:
context.Database.ExecuteSqlCommand("exec MySchema.MyProc @customerId, @indicatorTypeId, @indicators, @startDate, @endDate", customerIdParam, typeIdParam, tableParameter, startDateParam, endDateParam);
Popular Answer
This operates:
var bookIdParameter = new SqlParameter();
bookIdParameter.ParameterName = "@BookId";
bookIdParameter.Direction = ParameterDirection.Output;
bookIdParameter.SqlDbType = SqlDbType.Int;
var authors = context.Database.ExecuteSqlCommand("usp_CreateBook @BookName, @ISBN, @BookId OUT",
new SqlParameter("@BookName", "Book"),
new SqlParameter("@ISBN", "ISBN"),
bookIdParameter);
Related Questions
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
