| 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.
 
 
 |  |