How to make a right join using LINQ to SQL & C#?

Question

I have a problem creating the following SQL Statement using LINQ & C#

    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

I got this:

public IEnumerable<CatAddenda> TraeAddendas(string rfc)
{
    DataClasses1DataContext dc = new DataClasses1DataContext(...);

    return (from adds in dc.EmpresaAddendas
            cats.IDAddenda    into joined 
            where adds.RFC == rfc
            select adds.CatAddenda);
}

This is not doing a right join, so any ideas?

stackoverflow.com/questions/2730810/right-outer-join-in-linq — Phil
– Phil, Commented Mar 28, 2012 at 19:52

ionden · Accepted Answer · 2012-03-28 20:13:33Z

14

 var RightJoin = from adds in dc.EmpresaAddendas
                 join cats in CatAddendas 
                     on adds.IDAddenda equals cats.IDAddenda into joined
                 from cats in joined.DefaultIfEmpty()
                 select new
                 {
                     Id = cats.IDAddenda,
                     Description = cats.Descripcion 
                 };

edited Mar 28, 2012 at 20:13

answered Mar 28, 2012 at 19:55

ionden

12.8k1 gold badge47 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

SZT Over a year ago

This is left outer join

jjxtra Over a year ago

Are you sure about that?

Doguhan Uluca · Accepted Answer · 2012-03-28 20:35:11Z

5

var results = from e in EmpresaAddenda
              join c in CatAddendas
              on e.IDAddenda equals c.IDAddenda into f
              from c in f.DefaultIfEmpty()
              select new
              {
                   ID = c.IDAddenda,
                   Description = c.Descripcion 
              };

You can apply where and order by on the results.

edited Mar 28, 2012 at 20:35

answered Mar 28, 2012 at 20:00

Doguhan Uluca

7,3734 gold badges41 silver badges52 bronze badges

Collectives™ on Stack Overflow

How to make a right join using LINQ to SQL & C#?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related