BAL.Manager.UserManager.GetVIPClients C# (CSharp) Method

GetVIPClients() public method

public GetVIPClients ( ) : IQueryable
return IQueryable
        public IQueryable<VIPClientDTO> GetVIPClients()
        {
            var VipClients =
                    from U in uOW.UserRepo.All.Where(x => x.RoleId == 3)
                    join V in uOW.VIPClientRepo.All
                        on U.Id equals V.UserId into joined
                    from V in joined.DefaultIfEmpty()
                    select new VIPClientDTO
                    {
                        Id = V != null ? V.Id : 0,
                        SetDate = V != null ? V.SetDate : DateTime.MaxValue,
                        UserId = U.Id,
                        UserName = U.UserName
                    };

            return VipClients.OrderByDescending(x => x.Id);
        }