as
begin
select ID,Groups,NoOfChild from table1
select ID,Name,Address from table2
select ID,UserType from table3
end
In entity.edmx of spABC only table1 entities are showing...
<ComplexType Name="StaffRegistration_DDL_Result"> <Property Type="Int64" Name="ID" Nullable="false" /> <Property Type="String" Name="Groups" Nullable="true" MaxLength="100" /> <Property Type="String" Name="NoOfChild" Nullable="false" MaxLength="1" /> ComplexType>
how can i achieve all the entites...
Ramesh MaruthiPosted Oct 1, 2014, 12:27 PM
http://www.codeproject.com/Articles/675933/Returning-Multiple-Result-Sets-from-an-Entity-Fram
http://msdn.microsoft.com/en-us/data/jj691402.aspx