Schema Information for Ado.Net 2.0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Ado.Net 2.0 how should you get get schema information?
I want to know the list of databases for a server and then iterate over that
list to show the tables and schema data in the table.

Thanks,

Marc
 
Hello:
In Ado.Net 2.0 how should you get get schema information?
I want to know the list of databases for a server and then iterate over that
list to show the tables and schema data in the table.
Click to expand...


Look the DbConnection.GetSchema method ( or int the specific
connection class of the provider you are using for example
SqlConnection.GetSchema )


To know what schema collections are supported by the provider you
can use:

xxxx.GetSchema("MetaDataCollections");


And check if the information you want to get is directly supported by
the provider.
 
Thanks,

Marc

Carlos Guzmán Ãlvarez said:
Hello:



Look the DbConnection.GetSchema method ( or int the specific
connection class of the provider you are using for example
SqlConnection.GetSchema )


To know what schema collections are supported by the provider you
can use:

xxxx.GetSchema("MetaDataCollections");


And check if the information you want to get is directly supported by
the provider.


--
Best regards

Carlos Guzmán Ãlvarez
Vigo-Spain
Click to expand...
 
Back
Top