public void RefreshSchemaTest() { BdpCommandBuilder builder = new BdpCommandBuilder(adapter); Console.WriteLine(); Console.WriteLine("CommandBuilder - RefreshSchema Method Test - Commands for original SQL statement: "); Console.WriteLine(builder.GetInsertCommand().CommandText); Console.WriteLine(builder.GetUpdateCommand().CommandText); Console.WriteLine(builder.GetDeleteCommand().CommandText); adapter.SelectCommand.CommandText = "select int_field, char_Field from TEST where BIGINT_FIELD = ?"; adapter.SelectCommand.Parameters[0].ParameterName = "@bigint_field"; builder.RefreshSchema(); Console.WriteLine(); Console.WriteLine("CommandBuilder - RefreshSchema Method Test - Commands for new SQL statement: "); Console.WriteLine(builder.GetInsertCommand().CommandText); Console.WriteLine(builder.GetUpdateCommand().CommandText); Console.WriteLine(builder.GetDeleteCommand().CommandText); builder.Dispose(); }
public void GetDeleteCommandTest() { BdpCommandBuilder builder = new BdpCommandBuilder(adapter); Console.WriteLine(); Console.WriteLine("CommandBuilder - GetDeleteCommand Method Test"); Console.WriteLine( builder.GetDeleteCommand().CommandText ); builder.Dispose(); }
public void GetDeleteCommandTest() { BdpCommandBuilder builder = new BdpCommandBuilder(adapter); Console.WriteLine(); Console.WriteLine("CommandBuilder - GetDeleteCommand Method Test"); Console.WriteLine(builder.GetDeleteCommand().CommandText); builder.Dispose(); }
public void RefreshSchemaTest() { BdpCommandBuilder builder = new BdpCommandBuilder(adapter); Console.WriteLine(); Console.WriteLine("CommandBuilder - RefreshSchema Method Test - Commands for original SQL statement: "); Console.WriteLine( builder.GetInsertCommand().CommandText ); Console.WriteLine( builder.GetUpdateCommand().CommandText ); Console.WriteLine( builder.GetDeleteCommand().CommandText ); adapter.SelectCommand.CommandText = "select int_field, char_Field from TEST where BIGINT_FIELD = ?"; adapter.SelectCommand.Parameters[0].ParameterName = "@bigint_field"; builder.RefreshSchema(); Console.WriteLine(); Console.WriteLine("CommandBuilder - RefreshSchema Method Test - Commands for new SQL statement: "); Console.WriteLine( builder.GetInsertCommand().CommandText ); Console.WriteLine( builder.GetUpdateCommand().CommandText ); Console.WriteLine( builder.GetDeleteCommand().CommandText ); builder.Dispose(); }