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