Re: How to get meta data info in ADO.NET

Did you try Connection.GetSchema?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"CECIDer" <CECIDer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3F675963-6381-4D80-8013-F6C1261862F6@xxxxxxxxxxxxxxxx
Hi,

We are developing a Windows Form application that try to retrieve the
Database Schema from MS SQL Server and Oracle. The application is
developing
under Visual Studio .NET 2005 with the use of Schema API from ADO.NET 2.0.
With the use GetSchema() method of SQLConnection and OracleConnection, we
can successfully retrieve all the tables and columns from the database.
But
we
got the following difficulities during the retrieve of database schema:

1. How can i identify which columns are primary key or foreign key?

2. Can we retrieve the reference of foreign key (e.g, which column of
which
table are bing referenced by a foreign key)?

2. Can we retrieve the relations between tables?

3. Is it necessary to install Oracle Client for the use of
OracleConnection
within ADO.NET 2.0?

We are looking forward to your favorable reply.

Best Regards



.

Relevant Pages

  • Re: the 20% rule
    ... The fastest way to retrieve rows from a table is to access the row ... query that you use often, ... configuration variables, such as shared global memory areas, cached ... With Oracle, it is generally best to rely on tools like explain ...
    (comp.databases.theory)
  • RE: Oracle adapter issue in BizTalk
    ... And are you using BizTalk 2006 Server with Oracle ... How can I retrieve multiple records using oracle adapter? ... My procedure in the package returns ref courser. ... I want to retrieve multiples record from table using procedure. ...
    (microsoft.public.biztalk.general)
  • Issue with references and array slice with one member !
    ... Recently I faced one scenario with references and array slice in perl. ... I used following program to retrieve the rows from a table in Oracle using ... Connect to the database and return a database handle ...
    (perl.beginners)
  • Re: Capturing returned ODBC error message using form_Error
    ... > I have written an application with an Access front end to an Oracle ... > All security and data validation is in the Oracle database, ... Is there any way I can retrieve this message during ...
    (microsoft.public.access.externaldata)
  • Re: odbc>=8.1 and the broken euro symbol
    ... testserver via sys.props$: ... in prod 10.1 i cannot retrieve that value via v$parameter ... i havent worked with oracle since 5yrs and am only supposed to ...
    (comp.databases.oracle.misc)