Loaded RecordSet.Column.DataType is null in case of some ADO.NET providers

nreco / data

Fast DB-independent DAL for .NET Core: abstract queries, SQL commands builder, schema-less data access, POCO mapping (micro-ORM).

https://www.nrecosite.com/dalc_net.aspx

MIT License

184 stars 39 forks source link

Closed VitaliyMF closed 2 years ago

VitaliyMF commented 3 years ago

This happens in this case:

ADO.NET provider inherits netstandard2.0 DbDataReader class
and doesn't override GetColumnSchema method which returns only column name in the System.Data.Common.DbColumn (DataType is null)

How to fix: if DataType=null resolve column data type with IDataReader.GetFieldType method.