CODEWITHSUNDEEP
nhibernatesessionsessionfactory
Thad
Thad

Reputation: 1530

Connect NHibernate to different databases with same schema

We are in the process of splitting our db into several smaller ones. The schemas will be exactly the same and we will control which db the system connects to when the client logs in. I receive an error if I do not set a connection string in my nhibernate configuration. I do not want to create a factory for each db. Is it possible to have a session factory provide a Session that I can set the connection string before using it?

Upvotes: 1

Views: 525

Answers (2)

epitka
epitka

Reputation: 17627

Have not used it but there is a method ChangedDatabase on the Session.Connection. Maybe that would work?

Upvotes: 1

Paco
Paco

Reputation: 8381

Maybe you can use NHibernate.Shards, in the NHcontrib repository

Upvotes: 0

Related Questions