Thanks for the hint. I had a look at the class, but it's not exactly what I am looking for. Furthermore, the class is commented with 'Still very experimental and it's not bullet proof for all situations' (AR V2.0.0.0)
On 8 Jul., 23:47, Henry Conceição <[email protected]> wrote: > Check the DifferentDatabaseScope. > > On Jul 8, 4:51 am, Markus <[email protected]> wrote: > > > Hi all! > > > I'm developing a multi-tier application that will support multiple > > tenants. Each tenant's data will be isolated in a separate database. > > I'm looking for an elegant way to set the connection string during > > runtime depending on the tenant's identifier (e.g. ID, name ...). My > > idea is to use a custom ConnectionProvider that returns the > > appropriate tenant-specific connection string, something like that: > > > public class MyConnectionProvider : DriverConnectionProvider > > { > > private object tenant; > > > public MyConnectionProvider(object tenant) > > { > > this.tenant = tenant; > > } > > > protected override string ConnectionString > > { > > get > > { > > return BuildMyTenantConnectionString() > > } > > } > > } > > > On the other side I have my business methods that access the database > > using AR, say for example: > > > public IList GetCustomers(object tenant) > > { > > return Customer.FindAll(); > > > } > > > Now my question is how to inject/pass the 'tenant' parameter form my > > business method into my custom connection provider in order to access > > the data in the correct database? Are there any best practices? Or > > alternative solutions? > > > Thanks > > > Markus > > -- You received this message because you are subscribed to the Google Groups "Castle Project Users" 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/castle-project-users?hl=en.
