Hemant Mehra

Hemant Mehra

  • NA
  • 347
  • 0

how to return multiple table of sql in Entity Framework?

Sep 30 2014 7:36 AM
Create Procedure spAbc
as
begin
select a,b,c from table1
select x,y,z from table2 
end 
 
how to to get all table record of spAbc procedure...entity framework return only zero index table. 
 
	using (HeplConnection objHeplConnection = new HeplConnection()) 
         { 
         var obj = objHeplConnection.StaffRegistration_DDL();
         foreach (var item in obj.table1) 
         {
            table1 objtable1  = new table1 (); 					 
         }
     foreach (var item in obj.table2) 
         {
            table2 objtable2  = new table2 (); 					 
         }

      }
 

Answers (1)