From: Carlos G. A. <car...@te...> - 2003-06-25 15:30:36
|
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 |