title: .NET Core 3.1 application with SQL Server 2019 Express multiple databases support with main database for authentication
body: <p>I'm building a web application with .NET Core 3.1 and Angular 9. I would like to know if it is possible to use the internal .NET Core authentication / authorization mechanism to connect to an &quot;authorization&quot; database and based on the credentials provided by the user, connect to the database intended to be used for that user.</p>
  <p>The layout is as follows: one database that contains which users can connect to what database.</p>
  <p>Multiple structurally identical databases that the users can access based on their credentials.</p>
  <p>This is required in order to split the data across multiple databases, as each database will contain different data but with the same structure. Something like the following picture.</p>
  <p><a href="https://i.stack.imgur.com/mtq8R.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mtq8R.png" alt="multiple database access based on authorization" /></a></p>
  <p>The RDBMS to be used will be SQL Server 2019 Express. Would this approach require any modifications on the default mechanism that .NET Core 3.1 uses for user authentication? Should I consider a different approach based on the requirement?</p>
  <p>Thank you in advance for your help and advice.</p>