public void Init()
{
_testTable = new SysTable() { Name = "TestTable" };
_testColumn = new SysColumn()
{
ColumnID = 1,
Name = "TestColumn",
Identity = false,
Nullable = false,
SystemType = SysType.NVarChar,
MaxLength = 512
};
}
public void Init()
{
var columns = new List<SysColumn>()
{
new SysColumn()
{
Name = "FirstColumn",
ColumnID = 1,
Identity = true,
Nullable = false,
SystemType = Core.Enumerations.SysType.Int
},
new SysColumn()
{
Name = "SecondColumn",
ColumnID = 1,
Identity = false,
Nullable = true,
SystemType = Core.Enumerations.SysType.VarChar,
MaxLength = 100
},
new SysColumn()
{
Name = "ThirdColumn",
ColumnID = 1,
Identity = false,
Nullable = false,
SystemType = Core.Enumerations.SysType.NVarChar,
MaxLength = 100
}
};
_sourceTable = new SysTable() { Name = "SourceTable" };
_sourceTable.Columns.AddRange(columns);
_targetTable = new SysTable() { Name = "TargetTable" };
_targetTable.Columns.AddRange(columns.Take(2));
}
public void Init()
{
_testTable = new SysTablesBLL(ConfigurationManager.ConnectionStrings[_connName].ConnectionString).GetTable(_testTableName);
}
public override String GenerateSql(SysTable table, SysColumn schemaObject)
{
return CreateSql(table.Name, schemaObject, "ADD");
}