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.
