ssdl view and TPT
I want to do the same than my last post with TPT.
I add this in ssdl:
<EntitySet Name="Managers" EntityType="TestModel1.Store.Managers">
<DefiningQuery>
SELECT DISTINCT EmployeeManager
FROM EmployeesWithManager
</DefiningQuery>
</EntitySet>
<EntityType Name="Managers">
<Key>
<PropertyRef Name="EmployeeManager" />
</Key>
<Property Name="EmployeeManager" Type="int" Nullable="false" />
</EntityType>
Then, I just need to create Manager entity type, add inheritance between it and Employee entity type, map EmployeeManager ssdl view with EmployeeId property and it's all.
It's too easy to use Entity Framework, isn't it? 