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.