title: Linq join iquery, how to use defaultifempty
body: <p>I have written a linq join query and I would like to take the values, if one of them are empty...</p>
  
  <p>Code:</p>
  
  <pre><code>var Details = 
  
  UnitOfWork.FlightDetails
            .Query()
            .Join
            (
                PassengersDetails,
                x =&gt; x.Flightno,
                y =&gt; y.FlightNo,
                (x, y) =&gt; new
                {
                    y.PassengerId,
                    y.classType,
                    x.Flightno,
                    x.FlightName,
                }
            );
  </code></pre>
  
  <p>I would like to use something like..</p>
  
  <pre><code>"Above query".DefaultIfEmpty
  (
      new 
      {
          y.PassengerId,
          y.classType,
          string.Empty,
          string.Empty
      }
  );
  </code></pre>
  
  <p><code>FlightDetails</code> is <code>Idatarepository</code> type on a class and <code>PassengerDetails</code> is <code>IQueryable</code> local variable result. How can I get result with <code>PassengerId</code> and Classtype without <code>flightno</code> and <code>flightname</code> included in the overall results?</p>