LINQ Join Multiple Terms And

Question

I want to combine two objects in my MVC application to process data through a LINQ connection.

For this, I am trying to write a query, for example,

from enumeration in db.Enumerations join cust in db.Customers on ( enumeration.Value equals cust.lkpStatus && enumeration.EnumerationTypeID.Contains('Cust') 

But I get a problem with this request. So please give me some tips on this.

Answer 1

Try this solution:

 from enumeration in db.Enumerations.Where(e => e.EnumerationTypeID.Contains('Cust')) join cust in db.Customers on enumeration.Value equals cust.lkpStatus select enumeration; 

Answer 2

The connection should be as follows:

 var joinQuery = from t1 in Table1 join t2 in Table2 on new { t1.Column1, t1.Column2 } equals new { t2.Column1, t2.Column2 } ... 

Answer 3

This?

 var data = from c in db.Enumerations from d in db.Customers where c.Value.Equals(d.lkpStatus) && c.EnumerationTypeID.Contains('Cust') select c; 

Answer 4

It works

 var data = from c in db.Enumerations from d in db.Customers where c.Value==d.lkpStatus && c.EnumerationTypeID.Contains('Cust') select c;