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 model entities. You create an entity named Person with a schema defined by the following XML fragment.
<EntityType Name=”CPerson”>
<Key>
<PropertyRef Name=”PersonId” />
</Key>
<Property Name=”PersonId” Type=”Int32″ Nullable=”false” />
<Property Name=”CompanyName” Type=”String” />
<Property Name=”ContactName” Type=”String” />
<Property Name=”ContactTitle” Type=”String” />
<Property 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 of 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.