Get output parameter value
entity-framework
Question
I'm using EF in my MVC project. In my project I need to use stored procedures. My problem is to use output parameter with stored procedures. I have no idea how to do that
Accepted Answer
When you create your entity model, you should make sure that you include stored procedures. Then, create Function Imports for them:
- Open your Entity Model in Visual Studio
- The Model Browser should open on the right side of the screen
- In the Model Browser, you need to select the stored procedure and click Add Function Import to create the function for the stored procedure.
- A dialog box will open to select the stored procedure and return type
That's it. Now you can use that in code.
using (MyEntities myContext = new MyEntities ())
{
System.Data.Objects.ObjectParameter output = new System.Data.Objects.ObjectParameter("OutputParameterName", typeof(int));
myContext.GetCustomerCount(output);
Console.WriteLine(output.Value);
}
Popular Answer
Modified Answer for Entity Framework 6.x / VS 2015 - notice the namespace change:
using (MyEntities myContext = new MyEntities ())
{
System.Data.Entity.Core.Objects.ObjectParameter output = new System.Data.Entity.Core.Objects.ObjectParameter("OutputParameterName", typeof(int));
myContext.GetCustomerCount(output);
Console.WriteLine(output.Value);
}
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
