SaaS/multitenancy support: dynamic connection string

[Stanislaw]

I'm architecting a set of applications that will published via SaaS model. So one application will serve many customers and each of them will have its own database. So I need multitenancy support, i.e. each web request routes into its own database
Can I adapt OpenAccess to the requirements above (support for dynamic connection)?

[Kosta Hristov]

Hello Stanislaw,

You can use one of the non-default constructor overloads of the context class, specifically the one that takes a connection as parameter. This way you will be able to build a connection string based on the current user credentials and obtain a connection.
You can also use the SqlConnectionStringBuilder class to build the connection string more easily.
Hope that helps.

All the best,
Kosta
the Telerik team

[Stanislaw]

Thanks, this what I'm expected for!

[Chom]

Hello,
I am looking to build a connection string as a parameter. Can you point me to some more information on the non-default constructor overloads please.

Thank you

Chom

[Chom]

OK! Got it resolved with information from here.
http://www.telerik.com/help/openaccess-orm/fluent-mapping-creating-custom-context.html

Chom