Mutliple ResultSet from Stored Procedure using EF 5.0
-
I have a stored procedure that returns two resultset. I am calling this stored procedure in C# using EF 5.0. I have gone through the examples on this site as well as on thissite. I can understand that it is comparatively easy to call multiple result set with EF 5.0. But I am confused on adding ReturnType on FunctionImport tag which is as below:
In the above example, Blog and Post are two different entities so can easily be referred. However, in my case, the two resultset is the result of joining of multiple tables. SO how will I specify a specific table name here? (On EntitySet as well as Type). I am not able to understand clearly what value should go into these tags? Please provide any help.
-
I have a stored procedure that returns two resultset. I am calling this stored procedure in C# using EF 5.0. I have gone through the examples on this site as well as on thissite. I can understand that it is comparatively easy to call multiple result set with EF 5.0. But I am confused on adding ReturnType on FunctionImport tag which is as below:
In the above example, Blog and Post are two different entities so can easily be referred. However, in my case, the two resultset is the result of joining of multiple tables. SO how will I specify a specific table name here? (On EntitySet as well as Type). I am not able to understand clearly what value should go into these tags? Please provide any help.
Wow. This[^] took me 5 seconds to find with a simple Google search for "entity framework map to stored procedure returning multiple result sets[^]".
A guide to posting questions on CodeProject
Click this: Asking questions is a skill. Seriously, do it.
Dave Kreskowiak -
Wow. This[^] took me 5 seconds to find with a simple Google search for "entity framework map to stored procedure returning multiple result sets[^]".
A guide to posting questions on CodeProject
Click this: Asking questions is a skill. Seriously, do it.
Dave KreskowiakThank you. I have already referred this and I mentioned this in my question also. I asked the question because I am not able to understand how to refer multiple tables on FunctionImport and Return Types. Anyway, I found out already. Thanks for your help.