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?
 
Back
Top