Is there any way to get database schema in generic way?

  • Thread starter Thread starter Young Jin
  • Start date Start date
Y

Young Jin

I'm writing code that provides generic view(vendor independent) to the
client about table list, primary key or view. Almost all connections
are made via vendor's .NET provider.

I researched and found that OleDbConnection.GetOleDbSchemaTable() can
make it. But I only make connection via .NET provider, so it's
impossible.

Is there anybody has idea about generic way to get db schema in
ado.net?

Thank you in advance.
 
Hi,

Since each database has its own internal format, there is no generic way to
get schema definition. Most generic way, actually, is using that Oledb
provider. But why does not it work for you?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Schemas in ADO.Net 2.0 2
Getting Schema Information Through ADO.NET 2
Setting Oracle Schema 1
Clone or copy table.. Schema Information.. Generic ado.net connection 4
How to get Archive-Informations of Database 6
Can someone please tell me... 23
Best way to get started? 5
Unable to Update A Table Schema Progmatically 1

Back
Top