1) Question 1
Is it possible to use multiple output parameters in a stored procedure with Entity Framework? If so, is there an example somewhere I can review?
I have a stored procedure that has the following parameters:
user_id IN VARCHAR2
some_id OUT NUMBER
other_id OUT NUMBER
success OUT NUMBER
2) Question 2
I've also noticed that my entities class does not contain the method I've mapped via "Function Import" unless I declare a return type of entity. If I declare a void/bool, etc. return type there is no method on the entities class.
Please advise.
Thank you,
Taylor
Stored Procedure with multiple out parameters using EF?
1. There is no out parameters support in default Microsoft designer.
We recommend you to use Entity Developer (you can simply add Devart Entity Model to your project using "Add New Item..." menu, Entity Developer will be launched in VS integration mode). In Entity Developer procedures with out parameters are mapped correctly.
2. This is a designed behaviour of Microsoft designer in EF v1. Unlike it, Entity Developer supports scalar procedures.
We recommend you to use Entity Developer (you can simply add Devart Entity Model to your project using "Add New Item..." menu, Entity Developer will be launched in VS integration mode). In Entity Developer procedures with out parameters are mapped correctly.
2. This is a designed behaviour of Microsoft designer in EF v1. Unlike it, Entity Developer supports scalar procedures.