Is there a ADO.NET equivalent for ADOX

  • Thread starter Thread starter Sam Malone
  • Start date Start date
S

Sam Malone

I want to get a list of all the tables in a database then for each table,
all the columns, their datatypes, then views, indexes, etc. etc.
The database may be of any technology - maybe only able to be connected by
an ODBC connection (not just a SQL Server database).
With VB6 and ADOX I can iterate through an ADOX.Catalog and do this.
Yes, I could use Interop (ADOX) but I'm trying to be "pure" using only
VS.NET 2005 so the question is "Is there an equivalent capability using
native VS 2005?"

Thanks for your help/advice
 
Thanks very much (and thanks COR for your response too).
I'll try the docs/examples you guys have pointed to.

Greg - No it isn't just SQL Server and that's the challenge. I want to be
able to let a user pick a data source (e.g. a MySQL database via ODBC) and
then be able to "get at" all those objects and their properties. I have no
difficulty setting up the ODBC connection to read the "data". It's the
meta-data that's challenging me.
 
Back
Top