/// <summary>
/// This API supports the Entity Framework Core infrastructure and is not intended to be used
/// directly from your code. This API may change or be removed in future releases.
/// </summary>
protected virtual void EnsureSharedColumnsCompatibility([NotNull] IModel model)
{
foreach (var rootEntityType in model.GetRootEntityTypes())
{
var annotations = RelationalExtensions.For(rootEntityType);
var table = Format(annotations.Schema, annotations.TableName);
var properties = rootEntityType.GetDerivedTypesInclusive().SelectMany(et => et.GetDeclaredProperties());
var propertyTypeMappings = new Dictionary <string, IProperty>(StringComparer.OrdinalIgnoreCase);
foreach (var property in properties)
{
var propertyAnnotations = RelationalExtensions.For(property);
var columnName = propertyAnnotations.ColumnName;
IProperty duplicateProperty;
if (propertyTypeMappings.TryGetValue(columnName, out duplicateProperty))
{
var previousAnnotations = RelationalExtensions.For(duplicateProperty);
var currentTypeString = propertyAnnotations.ColumnType
?? TypeMapper.GetMapping(property).StoreType;
var previousTypeString = previousAnnotations.ColumnType
?? TypeMapper.GetMapping(duplicateProperty).StoreType;
if (!currentTypeString.Equals(previousTypeString, StringComparison.OrdinalIgnoreCase))
{
ShowError(RelationalStrings.DuplicateColumnNameDataTypeMismatch(
duplicateProperty.DeclaringEntityType.DisplayName(),
duplicateProperty.Name,
property.DeclaringEntityType.DisplayName(),
property.Name,
columnName,
table,
previousTypeString,
currentTypeString));
}
if (property.IsColumnNullable() != duplicateProperty.IsColumnNullable())
{
ShowError(RelationalStrings.DuplicateColumnNameNullabilityMismatch(
duplicateProperty.DeclaringEntityType.DisplayName(),
duplicateProperty.Name,
property.DeclaringEntityType.DisplayName(),
property.Name,
columnName,
table));
}
var currentComputedColumnSql = propertyAnnotations.ComputedColumnSql ?? "";
var previousComputedColumnSql = previousAnnotations.ComputedColumnSql ?? "";
if (!currentComputedColumnSql.Equals(previousComputedColumnSql, StringComparison.OrdinalIgnoreCase))
{
ShowError(RelationalStrings.DuplicateColumnNameComputedSqlMismatch(
duplicateProperty.DeclaringEntityType.DisplayName(),
duplicateProperty.Name,
property.DeclaringEntityType.DisplayName(),
property.Name,
columnName,
table,
previousComputedColumnSql,
currentComputedColumnSql));
}
var currentDefaultValue = propertyAnnotations.DefaultValue;
var previousDefaultValue = previousAnnotations.DefaultValue;
if (!Equals(currentDefaultValue, previousDefaultValue))
{
ShowError(RelationalStrings.DuplicateColumnNameDefaultSqlMismatch(
duplicateProperty.DeclaringEntityType.DisplayName(),
duplicateProperty.Name,
property.DeclaringEntityType.DisplayName(),
property.Name,
columnName,
table,
previousDefaultValue ?? "NULL",
currentDefaultValue ?? "NULL"));
}
var currentDefaultValueSql = propertyAnnotations.DefaultValueSql ?? "";
var previousDefaultValueSql = previousAnnotations.DefaultValueSql ?? "";
if (!currentDefaultValueSql.Equals(previousDefaultValueSql, StringComparison.OrdinalIgnoreCase))
{
ShowError(RelationalStrings.DuplicateColumnNameDefaultSqlMismatch(
duplicateProperty.DeclaringEntityType.DisplayName(),
duplicateProperty.Name,
property.DeclaringEntityType.DisplayName(),
property.Name,
columnName,
table,
previousDefaultValueSql,
currentDefaultValueSql));
}
}
else
{
propertyTypeMappings[columnName] = property;
}
}
}
}
/// <summary>
/// This API supports the Entity Framework Core infrastructure and is not intended to be used
/// directly from your code. This API may change or be removed in future releases.
/// </summary>
protected virtual void EnsureSharedForeignKeysCompatibility([NotNull] IModel model)
{
foreach (var rootEntityType in model.GetRootEntityTypes())
{
var annotations = RelationalExtensions.For(rootEntityType);
var tableName = Format(annotations.Schema, annotations.TableName);
var foreignKeys = rootEntityType.GetDerivedTypesInclusive().SelectMany(et => et.GetDeclaredForeignKeys());
var foreignKeyMappings = new Dictionary <string, IForeignKey>(StringComparer.OrdinalIgnoreCase);
foreach (var foreignKey in foreignKeys)
{
var foreignKeyAnnotations = RelationalExtensions.For(foreignKey);
var foreignKeyName = foreignKeyAnnotations.Name;
IForeignKey duplicateForeignKey;
if (!foreignKeyMappings.TryGetValue(foreignKeyName, out duplicateForeignKey))
{
foreignKeyMappings[foreignKeyName] = foreignKey;
continue;
}
var principalAnnotations = RelationalExtensions.For(foreignKey.PrincipalEntityType);
var principalTable = Format(principalAnnotations.Schema, principalAnnotations.TableName);
var duplicateAnnotations = RelationalExtensions.For(duplicateForeignKey.PrincipalEntityType);
var duplicatePrincipalTable = Format(duplicateAnnotations.Schema, duplicateAnnotations.TableName);
if (!string.Equals(principalTable, duplicatePrincipalTable, StringComparison.OrdinalIgnoreCase))
{
ShowError(RelationalStrings.DuplicateForeignKeyPrincipalTableMismatch(
Property.Format(foreignKey.Properties),
foreignKey.DeclaringEntityType.DisplayName(),
Property.Format(duplicateForeignKey.Properties),
duplicateForeignKey.DeclaringEntityType.DisplayName(),
tableName,
foreignKeyName,
principalTable,
duplicatePrincipalTable));
}
var foreignKeyColumns = foreignKey.Properties.Select(p => RelationalExtensions.For(p).ColumnName).ToList();
var duplicateForeignKeyColumns = duplicateForeignKey.Properties.Select(p => RelationalExtensions.For(p).ColumnName).ToList();
if (!foreignKeyColumns.SequenceEqual(duplicateForeignKeyColumns, StringComparer.OrdinalIgnoreCase))
{
ShowError(RelationalStrings.DuplicateForeignKeyColumnMismatch(
Property.Format(foreignKey.Properties),
foreignKey.DeclaringEntityType.DisplayName(),
Property.Format(duplicateForeignKey.Properties),
duplicateForeignKey.DeclaringEntityType.DisplayName(),
tableName,
foreignKeyName,
Format(foreignKeyColumns),
Format(duplicateForeignKeyColumns)));
}
var foreignKeyPrincipalColumns = foreignKey.PrincipalKey.Properties.Select(
p => RelationalExtensions.For(p).ColumnName).ToList();
var duplicateForeignKeyPrincipalColumns = duplicateForeignKey.PrincipalKey.Properties.Select(
p => RelationalExtensions.For(p).ColumnName).ToList();
if (!foreignKeyPrincipalColumns.SequenceEqual(duplicateForeignKeyPrincipalColumns, StringComparer.OrdinalIgnoreCase))
{
ShowError(RelationalStrings.DuplicateForeignKeyPrincipalColumnMismatch(
Property.Format(foreignKey.Properties),
foreignKey.DeclaringEntityType.DisplayName(),
Property.Format(duplicateForeignKey.Properties),
duplicateForeignKey.DeclaringEntityType.DisplayName(),
tableName,
foreignKeyName,
Format(foreignKeyPrincipalColumns),
Format(duplicateForeignKeyPrincipalColumns)));
}
if (foreignKey.IsUnique != duplicateForeignKey.IsUnique)
{
ShowError(RelationalStrings.DuplicateForeignKeyUniquenessMismatch(
Property.Format(foreignKey.Properties),
foreignKey.DeclaringEntityType.DisplayName(),
Property.Format(duplicateForeignKey.Properties),
duplicateForeignKey.DeclaringEntityType.DisplayName(),
tableName,
foreignKeyName));
}
if (foreignKey.IsRequired != duplicateForeignKey.IsRequired)
{
ShowError(RelationalStrings.DuplicateForeignKeyUniquenessMismatch(
Property.Format(foreignKey.Properties),
foreignKey.DeclaringEntityType.DisplayName(),
Property.Format(duplicateForeignKey.Properties),
duplicateForeignKey.DeclaringEntityType.DisplayName(),
tableName,
foreignKeyName));
}
if (foreignKey.DeleteBehavior != duplicateForeignKey.DeleteBehavior)
{
ShowError(RelationalStrings.DuplicateForeignKeyDeleteBehaviorMismatch(
Property.Format(foreignKey.Properties),
foreignKey.DeclaringEntityType.DisplayName(),
Property.Format(duplicateForeignKey.Properties),
duplicateForeignKey.DeclaringEntityType.DisplayName(),
tableName,
foreignKeyName,
foreignKey.DeleteBehavior,
duplicateForeignKey.DeleteBehavior));
}
}
}
}
/// <summary>
/// This API supports the Entity Framework Core infrastructure and is not intended to be used
/// directly from your code. This API may change or be removed in future releases.
/// </summary>
protected virtual void EnsureSharedColumnsCompatibility([NotNull] IModel model)
{
var groupedEntityTypes = new Dictionary <string, List <IEntityType> >();
foreach (var entityType in model.GetEntityTypes())
{
var annotations = RelationalExtensions.For(entityType);
var tableName = annotations.Schema + "." + annotations.TableName;
if (!groupedEntityTypes.ContainsKey(tableName))
{
groupedEntityTypes[tableName] = new List <IEntityType>();
}
groupedEntityTypes[tableName].Add(entityType);
}
foreach (var table in groupedEntityTypes.Keys)
{
var properties = groupedEntityTypes[table].SelectMany(et => et.GetDeclaredProperties());
var propertyTypeMappings = new Dictionary <string, IProperty>();
foreach (var property in properties)
{
var propertyAnnotations = RelationalExtensions.For(property);
var columnName = propertyAnnotations.ColumnName;
IProperty duplicateProperty;
if (propertyTypeMappings.TryGetValue(columnName, out duplicateProperty))
{
var previousAnnotations = RelationalExtensions.For(duplicateProperty);
var currentTypeString = propertyAnnotations.ColumnType
?? TypeMapper.GetMapping(property).StoreType;
var previousTypeString = previousAnnotations.ColumnType
?? TypeMapper.GetMapping(duplicateProperty).StoreType;
if (!currentTypeString.Equals(previousTypeString, StringComparison.OrdinalIgnoreCase))
{
ShowError(RelationalStrings.DuplicateColumnName(
duplicateProperty.DeclaringEntityType.DisplayName(),
duplicateProperty.Name,
property.DeclaringEntityType.DisplayName(),
property.Name,
columnName,
table,
previousTypeString,
currentTypeString));
}
if (property.IsColumnNullable() != duplicateProperty.IsColumnNullable())
{
ShowError(RelationalStrings.DuplicateColumnNameNullabilityMismatch(
duplicateProperty.DeclaringEntityType.DisplayName(),
duplicateProperty.Name,
property.DeclaringEntityType.DisplayName(),
property.Name,
columnName,
table));
}
var currentComputedColumnSql = propertyAnnotations.ComputedColumnSql ?? "";
var previousComputedColumnSql = previousAnnotations.ComputedColumnSql ?? "";
if (!currentComputedColumnSql.Equals(previousComputedColumnSql, StringComparison.OrdinalIgnoreCase))
{
ShowError(RelationalStrings.DuplicateColumnNameComputedSqlMismatch(
duplicateProperty.DeclaringEntityType.DisplayName(),
duplicateProperty.Name,
property.DeclaringEntityType.DisplayName(),
property.Name,
columnName,
table,
previousComputedColumnSql,
currentComputedColumnSql));
}
var currentDefaultValue = propertyAnnotations.DefaultValue;
var previousDefaultValue = previousAnnotations.DefaultValue;
if (currentDefaultValue != previousDefaultValue)
{
ShowError(RelationalStrings.DuplicateColumnNameDefaultSqlMismatch(
duplicateProperty.DeclaringEntityType.DisplayName(),
duplicateProperty.Name,
property.DeclaringEntityType.DisplayName(),
property.Name,
columnName,
table,
previousDefaultValue ?? "NULL",
currentDefaultValue ?? "NULL"));
}
var currentDefaultValueSql = propertyAnnotations.DefaultValueSql ?? "";
var previousDefaultValueSql = previousAnnotations.DefaultValueSql ?? "";
if (!currentDefaultValueSql.Equals(previousDefaultValueSql, StringComparison.OrdinalIgnoreCase))
{
ShowError(RelationalStrings.DuplicateColumnNameDefaultSqlMismatch(
duplicateProperty.DeclaringEntityType.DisplayName(),
duplicateProperty.Name,
property.DeclaringEntityType.DisplayName(),
property.Name,
columnName,
table,
previousDefaultValueSql,
currentDefaultValueSql));
}
}
else
{
propertyTypeMappings[columnName] = property;
}
}
}
}
