Calling Stored Procedure with Parameter and Multiple Result Set Entity FrameworkHi,
I have a stored procedure uspGetProductAndCategory which is accepting a parameter @SupplierID and returns the products, categories and suppliers [these tables from the Database.
My problem is when I am integrating this stored procedure with an .edmx it's generating one method in my ContextEntityClass as uspGetProductAndCategory with a return type of ObjectResult<uspGetProductAndCategory_Result>. But this complex type is about only 1st result set.
I have read many topics on "How to Call Multiple Result Set SP in EF 6" but didn't get any solution yet. After changing the function import and other elements through XML editor as describe., how I will call the function uspGetProductAndCategory_Result which is already returning ObjectResult<uspGetProductAndCategory_Result>.Refered http://www.codeproject.com/Articles/675933/Returning-Multiple-Result-Sets-from-an-Entity-Fram