mysql connector 和 sqlserver ado.net 的区别
1,虽然同样是实现了IDataReader接口,但是 对于
MySql.Data.MySqlClient.MySqlDataReader 和 System.Data.SqlClient.SqlDataReader
来说GetSchemaTable 方法的返回结果是不同的
以下是返回的datatable的结构
| mysql | sqlserver |
| 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 |
浙公网安备 33010602011771号