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<Splitting> get(Guid companyId, long customrId) {         var res=from s in Splitting              from c in Customer              ...... how to continue?      return res.ToList(); } 

Answer 1

var res = from s in Splitting            join c in Customer on s.CustomerId equals c.Id          where c.Id == customrId             && c.CompanyId == companyId         select s; 

Using Extension methods:

var res = Splitting.Join(Customer,                  s => s.CustomerId,                  c => c.Id,                  (s, c) => new { s, c })            .Where(sc => sc.c.Id == userId && sc.c.CompanyId == companId)            .Select(sc => sc.s); 

Answer 2

You can find a whole bunch of Linq examples in visual studio. Just select Help -> 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 < b    select new {a, b};