BUG: The GetSchemaTable method of the SqlDataReader object returns the wrong column name

lbq1221119

于 2007-09-06 20:27:00 发布

阅读量354

点赞数

CC 4.0 BY-SA版权

文章标签： object microsoft documentation sql server library class

本文链接：https://blog.youkuaiyun.com/lbq1221119/article/details/4606890

本文讨论了SqlDataReader.GetSchemaTable方法返回额外的BaseServerName属性的问题，该属性不在官方文档中列出。文章提供了使用OleDbDataReader作为替代方案来获取SchemaTable信息的方法。

SYMPTOMS

The GetSchemaTable method of the SqlDataReader object returns columns, the BaseServerName and BaseCatalogName properties. However, SqlDataReader.GetSchemaTable should only return BaseCatalogName.

CAUSE

In addition to the columns that are described in the Microsoft .NET Framework Class Library Software Development Kit (SDK) documentation, SqlDataReader.GetSchemaTable returns a column named BaseServerName. BaseServerName is the name of the Microsoft SQL Server instance that SqlDataReader uses. BaseServerName appears before BaseCatalogName in the DataTable that describes the column metadata.

RESOLUTION

Because this problem does not occur with the OleDbDataReader object, you can use OleDbDataReader to obtain the SchemaTable information.