'System.Data.Entity.Database' does not contain a definition for 'ExecuteStoredProcedure'

Question

I am using Entity Framework extras EF6 in Visual Studio 2013 for calling a stored procedure that takes table valued parameter.

But on this line of code:

context.Database.ExecuteStoredProcedure(procedure);

I get this error:

'System.Data.Entity.Database' does not contain a definition for 'ExecuteStoredProcedure' and no extension method 'ExecuteStoredProcedure' accepting a first argument of type 'System.Data.Entity.Database' could be found (are you missing a using directive or an assembly reference?)

Emre Kabaoglu · Accepted Answer · 2018-01-19 08:01:16Z

0

The error is pretty clear that tells you, there is no method definition like ExecuteStoredProcedure. You could execute the stored procedure using SqlQuery;

context.Database.SqlQuery<YourEntityClass>("procedureName",params);

answered Jan 19, 2018 at 8:01

Emre Kabaoglu

13.2k4 gold badges27 silver badges48 bronze badges

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

2 Comments

Seema A Over a year ago

I want to pass table as parameter. And as i mentioned i am using entity framework extras EF 6. It is package available in nuget.

Emre Kabaoglu Over a year ago

What is that "entity framework extras" package. I couldn't see any mentioned package.

Collectives™ on Stack Overflow

'System.Data.Entity.Database' does not contain a definition for 'ExecuteStoredProcedure'

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