protected static DatabaseDefinitions Column_Add2_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddWithNewColumn = new TestDatabaseSimple();
ddWithNewColumn.SetVersions(version.GetTypeMapper());
ddWithNewColumn.GetTable("Company").AddVarChar("Name2", 100);
ddWithNewColumn.GetTable("Company").AddVarChar("Name3", 100, true);
return(new DatabaseDefinitions(ddOriginal, ddWithNewColumn, "TestDatabaseSimple", "TestDatabaseSimple_Column_Add2"));
}
protected static DatabaseDefinitions Column_Change2_Length_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
ddOriginal.GetTable("Company").AddNVarChar("Name2", 100);
var ddColumnLengthsChanged = new TestDatabaseSimple();
ddColumnLengthsChanged.SetVersions(version.GetTypeMapper());
ddColumnLengthsChanged.GetTable("Company").AddNVarChar("Name2", 100);
ddColumnLengthsChanged.GetTable("Company")["Name"].Type.Length += 1;
ddColumnLengthsChanged.GetTable("Company")["Name2"].Type.Length += 1;
return(new DatabaseDefinitions(ddOriginal, ddColumnLengthsChanged, "TestDatabaseSimple", "TestDatabaseSimple_Column_Change2_Length"));
}
protected static DatabaseDefinitions Column_Remove2_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
ddOriginal.GetTable("Company").AddNVarChar("Name2", 100);
var ddColumnsRemoved = new TestDatabaseSimple();
ddColumnsRemoved.SetVersions(version.GetTypeMapper());
ddColumnsRemoved.GetTable("Company").Columns.Remove("Name");
ddColumnsRemoved.GetTable("Company").Columns.Remove("Name2");
return(new DatabaseDefinitions(ddOriginal, ddColumnsRemoved, "TestDatabaseSimple", "TestDatabaseSimple_Column_Remove2"));
}
protected static DatabaseDefinitions Column_Change_DbType_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddDbTypeChanged = new TestDatabaseSimple();
ddDbTypeChanged.SetVersions(version.GetTypeMapper());
if (version == MsSqlVersion.MsSql2016)
{
ddDbTypeChanged.GetTable("Company")["Name"].Type.SqlTypeInfo = MsSqlType2016.NChar;
}
else if (version == OracleVersion.Oracle12c)
{
ddDbTypeChanged.GetTable("Company")["Name"].Type.SqlTypeInfo = OracleType12c.NChar;
}
return(new DatabaseDefinitions(ddOriginal, ddDbTypeChanged, "TestDatabaseSimple", "TestDatabaseSimple_Column_Change_DbType"));
}
protected static DatabaseDefinitions Pk_Add_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.GetTable("Company").Columns["Id"].Properties.Remove(
ddOriginal.GetTable("Company").Columns["Id"].Properties.OfType <Identity>().First()
);
ddOriginal.GetTable("Company").Properties.Remove(
ddOriginal.GetTable("Company").Properties.OfType <PrimaryKey>().First()
);
ddOriginal.SetVersions(version.GetTypeMapper());
var ddWithPk = new TestDatabaseSimple();
ddWithPk.SetVersions(version.GetTypeMapper());
ddWithPk.GetTable("Company").Columns["Id"].Properties.Remove(
ddWithPk.GetTable("Company").Columns["Id"].Properties.OfType <Identity>().First()
);
return(new DatabaseDefinitions(ddOriginal, ddWithPk, "TestDatabaseSimple", "TestDatabaseSimple_Pk_Add"));
}
protected static DatabaseDefinitions Column_Change_Nullable_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddNullableChanged = new TestDatabaseSimple();
ddNullableChanged.SetVersions(version.GetTypeMapper());
ddNullableChanged.GetTable("Company")["Name"].Type.IsNullable = !ddOriginal.GetTable("Company")["Name"].Type.IsNullable;
return(new DatabaseDefinitions(ddOriginal, ddNullableChanged, "TestDatabaseSimple", "TestDatabaseSimple_Column_Change_Nullable"));
}