public static Role GetUserRole(ClaimsPrincipal identity, CMSDBContext db) { foreach (var claim in identity.Claims) { if (claim.Type == ClaimTypes.Role) { return(db.Roles.SingleOrDefault(role => role.Name.Equals(claim.Value))); } } return(null); }
public static CMSDBContext Create(string connectionString) { var optionsBuilder = new DbContextOptionsBuilder <CMSDBContext>(); optionsBuilder.UseMySQL(connectionString); //Ensure database creation var context = new CMSDBContext(optionsBuilder.Options); context.Database.EnsureCreated(); return(context); }