We, the OpenAccess ORM team, believe that an ORM solution should not only be easy to use and time-saving, but also flexible enough to reflect your needs. For instance, it is important that the names we generate comply exactly with your conventions, rather than being enforced. For that purpose we have provided the Naming Settings dialog a while ago, offering various naming options for the model on Class, Property and Field level.
Now we are proud to present the new flexibility we have exposed for generating the names of the tables and columns in your database - the Database Names Settings. They used to be available only as an API, but now they are visualized and automatically offered to you when creating empty models. You can also amend them from the Model Settings dialog at any time:
First, the dialog is offering you to base the names of the database and columns on either Properties or Field names, whichever suits your purpose better. After that, the name defined in your model is processed using the selected algorithm:
In addition, you are now in control whether you would like to delimit your identifiers or not.
If you have existing models, don’t worry – the visual settings are backward compatible so your model will continue using the same names. For all the new models you create you can expect different default options, based on your requests – the columns to be named as closely as possible to the properties that you see in the Visual Designer.
I hope that the new settings, available already in Q2 SP2 2012 of Telerik OpenAccess ORM, will make your life easier when creating or updating your database. In case they don't meet your expectation, just provide us your feedback and we might apply your ideas in the next release.
Stay tuned as we will start presenting the new features in Q3 2012 very soon!
Ivailo Ivanov is Team Lead in Telerik Data Access