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[]) ); }