title: How to make a right join using LINQ to SQL & C#?
body: <p>I have a problem creating the following SQL Statement using LINQ &amp; C#</p>
  <pre><code>    select c.IDAddenda, c.Descripcion
        from CatAddendas c 
  right join EmpresaAddenda e on e.IDAddenda = c.IDAddenda
       where e.rfc = 'SUL010720JN8'
    order by c.IDAddenda asc
  </code></pre>
  <p>I got this:</p>
  <pre><code>public IEnumerable&lt;CatAddenda&gt; TraeAddendas(string rfc)
  {
      DataClasses1DataContext dc = new DataClasses1DataContext(...);
  
      return (from adds in dc.EmpresaAddendas
              cats.IDAddenda    into joined 
              where adds.RFC == rfc
              select adds.CatAddenda);
  }
  </code></pre>
  <p>This is not doing a right join, so any ideas?</p>