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?

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?

A.
<EntityType Name=”CustomerAddress”>
<Key>
<PropertyRef Name=”CustomerAddressID” />
<PropertyRef Name=”CustomerID” />
<PropertyRef Name=”AddressID” />
</Key>
<Property Name=”CustomerAddressID” Type=”int” Nullable=”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″/>
</EntityType>

B.
<EntityType Name=”CustomerAddress”>
<Key>
<PropertyRef Name=”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” Nullable=”false”/>
<Property Name=”AddressID” Type=”int” Nullable=”false” />
<Property Name=”AddressType” Type=”nvarchar” Nullable=”false” MaxLength=”50″/>
</EntityType>

D.
<EntityType Name=”CustomerAddress”>
<Key>
<PropertyRef Name=”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” />
</EntityType>

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *