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