Entity Framework 5 - Calling a stored procedure with parameters. Parameter not recognized

Question

I have an EF 5 app and I'm trying to call a stored procedure which takes a single parameter, as follows:

enter image description here

As you can see, I am supplying a parameter, and it's the correct name. Can anyone tell me where I'm going wrong? The image may be a bit hard to see. The error says:

"Procedure or function 'AddRowToPanelCdClAllData' expects parameter '@SubId' which was not supplied."

The line of code generating the error is as follows:

  internal void AddRowToPanelCdClAllData(string subId) 
    {
        this.Database.Database.ExecuteSqlCommand("AddRowToPanelCdClAllData", new SqlParameter("@SubId", subId));
    }

The value of 'subId' contains a value and is not null.

can you post the code line and the error as text instead of an image? it's impossible to read what that image says — Claies
– Claies, Commented Aug 6, 2013 at 20:06
This often occurs when the parameter you specify has a NULL value but the stored procedure parameter does not accept NULLs. Can you double check that subId does have a value? — Martin
– Martin, Commented Aug 6, 2013 at 20:06

Claies · Accepted Answer · 2013-08-06 20:11:45Z

8

try this:

this.Database.Database.ExecuteSqlCommand("AddRowToPanelCdClAllData @SubId",
                                          new SqlParameter("SubId", subId));

answered Aug 6, 2013 at 20:11

Claies

22.4k4 gold badges56 silver badges81 bronze badges

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

2 Comments

Randy Minder Over a year ago

I can't believe it, but that works. I never would have thought to try that.

hakan Over a year ago

What about multiple parameters?

Collectives™ on Stack Overflow

Entity Framework 5 - Calling a stored procedure with parameters. Parameter not recognized

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related