title: linq left join with filtering in joined
body: <p>I am getting duplication meals here</p>
  
  <pre><code>IEnumerable&lt;DTOHotMealsPrice&gt; lst = (from m in this.dbEntity.HOT_MEALS
      join ml in this.dbEntity.HOT_MEALS_PRICE   on m.MEALSID equals ml.MEALSID into mls
      from mls1 in mls.DefaultIfEmpty()
      where mls1.HOTID==hotelId
      select new DTOHotMealsPrice
      {
          MEALSID = m.MEALSID,
          MEALSNAME = m.MEALSNAME,
          CHPRICE = mls1.CHPRICE,
          PRICE = mls1.PRICE,
          HOTID = mls1.HOTID
      }).Distinct().ToList();
  </code></pre>
  
  <p>I want to list all HOT_MEALS and also join with 
  HOT_MEALS_PRICE when a mealsid reference on it</p>
  
  <p>When <code>mls1.HOTID==hotelId</code>, this will getting innerjoin results
  How could it will a proper result</p>