NHibernate version: 1.2.1GA

DB: SQL Server 2005


Visual Studio 2008 on .Net 3.5 with a dash of WCF and ASP.Net thrown into the mix :)


I'm interested in dynamically setting the database to be connecting to, how would this be done? We'll be taking in an ID, and depending on that ID, I'd like to pull the DB name out of a configuration file, and then have all operations happen on that specific DB.


Also, somewhat unrelated, what's the best designer to use in conjunction with NHibernate? I'd prefer something that integrated into Visual Studio (if possible). I'd like to avoid writing the XML by hand.

Let me add:

I'm very new to NHibernate. I'm currently attempting to RTFM, but a nudge in the right direction wouldn't hurt :)

You can programatically create a isessionfactory using a Configuration object.

As far as I know there are some mapping creating tools out there. Personally though, I'm petty sure the easiest and best way is to right them by hand. Once you learn it, it goes quite fast. You are aware you can have intellisense support in VS? If not, just google for it. You just need to put certain (to remember the file names) xsd file in correct VS directory.

/Roger