public void GetInsertCommandTest()
{
FbCommandBuilder builder = new FbCommandBuilder(adapter);
Console.WriteLine();
Console.WriteLine("CommandBuilder - GetInsertCommand Method Test");
Console.WriteLine(builder.GetInsertCommand().CommandText);
builder.Dispose();
}
public void TestWithClosedConnection()
{
Connection.Close();
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();
}