none
Can you return multiple resultsets in a stored procedure using Entity Framework RRS feed

  • Question

  • Hi,

    Is it possible to return multiple result set in a stored procedure using Entity Framework.

    Create Procedure P1()

    Begin

    select * from Employee;

    select * from Customers;

    End

    Can I execute this stored procedure in entity framework and return 2 lists (1 for emp and 1 for cust).

     

    Entities oDB = new Entities();

    var ResultSet = oDB.P1();

    return ResultSet.ToList();

    Many Thanks,

    Chocks

    Wednesday, July 27, 2011 6:58 PM

Answers

All replies