public void DropTable (VirtuosoConnection connection) { VirtuosoCommand drop = connection.CreateCommand (); drop.CommandText = "drop table foo"; try { drop.ExecuteNonQuery(); } catch (Exception) { } finally { drop.Dispose(); } }
public void InsertRow (VirtuosoConnection connection, int i) { string s = new string (new char[3] { (char) ('a' + i), (char) ('b' + i), (char) ('c' + i) }); VirtuosoCommand insert = connection.CreateCommand(); insert.CommandText = "insert into foo values (" + i + ", '" + s + "')"; insert.ExecuteNonQuery(); insert.Dispose(); DataRow row = checkTable.NewRow (); row["id"] = i; row["txt"] = s; checkTable.Rows.Add (row); }
public void CheckTable (VirtuosoConnection connection, TestCaseResult result) { VirtuosoCommand select = connection.CreateCommand (); select.CommandText = "select * from foo"; VirtuosoDataAdapter adapter = new VirtuosoDataAdapter (); adapter.SelectCommand = (VirtuosoCommand) select; DataSet dataset = new DataSet (); adapter.Fill (dataset); DataTable table = dataset.Tables["Table"]; result.FailIfNotEqual (checkTable.Rows.Count, table.Rows.Count); result.FailIfNotEqual (checkTable.Columns.Count, table.Columns.Count); for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; DataRow checkRow = checkTable.Rows[i]; for (int j = 0; j < table.Columns.Count; j++) { string name = table.Columns[j].ColumnName; result.FailIfNotEqual (checkRow[name], row[name]); } } }
public void CreateTable (VirtuosoConnection connection) { VirtuosoCommand create = connection.CreateCommand (); create.CommandText = "create table foo (id int primary key, txt varchar(100))"; create.ExecuteNonQuery(); create.Dispose(); checkTable = new DataTable (); checkTable.Columns.Add ("id", typeof (int)); checkTable.Columns.Add ("txt", typeof (string)); InsertRow (connection, 1); InsertRow (connection, 2); }