Hi,

I'm working on a project with a legacy database and would like to use NHibernate. The database contains a table (USER), which is subdivided into multiple mdb's. USER0.MDB contains all users with id < 1000, USER1.MDB contains users with id between 1000 and 2000 and so on.

I would like to be able to load or save any user object without caring in which MDB it is stored. Additionally it would be nice if I could perform query's over the whole table (all MDB's), but that's not really that important.

I'm relatively new to NHibernate and have no clue how this could be implemented so if anyone more experienced has some pointers how this could be done, any help is greatly appreciated.