I have a stored process that was created a few years ago that returns a result set with output parameters. In EntityFramework, I'm attempting to use it. When I first imported it, the created code utilized
to carry out the process. By using this approach, the
The output parameter values were in objects. I then modified the model's specification of the imported procedure to produce a complex type I specified there that corresponds to the result set the stored function returns. To carry out the procedure, the resulting code was modified to use
the process returns the current result set in an
. But my
objects' default settings I did not set them to the procedure's output, but rather the time I created them.
In my model, I've made a second mapping of the function that isn't configured to return a complex type. I'm currently using these two routines to run the stored process twice. The complex type is not returned by the initial execution. It determines
values. I then go past these
I have the output of the stored procedure as well as the result data from these two executions of the second function.
Am I performing incorrectly? Or is this an Entity Framework 6 limitation?
It turns out that until all of the results are read, the output parameters aren't available. My issue was resolved by adding
towards the tend of the
call. I discovered it by looking through Visual Studio's information. The pertinent paperwork is available here:
I'm not sure why I can't find this mentioned in the official material on MSDN.