Entity Framework ExecuteSqlCommand Missing Input Parameter

Question

I'm having an issue with the ExecuteSqlCommand() method in Entity Framework (EF). I have the following SQL Server stored procedure:

EXEC SomeSchema.SomeTableInsert
@Id = 1, 
@SomeData = 'This is some random data', 
@UserId = 500

and it works without any issues. When I try to use EF's ExecuteSqlCommand() method, I get the following error:

Procedure or function 'SomeTableInsert' expects parameter '@UserId', which was not supplied.

Here is the C# code:

var sql = "SomeSchema.SomeTableInsert @Id, @SomeData, @UserId";
var sqlParameters = new List<SqlParameter> 
{ 
    new SqlParameter("@Id", 1),
    new SqlParameter("@SomeData", "This is some random data"), 
    new SqlParameter("@UserId", 500)
};

dbContext.Database.ExecuteSqlCommand(sql, sqlParameters.ToArray<object>());

I don't understand why I'm getting this error. The UserId parameter is not missing and it has a valid value. Any ideas?

Update:

Here is the SQL that is run on SQL Server:

exec sp_executesql 
    N'SomeSchema.SomeTableInsert @Id, @SomeData, @UserId',
    N'@Id int,@SomeData nvarchar(5),@UserId int',
    @Id=1,
    @SomeData='This is some random data',
    @UserId=500

Does it work if youwrite it like ExecuteSqlCommand(sql, new SqlParameter("@Id", 1), new SqlParameter("@SomeData", "This is some random data"), new SqlParameter("@UserId", 500); ? — Mark C.
– Mark C., Commented Mar 31, 2015 at 20:15
I tried that and it's still failing. I believe it's something with the generated SQL. — Halcyon
– Halcyon, Commented Mar 31, 2015 at 21:04

Praveen Paulose · Accepted Answer · 2015-03-31 20:25:12Z

1

var sql = "SomeSchema.SomeTableInsert @Id, @SomeData, @UserId";
var sqlParameters = new List<SqlParameter> 
{ 
    new SqlParameter("Id", 1),
    new SqlParameter("SomeData", "This is some random data"), 
    new SqlParameter("UserId", 500)
};

dbContext.Database.ExecuteSqlCommand(sql, sqlParameters.ToArray<object>());

Remove the @ prefix from within the SqlParameter.

answered Mar 31, 2015 at 20:25

Praveen Paulose

5,7711 gold badge19 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Halcyon Over a year ago

This isn't making any difference. See my edit for the generated SQL.

Praveen Paulose Over a year ago

Did you remove the @prefix. Your generated SQL still shows it.

Collectives™ on Stack Overflow

Entity Framework ExecuteSqlCommand Missing Input Parameter

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related