Get current schema at runtime

[Ashley]

Hi,

We have a database in which certain tables will have their amount of columns change occasionally. Is there any way for us to use OpenAccess to get the current DB schema at runtime so that we know what artificial properties to create?

Thanks
Ash

[Damyan Bogoev]

Hi Ashley,

I have prepared a sample application which demonstrates how to use the OpenAccess ORM Schema Reading API to obtain the needed information from the database.

You could filter the schemas and the relational items to be read from the database using the SchemaReadParameters instance. The ISchemaReader.GetSchema(parameters) method populate a MetadataContainer based on the obtained schema.

Hope that helps.

Greetings,
Damyan Bogoev
the Telerik team

[Ashley]

Hi Damyan,

Thanks for the response. It works exactly as we need.

Is this available through your documentation? I did a lot of searching and could not find anything about this except this post.

Thanks,
Ash

[Damyan Bogoev]

Hello Ashley,

I am afraid this feature is not documented yet. We will consider as a future improvement in the product's documentation.

Should you have any other questions, do not hesitate to contact us back.

All the best,
Damyan Bogoev
the Telerik team

[Ashley]

Thanks again for the quick feedback Damyan.