AndreyR wrote:It is possible in EF.
You should have an entity corresponding to the result set of stored procedure in your model.
It should contain the same set of columns with the same names and types.
If you don't have such table, create a view.
I used the simple example just to paint a clear picture. However, what I doing is more complex. I'm trying to use existing sp's with business logic and map them to entities that I created in the conceptual model. I'll then expose the data using ADO.NET Data Service as AtomPub feeds. There are no physical tables to map the entites to and creating views is not an option. Calls must be dynamic based on input paramters.
So getting back to my simple example from above:
I created a entity called Customer in my model with the same columns and types that the ref cursor returns. Now, lets say the sp takes an input parameter of p_name (where p_name is 'Smith' and it can return multilpe customers) and returns the p_cursor as the output parameter.
When I expand the sp under the Function Imports I only see my output p_cursor and my input p_name parameters.
So how do I map the columns from the p_cursor to the columns in my entity? Is this possible w/o having the entity mapped to a physical table or view?
I'm currently evaluating your product for my company so any advice would be great since I have the trial version.