Re: [Firebird-net-provider] What enumeration do I use against "ProviderType" when using "ExecuteReader" with Behavior "SchemaOnly | KeyInfo"

[Carlos G. A. <car...@te...>]

Hello:

> Indeed, it appears to provide "Object" which is then
> used to get a "Type" and from that I call
> "GetTypeCode" = always returns 1 on the sample
> databases that come with Firebird (Employee.gdb).

I'm making a test and all seems to work as expected, can you tell me if 
this is a correct test case:

	FbConnection connection = new FbConnection(connectionString);
	connection.Open();
	FbTransaction transaction = connection.BeginTransaction();

	FbCommand command = new FbCommand("Select * from test_table_01", 
connection, transaction);

	FbDataReader reader = 
command.ExecuteReader(CommandBehavior.KeyInfo|CommandBehavior.SchemaOnly);

	DataTable schema = reader.GetSchemaTable();

	foreach (DataRow row in schema.Rows)
	{
		foreach (DataColumn column in schema.Columns)
		{
			Console.WriteLine("{0} = {1}", column.ColumnName, row[column.Ordinal]);
		}
	}


	connection.Close();


In my test:

"DataType" column has the correct System type.
"ProviderType" column has the correct FbType value.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain