protected CommandBuilderTestBase()
{
CurrentSource = new Source("My Data");
CurrentSource.Schemas.Add("SchemaA");
CurrentSource.AddFunction("Function A", "dbo", "My Definition");
CurrentSource.AddStoredProcedure("Stored Procedure A", "dbo", "My Definition");
var Table = CurrentSource.AddTable("Table A", "dbo");
Table.AddCheckConstraint("Constraint A", "My Definition");
Table.AddColumn <int>("Column A", DbType.Int32);
Table.AddTrigger("Trigger A", "My Definition", TriggerType.Insert);
//Table.AddForeignKey("Column A", "Foreign Table", "Foreign Column");
CurrentSource.AddView("View A", "dbo", "My Definition");
var ForeignTable = CurrentSource.AddTable("Foreign Table", "dbo");
ForeignTable.AddColumn <int>("Foreign Column", DbType.Int32);
Table.SetupForeignKeys();
DesiredSource = new Source("My Data");
DesiredSource.Schemas.Add("SchemaA");
DesiredSource.AddFunction("Function A", "dbo", "My Definition 2");
DesiredSource.AddStoredProcedure("Stored Procedure A", "dbo", "My Definition 2");
Table = DesiredSource.AddTable("Table A", "dbo");
Table.AddCheckConstraint("Constraint A", "My Definition2");
Table.AddColumn <int>("Column A", DbType.Int32);
Table.AddColumn <string>("Column B", DbType.String);
Table.AddTrigger("Trigger A", "My Definition 2", TriggerType.Update);
Table.AddForeignKey("Column A", "Foreign Table", "Foreign Column");
DesiredSource.AddView("View A", "dbo", "My Definition 2");
ForeignTable = DesiredSource.AddTable("Foreign Table", "dbo");
ForeignTable.AddColumn <int>("Foreign Column", DbType.Int32);
Table.SetupForeignKeys();
}
public void AddFunction()
{
var TempSource = new Source("MySource");
var Function = TempSource.AddFunction("FunctionName", "dbo", "FunctionDefinition");
Assert.Equal("FunctionName", Function.Name);
Assert.Equal("FunctionDefinition", Function.Definition);
Assert.Equal(TempSource, Function.Source);
}
public void Copy()
{
var TempSource = new Source("MySource");
_ = TempSource.AddTable("TableName", "dbo");
_ = TempSource.AddView("ViewName", "dbo", "ViewDefinition");
_ = TempSource.AddStoredProcedure("ProcedureName", "dbo", "ProcedureDefinition");
_ = TempSource.AddFunction("FunctionName", "dbo", "FunctionDefinition");
var TempCopy = TempSource.Copy();
Assert.Equal(TempSource, TempCopy);
}
