Create Procedure spABC
as
begin
select
ID,Groups,NoOfChild from table1select 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...