inner join in linq to entities

Question

I have entity called Customer and it has three properties   public class Customer       public virtual Guid CompanyId      public virtual long Id      public virtual string Name      I have also entity called Splitting and it has three properties   public class Splitting       public virtual long CustomerId      public virtual long Id      public virtual string Name      Now I need to write a method that gets companyId and customerId  The method should return list of splitting that relates to the specific customerId in the companyId  Something like this   public IList lt Splitting gt  get Guid companyId  long customrId            var res from s in Splitting              from c in Customer                     how to continue       return res ToList

User · Answer

Not 100  sure about the relationship between these two entities but here goes   IList lt Splitting gt  res    from s in  data source                          where s Customer CompanyID     companyID   amp  amp                                s CustomerID     customerID                          select s  ToList     IList lt Splitting gt  res    data source  Splittings Where                             x   gt  x Customer CompanyID     companyID   amp  amp                                  x CustomerID     customerID   ToList

User · Answer

var res   from s in Splitting            join c in Customer on s CustomerId equals c Id          where c Id    customrId              amp  amp  c CompanyId    companyId         select s    Using Extension methods   var res   Splitting Join Customer                   s   gt  s CustomerId                   c   gt  c Id                    s  c    gt  new   s  c                Where sc   gt  sc c Id    userId  amp  amp  sc c CompanyId    companId              Select sc   gt  sc s

User · Answer

public IList lt Splitting gt  get Guid companyId  long customrId            var res from c in Customers data source             where c CustomerId   customrId  amp  amp  c CompanyID    companyId             from s in Splittings data srouce             where s CustomerID   c CustomerID             select s       return res ToList

User · Answer

You can find a whole bunch of Linq examples in visual studio  Just select Help - gt  Samples  and then unzip the Linq samples   Open the linq samples solution and open the LinqSamples cs of the SampleQueries project   The answer you are looking for is in method Linq14   int   numbersA     0  2  4  5  6  8  9    int   numbersB     1  3  5  7  8     var pairs      from a in numbersA    from b in numbersB    where a  lt  b    select new  a  b

[c#] inner join in linq to entities

Examples related to c#

Examples related to .net

Examples related to linq-to-entities