public void GetDeleteCommandTest()
{
FbCommandBuilder builder = new FbCommandBuilder(adapter);
Console.WriteLine();
Console.WriteLine("CommandBuilder - GetDeleteCommand Method Test");
Console.WriteLine( builder.GetDeleteCommand().CommandText );
builder.Dispose();
}
public void RefreshSchemaTest()
{
FbCommandBuilder builder = new FbCommandBuilder(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 * from TEST where 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();
}