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

You use Microsoft Visual Studio 2010 to create a Microsoft .NET Framework 4.0 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.0 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>



Leave a Reply 3

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


E

E

Whats wrong with B?

Mike

Mike

I can only think it’s because no default value is required in the question.

John Galt

John Galt

Another retarded answer courtesy of Microsoft.