Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to retrieve Meta information about tables / fielda #124

Open
weggetor opened this issue Jan 9, 2025 · 3 comments
Open

How to retrieve Meta information about tables / fielda #124

weggetor opened this issue Jan 9, 2025 · 3 comments
Labels

Comments

@weggetor
Copy link

weggetor commented Jan 9, 2025

I am using a linq2db connection to an oracle database and this works fine.

Now I want to rerieve information about all the tables and the fields of each table in this database. How can I achieve this (using the connection which is already working). Do you habe a working c# snippet for this ?

Best, Torsten

@MaceWindu
Copy link
Contributor

DataProvider.GetSchemaProvider().GetSchema(this)

@weggetor
Copy link
Author

weggetor commented Jan 9, 2025

I tried this before, but unfortunately the Tables property has zero items:
2025-01-09 15_11_50-LINQPad 5

@weggetor
Copy link
Author

weggetor commented Jan 9, 2025

Found the solution for myself. I had to include the Schema in options:

var options = new GetSchemaOptions();
options.IncludedSchemas = new string[] {"GEMSYS"};
DataProvider.GetSchemaProvider().GetSchema(this,options) 

works now. Thank you for your help!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Development

No branches or pull requests

2 participants