如何使用LINQ to SQL&进行正确的联接C#

问题描述

大家好，我在使用LINQ& C#

Hey guys I'm having 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

我知道了

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?

推荐答案

 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 
                 };

这篇关于如何使用LINQ to SQL&进行正确的联接C#的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！