private void DoGetDataTest (TestCaseResult result, string text, int column,
CommandBehavior behavior, Selector selector, Sequence sequence)
{
VirtuosoCommand cmd = null;
VirtuosoDataReader dr = null;
try
{
cmd = new VirtuosoCommand (text, connection);
dr = cmd.ExecuteReader (behavior);
CheckGetData (result, dr, column, selector, sequence);
}
finally
{
if (dr != null)
dr.Close ();
if (cmd != null)
cmd.Dispose ();
}
}
private void CreateTable ()
{
VirtuosoCommand cmd = new VirtuosoCommand ();
cmd.Connection = connection;
try
{
cmd.CommandText = "drop table foo";
cmd.ExecuteNonQuery ();
}
catch (Exception)
{
}
cmd.CommandText = "create table foo (id int primary key, c long varchar, nc long nvarchar, b long varbinary)";
cmd.ExecuteNonQuery ();
cmd.Dispose ();
checkTable = new DataTable ();
checkTable.Columns.Add ("id", typeof (int));
checkTable.Columns.Add ("c", typeof (string));
checkTable.Columns.Add ("nc", typeof (string));
checkTable.Columns.Add ("b", typeof (byte[]) );
}
