I have a long result set in linq which is put in ratestest, I am mapping the result to ChargeElementsNullable. The issue is this doesnt include a fee record which is

```
var fees = (from r in _dbContext.Rates
                   where r.RateTypeFK == RateType.Fee && (r.LocaleBW & localeid) > 0 && (r.PolicyBW & policy.BitWise) > 0 && r.RateExclude == 0
                   select r);

```

So I want to add fees to ratestest and I could do that mapping again so I can use the add method, but I dont want to do that long winded mapping just for one record.. I am trying to add it to ratestest directly instead.. but no joy... I tried using DefaultIfEmpty expecting a left join.. but fee still wasnt in there.. 

```
var ratestest = (from qi in quoteInputs                         
                     join r in _dbContext.Rates on qi.RatePK equals r.RatePK
                     join fee in fees on r.RatePK equals fee.RatePK into feecontainer
                     from fee in feecontainer.DefaultIfEmpty()
                     join c in _dbContext.Covers on r.CoverCalcFK equals c.CoverPK into covers
                     from c in covers.DefaultIfEmpty()
                     join rt in _dbContext.RateTypes on qi.RateTypeFK equals rt.RateTypePK
                     where rt.Ratable == 1 ||
                     rt.RateTypePK == RateType.PostCode ||
                     rt.RateTypePK == RateType.Fee// employersliab.Contains(r.InputFK)
                     select new ChargeElementsNullable
                     {
                         PolicyFK = quote.PolicyFK,
                         InputFK = r.InputFK,
                         LongRate = r.LongRate,
                         RateLabel = r.RateLabel,
                         CoverName = c.CoverName,
                         CoverFK = r.CoverCalcFK,
                         CoverBW = c.BitWise,
                         ListRatePK = r.ListRatePK,
                         RatePK = r.RatePK,
                         RateName = r.RateName,
                         Rate = r.Rate,
                         Threshold = r.Threshold,
                         Excess = r.Excess,
                         DivBy = r.DivBy,
                         DiscountFirstRate = r.DiscountFirstRate,
                         DiscountSubsequentRate = r.DiscountSubsequentRate,
                         HazardRating = r.HazardRating,
                         TableFirstColumn = r.TableFirstColumn,
                         TableChildren = r.TableChildren,
                         RateTypeFK = r.RateTypeFK,
                         PageNo = r.PageNo,
                         SumInsured = qi.SumInsured,
                         NoItems = qi.NoItems,
                         RateValue = qi.RateValue,
                         TriggerCode = rt.TriggerCode,
                         Territory = territory
                     }).ToList();

```