private PropertyBuilder VisitTypeMapping(PropertyBuilder propertyBuilder, ColumnModel column)
{
if (column.IsIdentity == true)
{
if (typeof(byte) == propertyBuilder.Metadata.ClrType)
{
Logger.LogWarning(
SqlServerDesignStrings.DataTypeDoesNotAllowSqlServerIdentityStrategy(
column.DisplayName, column.DataType));
}
else
{
propertyBuilder
.ValueGeneratedOnAdd()
.UseSqlServerIdentityColumn();
}
}
if (_dateTimePrecisionTypes.Contains(column.DataType) &&
column.Scale.HasValue &&
column.Scale != DefaultDateTimePrecision)
{
propertyBuilder.Metadata.SetMaxLength(null);
propertyBuilder.HasColumnType($"{column.DataType}({column.Scale})"); //not a typo: .Scale is the right property for datetime precision
}
// undo quirk in reverse type mapping to litters code with unnecessary nvarchar annotations
if (typeof(string) == propertyBuilder.Metadata.ClrType &&
propertyBuilder.Metadata.Relational().ColumnType == "nvarchar")
{
propertyBuilder.Metadata.Relational().ColumnType = null;
}
return(propertyBuilder);
}
public void E2ETest_UseAttributesInsteadOfFluentApi()
{
var configuration = new ReverseEngineeringConfiguration
{
ConnectionString = _connectionString,
ContextClassName = "AttributesContext",
ProjectPath = TestProjectDir + Path.DirectorySeparatorChar, // tests that ending DirectorySeparatorChar does not affect namespace
ProjectRootNamespace = TestNamespace,
OutputPath = TestSubDir,
TableSelectionSet = Filter
};
var filePaths = Generator.GenerateAsync(configuration).GetAwaiter().GetResult();
var actualFileSet = new FileSet(InMemoryFiles, Path.GetFullPath(Path.Combine(TestProjectDir, TestSubDir)))
{
Files = Enumerable.Repeat(filePaths.ContextFile, 1).Concat(filePaths.EntityTypeFiles).Select(Path.GetFileName).ToList()
};
var expectedFileSet = new FileSet(new FileSystemFileService(),
Path.Combine("ReverseEngineering", "ExpectedResults", "E2E_UseAttributesInsteadOfFluentApi"),
contents => contents.Replace("namespace " + TestNamespace, "namespace " + TestNamespace + "." + TestSubDir)
.Replace("{{connectionString}}", _connectionString))
{
Files = new List <string> {
"AttributesContext.expected"
}
.Concat(_expectedEntityTypeFiles).ToList()
};
AssertLog(new LoggerMessages
{
Warn =
{
RelationalDesignStrings.CannotFindTypeMappingForColumn("dbo.AllDataTypes.geographyColumn", "geography"),
RelationalDesignStrings.CannotFindTypeMappingForColumn("dbo.AllDataTypes.geometryColumn", "geometry"),
RelationalDesignStrings.CannotFindTypeMappingForColumn("dbo.AllDataTypes.hierarchyidColumn", "hierarchyid"),
RelationalDesignStrings.CannotFindTypeMappingForColumn("dbo.AllDataTypes.sql_variantColumn", "sql_variant"),
RelationalDesignStrings.CannotFindTypeMappingForColumn("dbo.AllDataTypes.xmlColumn", "xml"),
RelationalDesignStrings.UnableToScaffoldIndexMissingProperty("IX_UnscaffoldableIndex"),
SqlServerDesignStrings.DataTypeDoesNotAllowSqlServerIdentityStrategy("dbo.PropertyConfiguration.PropertyConfigurationID", "tinyint"),
RelationalDesignStrings.CannotFindTypeMappingForColumn("dbo.TableWithUnmappablePrimaryKeyColumn.TableWithUnmappablePrimaryKeyColumnID", "hierarchyid"),
RelationalDesignStrings.PrimaryKeyErrorPropertyNotFound("dbo.TableWithUnmappablePrimaryKeyColumn"),
RelationalDesignStrings.UnableToGenerateEntityType("dbo.TableWithUnmappablePrimaryKeyColumn")
}
});
AssertEqualFileContents(expectedFileSet, actualFileSet);
AssertCompile(actualFileSet);
}
public void E2ETest_AllFluentApi()
{
var configuration = new ReverseEngineeringConfiguration
{
ConnectionString = _connectionString,
ProjectPath = TestProjectDir,
ProjectRootNamespace = TestNamespace,
OutputPath = null, // not used for this test
UseFluentApiOnly = true,
TableSelectionSet = Filter,
};
var filePaths = Generator.GenerateAsync(configuration).GetAwaiter().GetResult();
var actualFileSet = new FileSet(InMemoryFiles, Path.GetFullPath(TestProjectDir))
{
Files = Enumerable.Repeat(filePaths.ContextFile, 1).Concat(filePaths.EntityTypeFiles).Select(Path.GetFileName).ToList()
};
var expectedFileSet = new FileSet(new FileSystemFileService(),
Path.Combine("ReverseEngineering", "ExpectedResults", "E2E_AllFluentApi"),
inputFile => inputFile.Replace("{{connectionString}}", _connectionString))
{
Files = (new List <string> {
"SqlServerReverseEngineerTestE2EContext.expected"
})
.Concat(_expectedEntityTypeFiles).ToList()
};
AssertLog(new LoggerMessages
{
Warn =
{
RelationalDesignStrings.CannotFindTypeMappingForColumn("dbo.AllDataTypes.geographyColumn", "geography"),
RelationalDesignStrings.CannotFindTypeMappingForColumn("dbo.AllDataTypes.geometryColumn", "geometry"),
RelationalDesignStrings.CannotFindTypeMappingForColumn("dbo.AllDataTypes.hierarchyidColumn", "hierarchyid"),
RelationalDesignStrings.CannotFindTypeMappingForColumn("dbo.AllDataTypes.sql_variantColumn", "sql_variant"),
RelationalDesignStrings.CannotFindTypeMappingForColumn("dbo.AllDataTypes.xmlColumn", "xml"),
RelationalDesignStrings.UnableToScaffoldIndexMissingProperty("IX_UnscaffoldableIndex"),
SqlServerDesignStrings.DataTypeDoesNotAllowSqlServerIdentityStrategy("dbo.PropertyConfiguration.PropertyConfigurationID", "tinyint"),
RelationalDesignStrings.CannotFindTypeMappingForColumn("dbo.TableWithUnmappablePrimaryKeyColumn.TableWithUnmappablePrimaryKeyColumnID", "hierarchyid"),
RelationalDesignStrings.PrimaryKeyErrorPropertyNotFound("dbo.TableWithUnmappablePrimaryKeyColumn"),
RelationalDesignStrings.UnableToGenerateEntityType("dbo.TableWithUnmappablePrimaryKeyColumn"),
}
});
AssertEqualFileContents(expectedFileSet, actualFileSet);
AssertCompile(actualFileSet);
}
private void VisitTypeMapping(PropertyBuilder propertyBuilder, ColumnModel column)
{
if (column.SqlServer().IsIdentity)
{
if (typeof(byte) == propertyBuilder.Metadata.ClrType)
{
Logger.LogWarning(
SqlServerDesignEventId.DataTypeDoesNotAllowSqlServerIdentityStrategyWarning,
() => SqlServerDesignStrings.DataTypeDoesNotAllowSqlServerIdentityStrategy(
column.DisplayName, column.DataType));
}
else
{
propertyBuilder
.ValueGeneratedOnAdd()
.UseSqlServerIdentityColumn();
}
}
var dateTimePrecision = column.SqlServer().DateTimePrecision;
if (dateTimePrecision.HasValue &&
dateTimePrecision.Value != DefaultTimeTimePrecision)
{
propertyBuilder.Metadata.SetMaxLength(null);
propertyBuilder.HasColumnType(
string.Format(CultureInfo.InvariantCulture, "{0}({1})", column.DataType, dateTimePrecision.Value));
}
else if (!HasTypeAlias(column))
{
var qualifiedColumnTypeAndMaxLength =
MaxLengthQualifiedDataType(column.DataType, column.MaxLength);
if (qualifiedColumnTypeAndMaxLength != null)
{
propertyBuilder.HasColumnType(qualifiedColumnTypeAndMaxLength.Item1);
propertyBuilder.Metadata.SetMaxLength(qualifiedColumnTypeAndMaxLength.Item2);
}
}
var columnType = propertyBuilder.Metadata.SqlServer().ColumnType;
if (columnType != null)
{
TypeMapper.ValidateTypeName(columnType);
}
}
public virtual void AddFacetsOnProperty(
[NotNull] Property property, [NotNull] TableColumn tableColumn)
{
Check.NotNull(property, nameof(property));
Check.NotNull(tableColumn, nameof(tableColumn));
property.IsNullable = tableColumn.IsNullable;
if (property.Name != tableColumn.ColumnName)
{
property.Relational().ColumnName = tableColumn.ColumnName;
}
string typeName = null;
if (DataTypesForNumericPrecisionAndScale.Contains(tableColumn.DataType))
{
if (tableColumn.NumericPrecision.HasValue)
{
if (tableColumn.Scale.HasValue)
{
typeName = tableColumn.DataType + "(" + tableColumn.NumericPrecision.Value + ", " + tableColumn.Scale.Value + ")";
}
else
{
typeName = tableColumn.DataType + "(" + tableColumn.NumericPrecision.Value + ")";
}
}
}
else if (DataTypesForDateTimePrecisionAndScale.Contains(tableColumn.DataType))
{
if (tableColumn.DateTimePrecision.HasValue)
{
if (tableColumn.Scale.HasValue)
{
typeName = tableColumn.DataType + "(" + tableColumn.DateTimePrecision.Value + ", " + tableColumn.Scale.Value + ")";
}
else
{
typeName = tableColumn.DataType + "(" + tableColumn.DateTimePrecision.Value + ")";
}
}
}
if (typeName != null)
{
property.Relational().ColumnType = typeName;
}
if (tableColumn.IsIdentity)
{
property.ValueGenerated = ValueGenerated.OnAdd;
if (typeof(byte) == SqlServerTypeMapping._sqlTypeToClrTypeMap[tableColumn.DataType])
{
Logger.LogWarning(
SqlServerDesignStrings.DataTypeDoesNotAllowSqlServerIdentityStrategy(tableColumn.Id, tableColumn.DataType));
}
else
{
property.SqlServer().ValueGenerationStrategy = SqlServerValueGenerationStrategy.IdentityColumn;
}
}
if (tableColumn.IsStoreGenerated ||
tableColumn.DataType == "timestamp")
{
// timestamp columns should always be treated as store generated
// (rowversion columns are stored as data type 'timestamp')
property.ValueGenerated = ValueGenerated.OnAddOrUpdate;
}
if (tableColumn.DefaultValue != null)
{
var defaultExpressionOrValue =
_sqlServerLiteralUtilities
.ConvertSqlServerDefaultValue(
((IProperty)property).ClrType, tableColumn.DefaultValue);
if (defaultExpressionOrValue != null &&
defaultExpressionOrValue.DefaultExpression != null)
{
property.Relational().GeneratedValueSql = defaultExpressionOrValue.DefaultExpression;
}
else if (defaultExpressionOrValue != null &&
defaultExpressionOrValue.DefaultValue != null)
{
property.Relational().DefaultValue = defaultExpressionOrValue.DefaultValue;
}
else
{
Logger.LogWarning(
SqlServerDesignStrings.UnableToConvertDefaultValue(
tableColumn.Id, tableColumn.DefaultValue,
((IProperty)property).ClrType, property.Name, property.DeclaringEntityType.Name));
}
}
}