private static void CheckColumnSchema(
ColumnSchema column,
SqlDbType sqlDbType,
object defaultValue,
bool allowNull,
int?size,
byte?precision,
byte?scale)
{
SqlServerColumnSchema sqlServerColumn = (SqlServerColumnSchema)column;
string columnName = sqlServerColumn.Name;
sqlServerColumn.SqlDbType.Should().Be(sqlDbType, $"{columnName} should have correct SqlDbType.");
sqlServerColumn.AllowNull.Should().Be(allowNull, $"{columnName} should allow NULL.");
if (defaultValue != null)
{
sqlServerColumn.DefaultValue.Should().Be(defaultValue, $"{columnName} should have correct default value.");
}
if (size.HasValue)
{
sqlServerColumn.Size.Should().Be(size, $"{columnName} should have correct size.");
}
if (precision.HasValue)
{
sqlServerColumn.Precision.Should().Be(precision, $"{columnName} should have correct precision.");
}
if (scale.HasValue)
{
sqlServerColumn.Scale.Should().Be(scale, $"{columnName} should have correct scale.");
}
}
private static void CheckColumnSchema(
ColumnSchema column, SqlDbType sqlDbType, object defaultValue, bool allowNull, int?size)
{
SqlServerColumnSchema msAccessColumn = (SqlServerColumnSchema)column;
string columnName = msAccessColumn.Name;
msAccessColumn.SqlDbType.Should().Be(sqlDbType, $"{columnName} should have correct SqlDbType.");
msAccessColumn.AllowNull.Should().Be(allowNull, $"{columnName} should allow NULL.");
if (defaultValue != null)
{
msAccessColumn.DefaultValue.Should().Be(defaultValue, $"{columnName} should have correct default value.");
}
if (size.HasValue)
{
msAccessColumn.Size.Should().Be(size, $"{columnName} should have correct size.");
}
}
