Please suggest one .Net ORM, which supports runtime schema evolution

Question

All RDBMSs support the ALTER TABLE command, which allows administrators to add new columns to tables, or to change the types of existing columns.

I am looking for such a runtime schema evolution function in .Net ORM. I have scanned a few ORM frameworks, and I cannot find an intuitive solution to such an evolution. The closest is OpenAccess (http://www.telerik.com/products/orm/features.aspx#runtime-changes). In OpenAccess, you may have artificial fields /types, but you use a different way to access them. In other words, they are different from pre-defined properties/classes. This is not I expect and is different from what ALTER Table does.

BTW, Versant Object Database announces that it has the function of DYNAMIC DATABASE SCHEMA EVOLUTION (http://www.versant.com/en_US/products/objectdatabase/index/).

If you find such a framework, or you have some solutions. Please notify me.

Thank you in advance.

Ying

Answer 1

Have you looked at nhibernate?

Answer 2

Hi, with Telerik OpenAccess ORM you are able to change the schema on the go, based on your model - so if your model is changed form the one that represents the actual situation in the database, you can just ask the data context for a schema update handler (the entry point via the API) and it will either: a) return a string representing the update script b) you can execute the returned script on the go

Anyways, please take a look (you can download a trial and make support requests during the trial period), as we are also interested in developing this technology further.