Calling a stored procedure with nothing to return using Entity Framework

Question

I understand this is the way we call a stored procedure using Entity Framework.

context.Database.SqlQuery<myEntityType>(     "mySpName @param1, @param2, @param3",     new SqlParameter("param1", param1),     new SqlParameter("param2", param2),     new SqlParameter("param3", param3) ); 

But, what if my stored procedure only a has couple of update statements and does not return anything, what should I put instead of myEntityType?

Answer 1

You want context.Database.ExecuteSqlCommand instead of SqlQuery

context.Database.ExecuteSqlCommand(     "mySpName @param1, @param2, @param3",     new SqlParameter("param1", param1),     new SqlParameter("param2", param2),     new SqlParameter("param3", param3) );