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); }