public void AddUser(User user, string password)
        {
            string hash = BCrypt.Net.BCrypt.HashPassword(password);

            using var ctx     = new AuthDemoContext(_connectionString);
            user.PasswordHash = hash;
            ctx.Users.Add(user);
            ctx.SaveChanges();
        }
 public User GetByEmail(string email)
 {
     using var ctx = new AuthDemoContext(_connectionString);
     return(ctx.Users.FirstOrDefault(u => u.Email == email));
 }