You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 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.