nerdexam
Microsoft

70-516 · Question #84

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…

The correct answer is A. Delete the EmployeeAccess entity. <Association Name="FK_OrderDetails_Orders1"> <End Role="Orders" Type="StoreDB.Store.Orders" Multiplicity="1"> <OnDelete Action="Cascade" /> <End Role="OrderDetails" Type="StoreDB.Store.OrderDetails" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="Orders">…

Implementing Data Access

Question

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?

Options

  • ADelete the EmployeeAccess entity,
  • BCreate an inheritance relationship between the Employee and EmployeeAccess entities,
  • CModify the .edmx file to include the following line of code.
  • DCreate a one-to-one association named CanAccessBuildingsAssociation between the

How the community answered

(35 responses)
  • A
    86% (30)
  • B
    6% (2)
  • C
    3% (1)
  • D
    6% (2)

Explanation

<Association Name="FK_OrderDetails_Orders1"> <End Role="Orders" Type="StoreDB.Store.Orders" Multiplicity="1"> <OnDelete Action="Cascade" /> <End Role="OrderDetails" Type="StoreDB.Store.OrderDetails" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="Orders"> <PropertyRef Name="ID" /> <Dependent Role="OrderDetails"> <PropertyRef Name="OrderId" /> </ReferentialConstraint>

Topics

#Entity Data Model#table splitting#entity merging#EDM wizard

Community Discussion

No community discussion yet for this question.

Full 70-516 Practice