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