Hi,

We have this strange accountancy-system in which the same tables are reprocuced for different child-companies. These tables have the same structure, but just a different suffix. For isntance: tblAccounts01, tblAccounts02, tblAccounts03.

I really would like to use NHibernate for this project, but the only way is that I would be able to change at runtime the tablename in the mapping file. Is there a way to do this? And if so: how?

Or any other nice way?
What I basicly want is: only doing selects from these kidn of tables, and being able to select values by different criteria (with the Session.CreateCriteria-clause).

I'm using NHibernate version 1.2.1.



Thanks a lot in advance,


Pieter