Which two actions should you perform?

You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The application uses ADO.NET Entity Framework for persistence.

The following storage schema definition is generated for an entity named Supplier.

<EntityType Name="Supplier">
<Key>
<PropertyRef Name="ID" />
</Key>
<Property Name="ID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="Country" Type="char" MaxLength="3" />
<Property Name="City" Type="nvarchar" MaxLength="20" />
</EntityType>

You need to map the City column and the Country column as a separate type named Address in the conceptual schema.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The application uses ADO.NET Entity Framework for persistence.

The following storage schema definition is generated for an entity named Supplier.

<EntityType Name="Supplier">
<Key>
<PropertyRef Name="ID" />
</Key>
<Property Name="ID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="Country" Type="char" MaxLength="3" />
<Property Name="City" Type="nvarchar" MaxLength="20" />
</EntityType>

You need to map the City column and the Country column as a separate type named Address in the conceptual schema.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A.
Create the following mapping schema definition.
<EntityTypeMapping TypeName="IsTypeOf(ContosoModel.Supplier)">
<MappingFragment StoreEntitySet="Supplier">
<ScalarProperty Name="ID" ColumnName="ID" />
<ScalarProperty Name="Address.Country" ColumnName="Country" />
<ScalarProperty Name="Address.City" ColumnName="City" />
</MappingFragment>
</EntityTypeMapping>

B.
Create the following mapping schema definition.
<EntityTypeMapping TypeName="IsTypeOf(ContosoModel.Supplier)">
<MappingFragment StoreEntitySet="Supplier">
<ScalarProperty Name="ID" ColumnName="ID" />
<ComplexProperty Name="Address" TypeName="ContosoModel.Address">
<ScalarProperty Name="Country" ColumnName="Country" />
<ScalarProperty Name="City" ColumnName="City" />
</ComplexProperty>
</MappingFragment>
</EntityTypeMapping>

C.
Create the following mapping schema definition.
<EntitySetMapping Name="Supplier">
<EntityTypeMapping TypeName="IsTypeOf(ContosoModel.Supplier)">
<MappingFragment StoreEntitySet="Supplier">
<ScalarProperty Name="ID" ColumnName="ID" />
</MappingFragment>
<MappingFragment StoreEntitySet="Address">
<ScalarProperty Name="Country" ColumnName="Country" />
<ScalarProperty Name="City" ColumnName="City" />
</MappingFragment>
</EntityTypeMapping>

D.
Create the following conceptual schema definition.
<ComplexType Name="Address">
<Property Name="Country" Type="String" MaxLength="3" />
<Property Name="City" Type="String" MaxLength="20" />
</ComplexType>
<EntityType Name="Supplier">
<Key>
<PropertyRef Name="ID" />
</Key>
<Property Name="ID" Type="Int32" Nullable="false" />
<Property Name="Address" Type="ContosoModel.Address" Nullable="false" />
</EntityType>

E.
Create the following conceptual schema definition.
<EntityType Name="Address">
<Key>
<PropertyRef Name="ID"/>
</Key>
<Property Name="ID" Type="Int32" Nullable="false" />
<Property Name="Country" Type="String" MaxLength="3" />
<Property Name="City" Type="String" MaxLength="20" />
</EntityType>
<EntityType Name="Supplier">
<Key>
<PropertyRef Name="ID" />
</Key>
<Property Name="ID" Type="Int32" Nullable="false" />
<Property Name="Address" Type="ContosoModel.Address" Nullable="false" />
</EntityType>



Leave a Reply 0

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