You must Sign In to post a response.
  • Category: ASP.Net MVC

    Calling Stored Procedure with Parameter and Multiple Result Set Entity Framework

    Hi,
    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
    https://msdn.microsoft.com/en-us/data/jj691402.aspx

    Thanks,
    Krishna.K
  • #766995
    Hi

    refer this url



    "codeproject.com/Articles/675933/Returning-Multiple-Result-Sets-from-an-Entity-Fram"
    "entityframeworktutorial.net/stored-procedure-in-entity-framework.aspx"

    Name : Dotnet Developer-2015
    Email Id :kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #766996
    [Response removed by Admin. Read forum policies.]
    Name : Dotnet Developer-2015
    Email Id :kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.


Sign In to post your comments