metadata from views

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
tkoning
Posts: 2
Joined: Wed 31 Mar 2010 10:37

metadata from views

Post by tkoning » Wed 31 Mar 2010 12:29

Hello,
I'm currently trying to get the metadata from a View from an Oracle 10g database.
However, the GetSchema method does not support reference data of views.
Is there a way to find this data with DotConnect without having the owner rights?

Thanks in advance!

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Thu 01 Apr 2010 09:36

Please try using OracleMetaDataCollectionNames.Views as the GetSchema parameter.

For all possible metadata collections, please see the OracleMetaDataCollectionNames class.

tkoning
Posts: 2
Joined: Wed 31 Mar 2010 10:37

Post by tkoning » Thu 01 Apr 2010 10:34

I have tried this, and am still using it. But this does not return all the data i want to have.
When using the Views parameter in GetSchema(), it returns the name, query and schemaname of the view, but it does not return the columnnames and their parenttable names.

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Thu 01 Apr 2010 14:50

We will investigate the possibility of retrieving the ViewColumns metadata collection and notify you about the results as soon as possible.

Post Reply