public void GetUpdateCommandTest()
{
FbCommandBuilder builder = new FbCommandBuilder(adapter);
Console.WriteLine();
Console.WriteLine("CommandBuilder - GetUpdateCommand Method Test");
Console.WriteLine( builder.GetUpdateCommand().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();
}
public void CommandBuilderWithExpressionFieldTest()
{
adapter.SelectCommand.CommandText = "select TEST.*, 0 AS VALOR from TEST";
FbCommandBuilder builder = new FbCommandBuilder(adapter);
Console.WriteLine();
Console.WriteLine("CommandBuilder - GetUpdateCommand Method Test");
Console.WriteLine( builder.GetUpdateCommand().CommandText );
builder.Dispose();
}