Web system accessed by various companies appsettings

Question

I am developing an application in ASP.NET Core, in which each company has its own database. The question is: how can I do for the company To access the site by putting user and password and access its information, remembering that there are several companies? There is how to change the appsettings.config for this, another alternative?

I’ve been seeing the question Databases for different customers, not if it would be the right thing to do.

Answer 1

One of the solutions is to model the bank containing foreign keys for companies.

Ex: You have the user "John" with the foreign key for the company "X", soon when the "John" access the system you will know that you must show the company information "X", this is valid for the other entities of the system.

Answer 2

I’ve been seeing the question Databases for different customers, not if it would be the right thing to do.

It depends. If you want to separate databases by company, it is, but it doesn’t seem to be your case.

I’m guessing you’re using ASP.NET Core Identity. So you need to be familiar with the concept of Claims, that is, portions of identity that your user has.

To add a club to your user, you can use:

await userManager.AddClaimAsync(user, new System.Security.Claims.Claim("empresa", "A"));

Or:

usuario.Claims.Add(new IdentityUserClaim<string> 
{ 
    ClaimType = "empresa", 
    ClaimValue = "A" 
});

contextoIdentity.Entry(usuario).State = EntityState.Modified;
await contextoIdentity.SaveChangesAsync();

Or this answer here. Whatever.

If it is very necessary that you exchange the database, you will also need to change the Connection string at runtime, probably inside a Action Filter, or in the event OnActionExecuting of Controller.

Otherwise, just use the Entityframework.Dynamicfilters package. See here how to use.