As the title states, I'm trying to design/create an ASP.NET MVC web application that supports multiple instances on a single URL.
The application is used across multiple departments in the company and security requires each department to have its own separate database. The application cannot have a shared database, such as a main database it initially connects to that keeps track of
the other databases. The only databases I'm allowed is specific to each department. Users may have access to one or more departments.
User authentication is done by claims via ADFS. The claims will contain information on which departments the user can access. For example, I could get the following claims for a user which indicates they can access 'deptA', 'deptB' and 'deptD':
Claim Type | Claim Value
http://schemas.microsoft.com/ws/2008/06/identity/claims/role | deptA ...
Go to the complete details ...