It could be if DynamicConnectionProvider would use the WebSession variable to point out the databasename. Then DynamicConnectionProvider could use the WebSession to build the session with the right databaseconnectionstring. It will be kind of akward way to do it. Some class needs to be responsible to put the right databasename in a websession with the right key so the DynamicConnectionProvider can read it this isn't obvious, but maybe the only way to do it.
Im thinking about using OpenSession(IDbConnection dbConnection), more visible. But I have something in my back head telling me that hasn't SessionFactory something to do with second level cache or something else that would make this a bad solution? On Oct 26, 10:53 pm, Tuna Toksoz <[email protected]> wrote: > Does that solve your problem? > > Tuna Toksöz > Eternal sunshine of the open source mind. > > http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike > > On Mon, Oct 26, 2009 at 11:51 PM, Tuna Toksoz <[email protected]> wrote: > > oh yeah > > >http://nhforge.org/wikis/howtonh/dynamically-change-user-info-in-conn... > > > Tuna Toksöz > > Eternal sunshine of the open source mind. > > >http://devlicio.us/blogs/tuna_toksoz > >http://tunatoksoz.com > >http://twitter.com/tehlike > > > On Mon, Oct 26, 2009 at 11:49 PM, Tuna Toksoz <[email protected]> wrote: > > >> I think He does but i couldn't remember the keywords. > > >> Tuna Toksöz > >> Eternal sunshine of the open source mind. > > >>http://devlicio.us/blogs/tuna_toksoz > >>http://tunatoksoz.com > >>http://twitter.com/tehlike > > >> On Mon, Oct 26, 2009 at 11:49 PM, Niclas Pehrsson > >> <[email protected]>wrote: > > >>> It would be really nice if someone has a link to Fabio's solution, or > >>> maybe he has it on his blog? > > >>> On Oct 26, 10:40 pm, Tuna Toksoz <[email protected]> wrote: > >>> > Fabio has a better solution. I think it was implementing/extending > > >>> > NHibernate.Connection.DriverConnectionProvider > > >>> > thing. > > >>> > Tuna Toksöz > >>> > Eternal sunshine of the open source mind. > > >>>http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitt... > > >>> > On Mon, Oct 26, 2009 at 11:32 PM, Jason Dentler < > >>> [email protected]>wrote: > > >>> > > Niclas, > > >>> > > ISessionFactory.OpenSession accepts an IDbConnection. Using your > >>> favorite > >>> > > IoC framework, create a unit-of-work scoped connection to the > >>> specific > >>> > > customer's DB and pass it in to a single application-scoped session > >>> > > factory. I doubt this was the intended purpose, but it may work > >>> anyway. I > >>> > > would start there. > > >>> > > Thanks, > >>> > > Jason > > >>> > > On Mon, Oct 26, 2009 at 4:12 PM, Niclas Pehrsson <[email protected] > >>> >wrote: > > >>> > >> Hi I'm doing some research when using NHibernate with Multi tenancy, > >>> I > >>> > >> have choosen to start with multi databases to solve the tenancy > >>> > >> problem. One database per customer. We hope that our product will > >>> have > >>> > >> several thousands customers, this will mean several databases. > > >>> > >> Now say that we will host this product and let the login of the > >>> > >> customer decide which database to use for the user, then we need to > >>> > >> have thousands of SessionFactories in the server memory cause we > >>> don't > >>> > >> wanna build it each time a user requests for it. > >>> > >> This will take a lot of memory, and some performance for the > >>> > >> sessionfactory lookup, that has been a common solution to solve this > >>> > >> problem by the research I have seen so far. > > >>> > >> So is thousands of loaded sessionfactories a problem? or will it be > >>> > >> fine? > > >>> > >> Can a custom like implementation of a garbage collection be used > >>> that > >>> > >> throws out sessionfactories that hasn't been used for a time solve > >>> > >> this problem? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
