var query = (from a in db.Order
                         join b in db.OrderDetail on a.Id equals b.OrderId
                         join c in db.UserAddress on a.UserAddressId equals c.Id
                         join d in db.City on c.CityId equals d.Id
                         join e in db.Country on c.CountryId equals e.Id
                         join f in db.Payment on a.PaymentId equals f.Id
                         join g in db.OrderStatus on a.OrderStatusId equals g.Id
                         where a.UserId == userId
                         orderby a.CreatedDate descending
                         select a).ToList();