Is there an ORM that can dynamically generate DAL from a .Net WinForms application?
I would really appreciate your advice on weird spec.
We have a requirement to create an application where users can drag and drop field types onto a form so that they can create their own application. I have front-end setup but main problem is big problem.
There are forward transformation ORMs and reverse transformation ORMs, but I haven't found one that can be embedded in the application and generate tables, relationships, etc. when the user launches the application. Of course, if a table, field, or other object already exists, it won't overwrite them (and overwrite the underlying data).
ActiveRecord is the closest I've found, but it's web based and doesn't cover WinForm frameworks. I'd rather not have our crew write our own DAL, debug it, etc., when there might be an ORM out there that can do this.
Does anyone know of an ORM that can do this? If not, how would you go about solving this nightmare in the making process?
Thank you so much for your help.
It's an unlucky app - if your users wanted to do it, they just bought Visual Studio!
This is not a good position, because no, I do not know a suitable way to do this with an ORM. Unfortunately, if you are looking for this due to the pressure of the schedule, your project may be in trouble.
a source to share
In theory, you can use any ORM that can automatically generate the database schema. For example see DataObjects.Net, it usually generates and updates the database schema using persistent model based on persistent classes and additional custom definitions. But I can't imagine how your application would perform in this case ... there are many potential problems.
a source to share