Connect NHibernate to different databases with same schema

Question

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?

epitka · Accepted Answer · 2009-12-03 01:49:37Z

1

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

answered Dec 3, 2009 at 1:49

epitka

17.6k21 gold badges91 silver badges146 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Thad Over a year ago

does factory.OpenSession create a new session each time or is it cached?

epitka Over a year ago

each time, and it is in-expensive operation.

Paco · Accepted Answer · 2009-12-02 20:56:58Z

0

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

answered Dec 2, 2009 at 20:56

Paco

8,3923 gold badges33 silver badges41 bronze badges

Collectives™ on Stack Overflow

Connect NHibernate to different databases with same schema

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related