private void CreateFunctionMappingComplexTypeMapping(CommandEntity entity, FunctionImportMapping importMapping)
{
//<ResultMapping>
// <ComplexTypeMapping TypeName="PetShopModel.GetCategoryById_Result">
string entityName = String.Concat(entity.Name, "Result");
var mapping = importMapping.ResultMapping != null && importMapping.ResultMapping.ComplexTypeMappings != null
? importMapping.ResultMapping.ComplexTypeMappings.FirstOrDefault()
: null;
if (mapping == null)
{
importMapping.ResultMapping = new FunctionImportMappingResultMapping()
{
ComplexTypeMappings = new List<FunctionImportComplexTypeMapping>()
};
mapping = new FunctionImportComplexTypeMapping() { TypeName = String.Concat(ConceptualSchema.Namespace, ".", entityName) };
importMapping.ResultMapping.ComplexTypeMappings.Add(mapping);
}
else if (!String.IsNullOrEmpty(mapping.TypeName))
{
entityName = mapping.TypeName.Replace("IsTypeOf(", "").Replace(String.Format("{0}.", ConceptualSchema.Namespace), "").Replace(")", "");
entityName = entityName.Equals(entity.Name, StringComparison.OrdinalIgnoreCase) ? entity.Name : entityName;
}
if(ConceptualSchema.ComplexTypes.Count(c => c.Name.Equals(entityName, StringComparison.OrdinalIgnoreCase)) == 0)
entityName = String.Concat(entity.Name, "Result");
// Check for inheritance.
mapping.TypeName = String.Format("{0}.{1}", ConceptualSchema.Namespace, entityName);
_mappingEntityNames.Add(entity.EntityKey(), importMapping.FunctionImportName);
_mappingEntityNames.Add(entity.EntityKey() + "complex", entityName);
//<ComplexTypeMapping TypeName="PetShopModel.GetCategoryById_Result">
// <ScalarProperty Name="CategoryId" ColumnName="CategoryId" />
// <ScalarProperty Name="Name" ColumnName="Name" />
// <ScalarProperty Name="Description" ColumnName="Descn" />
//</ComplexTypeMapping>
MergeScalarProperties(mapping, entity);
}
private void MergeScalarProperties(FunctionImportComplexTypeMapping mappingFragment, CommandEntity entity)
{
foreach (var property in mappingFragment.ScalarProperties.Where(p => entity.Properties.Count(prop => prop.KeyName.Equals(p.ColumnName, StringComparison.OrdinalIgnoreCase)) == 0))
_mappingDroppedEntityPropertyNames[String.Format(PROPERTY_KEY, entity.EntityKeyName, property.ColumnName)] = property.Name;
var properties = new List<ScalarProperty>();
foreach (var property in entity.Properties)
{
var prop = mappingFragment.ScalarProperties.Where(p => p.ColumnName.Equals(property.KeyName, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (prop == null)
{
// The property doesn't exist so lets create it.
prop = new ScalarProperty() { Name = property.Name };
}
else if (!property.Name.Equals(prop.Name, StringComparison.OrdinalIgnoreCase)) // Column matches that in the database.. If the names are different, it wins.
{
// The propertyName has been updated.
// TODO: Is there a better way to find out if they renamed the Property?
//prop.Name = prop.Name;
}
else
{
// Update the propertyName so it is always current with SchemaHelper.
prop.Name = property.Name;
}
prop.ColumnName = property.KeyName;
if (!ExcludeProperty(property as ISchemaProperty) && properties.Count(p => p.Name.Equals(prop.Name, StringComparison.OrdinalIgnoreCase)) == 0)
{
properties.Add(prop);
_mappingEntityPropertyNames[String.Format("{0}-{1}", entity.Name, property.KeyName)] = prop.Name;
}
}
mappingFragment.ScalarProperties = properties.Distinct().ToList();
}