Schema Information for Ado.Net 2.0

[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

 

[Cor Ligthert [MVP]]

Marc,

In my idea in the same way as in Net 1.x

http://www.vb-tips.com/default.aspx?ID=2dc619da-3c51-473a-8d50-f64cb0d2b77a

I hope this helps,

Cor

 

[Guest]

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.

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.

 

[Guest]

Thanks,

Marc

Marc,

In my idea in the same way as in Net 1.x

http://www.vb-tips.com/default.aspx?ID=2dc619da-3c51-473a-8d50-f64cb0d2b77a

I hope this helps,

Cor

 

[Guest]

Thanks,

Marc

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