The difference between MySQL connector and SQL Server ADO

1, although the IDataReader interface is also implemented, but for

MySql.Data.MySqlClient.MySqlDataReader and System.Data.SqlClient.SqlDataReader

The return result of the GetSchemaTable method is different.

The following is the structure of the returned DataTable

Mysql	Sql server
AllowDBNull	AllowDBNull
BaseCatalogName	BaseCatalogName
Basecolumnname	Basecolumnname
Baseschemaname	Baseschemaname
BaseTableName	BaseServerName
ColumnName	BaseTableName
Columnordinal	ColumnName
ColumnSize	Columnordinal
DataType	ColumnSize
Isaliased	DataType
Isautoincrement	Datatypename
Isexpression	Isaliased
Ishidden	Isautoincrement
Isidentity	Iscolumnset
IsKey	Isexpression
Islong	Ishidden
IsReadOnly	Isidentity
Isrowversion	IsKey
IsUnique	Islong
NumericPrecision	IsReadOnly
NumericScale	Isrowversion
ProviderType	IsUnique
	Nonversionedprovidertype
	NumericPrecision
	NumericScale
	Providerspecificdatatype
	ProviderType
	Udtassemblyqualifiedname
	XmlSchemaCollectionDatabase
	XmlSchemaCollectionName
	XmlSchemaCollectionOwningSchema

The difference between MySQL connector and SQL Server ADO