public async Task <bool> Login(User user) { using (var con = new SqlConnection(this._connectionString)) { try { var result = _entityFrameworkDbContext.Set <User>() as IQueryable <User>; var slectUser = result.Where(x => x.Password.Equals(_helpers.Encrypt(user.Password)) && x.Username.Equals(user.Username)); return(slectUser.Count() > 0 ? true : false); } catch (Exception e) { this._logger.LogError($"Getting the data from config.AuthorizationRoles on config database failed: {e.Message}."); throw; } } }