Hi All,

I am a newbie to NHibernate; I am currently doing a prototype with Spring.Net 1.1 M1 +NHibernate and the requirement is to get more than one customer use the site with different databases. I would like to reuse the HBMs and only want to change the connection string based on the user login.

I am not sure how I can do this.

USECASE:

1. Client logs in to the system with the unique site code
2. Based on the site code connect to the database using the connect string in the master database.

Is there an easy way to pass the connect string to the Hibernate Session to connect to the right database for the user. How can this be done?

I would like to reuse the same hbms as all the database (client specific) will have the same tables. Thats client A connects to Database A having tables CUSTOMER, PRODUCT and client B connects to Database B having tables CUSTOMER, PRODUCT (same table spec) till client N.

I am able to get the prototype working with standard configuration with the SessionFactory to a default settings and one connection string. I would like to change the connection string per request depending on the client.

Can someone guide me on how to achieve this? Is there any working sample that I can refer to? I am stuck with this for the past whole week unable to move any further.

Can someone help! Thanks in advance.

Here is raw sample of the solution that I have come up with for my project

public static ISession GetCurrentSession(string database)
{
string strConn = @"Server=SQLServer;initial catalog={0};User Id=sa;Password=sa"; // can get this from session or something else

HttpContext context = HttpContext.Current;
ISession currentSession = context.Items[CurrentSessionKey] as ISession;

if (currentSession == null)
{
IDbConnection dbConn = new System.Data.SqlClient.SqlConnection(
string.Format(strConn, database));

dbConn.Open();
currentSession = sessionFactory.OpenSession(dbConn);
context.Items[CurrentSessionKey] = currentSession;
}

return currentSession;
}

Use a connection provider instead. Far easier and it still allows NHibernate to control the connection which is far better as well.

What if you want to save seperate configuration settings for each database, like the SQL dialect.

I want this to work with best possible performance and for a web application. I have the same usecase as sunraider (original post).