I am creating a Multi Tenant Application with Silverlight Business Application Template.
I want to use ONE SINGLE database for all users accross many tenants.
So the application should be able to decide which database to use depends on user logins.
I have followed the method By Matt Duffield , and it worked.
But I wonder if this method will be slow , as there will be a overhead of having to query USER TABLE for each query.
Is there any way to extend the ServiceContext object?
I want to extend it like this, ServiceContext.User.Idetity.MYUSERCATEGORY
So that no additional database queries needed.
Is it possible to do it?
View Complete Post