You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You
use Microsoft ADO.NET Entity Data Model (EDM) to mode entities. You create an entity named
Person with a schema defined by the following XML fragment
<EnlityType l1ame’CPerson”
<Key>
<PropertyRef Name=”Personld” I>
</Key>
<Property Name=”Personid” Typel=”int32” Nullable=”false” />
<Property Name=”CompaiyName” Type=”String”/>
<Property Name=”ContactName” Type”Strng”/>
<Property Name=”ContactTitle” Type=’String”/>
<Proper1y Name=”Address” Type=”String”/>
</Entitytype>
You need to ensure that entities within the application are able to add properties related to the city,
region, and country of Person’s address. What should you do?
A.
“Create a new complex type named CAddress that contains the properties for city, region, and
country
“Change the type ot the Address property in CPerson to “Self.CAddress”.
B.
“Create a SubEntity named Address.
“Map the SubEntity to a stored procedure that retrieves city, region, and country
C.
“Create a new entity named Address.
“Add a person ID property to filter the results to display only the City, Region, and Country
properties for a specific Person entity.
D.
“Create a view named Name that returns city, region, and country along with person IDs. “Add a
WHERE clause to filter the results to display only the City, Region and Country properties for a
specific Person entity
Explanation: