I have to read the schema of a database. The datbase could
be Microsft Access or Oracle. The only thing i can pass on
is the connection string. The result i need to get is all
the tables we have in the database ( i mean tables created
by the user not the system tables) and the fields in those
The way I was thinking initilly was to use OleDbConnection
to connect to database and then use FillSchema method of
DataAdapter to read schema, and then enumerate
DataColoumnCollection to retireve fields information.
The problem with this approach is For DataAdapter i need
to pass the tables, right? How to retrieve tables
information only throug OleDbConnection?
Please guide me if there is any other simpler way of doing
this. Any links or code sample could be really helpful.
Please could you provide me some links, sample code on how
to do this using c# and ADO.NET