public PaginatedResults <AppUserDTO> GetUsers(UsersFilter filter)
        {
            filter.NormalizeValues();
            var query = filter.Apply(ERSAIDB.Users);

            query = query.OrderBy(u => u.UserName);
            var result = filter.ApplyPagination(query, ef => new AppUserDTO(ef));

            return(result);
        }