PrepAway - Latest Free Exam Questions & Answers

Which storage Model section of the .edmx file should you include?

You use Microsoft Visual Studio 2010 to create a Microsoft .NET Framework 4 application. You
create an Entity Data Model for the database tables shown in the following diagram.

You need to modify the .edmx file so that a many-to-many association can exist between the
Address and Customer entities. Which storage Model section of the .edmx file should you include?

PrepAway - Latest Free Exam Questions & Answers

A.
<EntityType Name=”CustomerAddress”>
<Key>
<PropertyRef Naroe=”CustomerID” />
<PropertyRef Naroe=”AddcessID” />
</Key>

<Property Name-“CustomerID” Type-“int” Nulloble-“false”/>
<Pcopercy Naroe-“AddcessID” Type-“int” Nullable-“false”/>
<Pcopercy Name=”AddcessType” Type=”nvacchar” Nullable=”false” MaxLength=”50″ />
</EntityType>

B.
<EntityType Naitie=”CustoitierAddress”>
<Key>
<PropertyRef Nartie=”CustomerID” />
<PropertyRef Name=”AddressID” />
</Key>
<Property Name=”CustomerID” Type=”int” Nullable=”false”/>
<Property Name=”AddressID” Type=”int” Nullable=”false”/>
<Property Name=”AddressType” Type=”nvarchar”
Nullable=”false” MaxLength=”50″ DefaultValue=”Home” />
</EntityType>

C.
<EntityType Name=”CustomerAddress”>
<Key>
<PropertyRef Name=”CustomerAddressID” />
</Key> <Property Name=”CustomerAddressID” Type=”int”
Nullable=”false” StoreGeneratedPattern=”Identity” />
<Property Name=”CustomerID” Type=”int” Nullatile=”false”/>
<Property Name=”AddressID” Type=”int” Nullable-“falsew”/>
<Property Name=”AddressType” Type=”nvarchar”
Nullable=”false” MaxLength«”50″/>
</EntityType>

D.
<EntityType Name=”CustomerAddress”>
<Key>
<PropertyRef Name=”CustomerAddressID” />
<PropertyRef Name=”CustomerID” />
<PropertyRef Name=”AddressID” />
</Key>
<Property Name=”CustomerAddressID” Type=”int”
Nullafole=”false” StoreGeneratedPattern=”Identity” />
<Property Name=”CustomerID” Type=”int” Nullable=”false”/>
<Property Name=”AddressID” Type=”int” Nullable=”false”/>
<Property Name=”AddressType” Type=”nvarchar”
Nullable=”false” MaxLength=”50’7>
</EntityType>


Leave a Reply