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);
}