public void GetSchemaTable() { HsqlDataReader testSubject = NewTestSubject(); DataTable schemaTable = testSubject.GetSchemaTable(); Assert.Fail("TODO"); }
public void ExecuteReader() { using (HsqlConnection connection = NewConnection()) using (HsqlCommand testSubject = connection.CreateCommand()) { testSubject.CommandText = "select * from information_schema.system_tables"; using (HsqlDataReader reader = testSubject.ExecuteReader()) { object[] values = new object[reader.FieldCount]; while (reader.Read()) { int fieldCount = reader.GetValues(values); for (int i = 0; i < fieldCount; i++) { object value = values[i]; Console.Write(value); Console.Write(" : "); } Console.WriteLine(); } } } using (HsqlConnection connection = NewConnection()) using (HsqlCommand testSubject = connection.CreateCommand()) { testSubject.CommandText = "select * from information_schema.system_tables"; HsqlDataReader reader = testSubject.ExecuteReader(CommandBehavior.SchemaOnly); DataTable schemaTable = reader.GetSchemaTable(); foreach (DataRow row in schemaTable.Rows) { object[] values = row.ItemArray; foreach (object value in values) { Console.Write(value); Console.Write(" : "); } Console.WriteLine(); } } }