Myujth

I have an application that uses identity database to store users and customers.

Each customer has also a separate database with its data and its connection string is stored in Customer table in the identity database.

AspNetUsers has a field to tell which customer the user belongs to (also identity db).

I want to assign connection string to the user when he logs in and make it available in the application for the duration of the session.

I currently have customer model:

public partial class `Customer`

 public int Id get; set; 
 public string Name get; set; 
 public int NoLicenses get; set; 
 public bool? Enabled get; set; 
 public string CustomerConnectionString get; set; 

and user model:

public class ApplicationUser : IdentityUser

 public string CustomerId get; set; 

 public bool? IsEnabled get; set; 

 // there ideally I'd have a connstring property

The models map db table fields.

I'm using .NET Core 1.1 and EF Core.

With the defalut ASP.NET Identity template , you can :

1. 
   

   extend the ApplicationUser class in Models folder :

   
   
   

   public class ApplicationUser : IdentityUser
   
    public string CustomerId get; set; 
   
    public bool? IsEnabled get; set; 
   
    //add your custom claims
    public string CustomerConnectionString get; set; 
   
   

   
   


2. 
   

   Add your custom model to ApplicationDbContext in Data folder :

   
   
   

   public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
   
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
    : base(options)
    
    
   
    protected override void OnModelCreating(ModelBuilder builder)
    
    base.OnModelCreating(builder);
    // Customize the ASP.NET Identity model and override the defaults if needed.
    // For example, you can rename the ASP.NET Identity table names and more.
    // Add your customizations after calling base.OnModelCreating(builder);
   
   
    
   
    public DbSet<Customer> Customers get; set; 
   
   

   
   



3. Sync your database : Add-Migration xxxx , then run the Update-Database command in Package Manager Console . Now you have the Customer table and have CustomerConnectionString column in AspNetUsers table.



4. 
   

   Create you own implementation of IUserClaimsPrincipalFactory by inheriting the default one to generate a ClaimsPrincipal from your user :

   
   
   

   public class AppClaimsPrincipalFactory : UserClaimsPrincipalFactory<ApplicationUser, IdentityRole>
   
    public AppClaimsPrincipalFactory(
    UserManager<ApplicationUser> userManager
    , RoleManager<IdentityRole> roleManager
    , IOptions<IdentityOptions> optionsAccessor)
    : base(userManager, roleManager, optionsAccessor)
    
   
    public async override Task<ClaimsPrincipal> CreateAsync(ApplicationUser user)
    
    var principal = await base.CreateAsync(user);
   
    if (!string.IsNullOrWhiteSpace(user.CustomerId))
    
   
    ((ClaimsIdentity)principal.Identity).AddClaims(new 
    new Claim("customid", user.CustomerId)
    );
    
   
    if (!string.IsNullOrWhiteSpace(user.CustomerConnectionString))
    
   
    ((ClaimsIdentity)principal.Identity).AddClaims(new 
    new Claim("CustomerConnectionString", user.CustomerConnectionString)
    );
    
    return principal;
    
   
   

   
   


5. 
   

   Register the custom factory you just created in your application startup class, after adding Identity service:

   
   
   

   // Add framework services.
   services.AddDbContext<ApplicationDbContext>(options =>
    options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));
   
   services.AddIdentity<ApplicationUser, IdentityRole>()
    .AddEntityFrameworkStores<ApplicationDbContext>()
    .AddDefaultTokenProviders();
   
    services.AddScoped<Microsoft.AspNetCore.Identity.IUserClaimsPrincipalFactory<ApplicationUser>, AppClaimsPrincipalFactory>();
   

   
   


6. 
   

   Then you could access the claims like :

   
   
   

   var connectString = User.Claims.FirstOrDefault(c => c.Type == "CustomerConnectionString").Value;
   

   
   


7. 
   

   Modify the creating/editing user view/controller , add the customer dropdownlist on view , get the custom id in Register function in AccountController , query the connectingString of custom from db , and save in ApplicationUser object :

   
   
   

    var user = new ApplicationUser UserName = model.Email, Email = model.Email ;
    var result = await _userManager.CreateAsync(user, model.Password);