OleDbDataReader oleDbDataReader = oleDbCommand.ExecuteReader(CommandBehavior.KeyInfo);
DataTable dataTable = oleDbDataReader.GetSchemaTable();
How does GetSchemaTable() work?
Where does it get its information in RDBMS?
views:
82answers:
2
+1
A:
From the system tables (e.g., syscolumns, sysobjects, etc) in each database.
marmstrong
2009-10-15 19:34:08
Is this always the case, or does that depend on the OLE DB provider being used?
John Saunders
2009-10-15 19:39:00
That's wrong. The result might be dynamic, a user might have no permission to view sysobjects (VIEW DEFINITION in MSSQL 2005+) etc.
VladV
2010-07-15 14:00:21
A:
GetSchemaTable() reads the metadata on the resultset returned by ADO.NET.
VladV
2010-07-15 14:01:06