You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application that connects to a database by using the Entity Framework.
You create an Entity Data Model (EDM) by using the Generate from database wizard for the following tables.
You need to ensure that the EDM contains an entity type named Employee that contains all of the data from both tables.
What should you do?
A.
Delete the EmployeeAccess entity,
create a new property named CanAccessBuildings on the Employee entity,
and add a mapping for the new property.
B.
Create an inheritance relationship between the Employee and EmployeeAccess entities,
and use CanAccessBuildings as an inheritance condition.
C.
Modify the .edmx file to include the following line of code.
<NavigationProperty Name=”Type” FromRole=”EmployeeAccess” ToRole=”Employee” />
D.
Create a one-to-one association named CanAccessBuildingsAssociation between the EmployeeAccess entity and the Employee entity.
How do you “add a mapping for the new property”?
Answer: (A) SSDL: (1) add an EntitySet to the EntityContainer for the other table (2) add a corresponding new EntityType, including the key (B) MSL: (1) Add MappingFragment for new field