The parameterized query is not recognizing parameter in EF5?

Question

I am trying to execute a stored procedure from EF5 using Database.SqlQuery. But 2nd parameter is not recognizing here.

Error: "The parameterized query '(@custNum nvarchar(7), @PrimaryDisc bigint, @SecondaryDisc bigint)' expects the parameter '@PrimaryDisc', which was not supplied."

Code

var results = _MiscContext.Database.SqlQuery<TempTechDisciplines>(
        "exec sp_getTechnicalDiscipline @CustNum, @PrimaryDisc, @SecondaryDisc", 
        new SqlParameter("custNum", CustomerNum), 
        new SqlParameter("PrimaryDisc",SqlDbType.BigInt, 0), 
        new SqlParameter("SecondaryDisc",SqlDbType.BigInt, 0))
        .ToList<TempTechDisciplines>();

What is the issue here?

Try @ while adding parameter names like : new SqlParameter("@custNum", CustomerNum), — Habib
– Habib, Commented Nov 26, 2013 at 18:23
I don't think you're using the SqlParameter constructor you think you are. — Joachim Isaksson
– Joachim Isaksson, Commented Nov 26, 2013 at 18:28
Could casing be an issue? The query itself uses CustNum, but the parameter is named custNum. — Stefan Hanke
– Stefan Hanke, Commented Nov 26, 2013 at 18:43
Never used the biginteger types, but I'd try new SqlParameter("@PrimaryDisc", new BigInteger(0)). — Joachim Isaksson
– Joachim Isaksson, Commented Nov 26, 2013 at 18:45

James123 · Accepted Answer · 2013-11-26 18:52:41Z

1

It works for me from this article.

http://blogs.msdn.com/b/diego/archive/2012/01/10/how-to-execute-stored-procedures-sqlquery-in-the-dbcontext-api.aspx

var custNum = new SqlParameter {ParameterName = "CustNum", Value = CustomerNum};
var primaryDisc = new SqlParameter { ParameterName = "PrimaryDisc", Value = 0 };
var secondaryDisc = new SqlParameter { ParameterName = "SecondaryDisc", Value = 0 };

var results = _MiscContext.Database.SqlQuery<TempTechDisciplines>(
             "exec sp_getTechnicalDiscipline @CustNum, @PrimaryDisc,
              @SecondaryDisc",
              custNum,primaryDisc,secondaryDisc).ToList<TempTechDisciplines>();

answered Nov 26, 2013 at 18:52

James123

11.7k70 gold badges199 silver badges356 bronze badges

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

1 Comment

Joachim Isaksson Over a year ago

Yes, setting the actual value should fix it.

d.popov · Accepted Answer · 2015-07-15 13:17:01Z

0

If a parameter value (CustomerNum) is null, the parameter will not be serialized, and this error will occur.

Check and add default values for each parameter you add ('0' for CustomerNum), and check if CustomerNum <> 0 instead IS NULL if needed.

answered Jul 15, 2015 at 13:17

d.popov

4,2951 gold badge40 silver badges48 bronze badges

Collectives™ on Stack Overflow

The parameterized query is not recognizing parameter in EF5?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related