Joined: Mon Jun 25, 2007 3:59 pm Posts: 15
|
I have about 20 PostgreSQL 8.1 and 8.2 databases in customer sites.
Every database contains about 150 tables.
Some tables contain user-defined fields which are different in different sites.
Base fields and table names are always the same. Some tables contain additional fields for custom business logic.
I'm creating NHIBERNATE .NET/MONO Winforms C# application using Visual C# 2005 Express.
Currently I'm using DataRow object and SELECT * FROM mytable to store and retrieve those variable columns.
It seems that user-defined columns are and DataRow based properties are not supported by nhibernate.
To fix this I think that application should create hbm files and entity assemblies (c# entity classes) dynamically from database structure to support user-added fields.
After database sturcture is changed, application can dedect this and generate new mapping file and entity class from database.
Any idea or sample how to implement this ?
Where to find framework or sample application which uses WinForms with NHibernate ?
Andrus.
|
|