LINQ question (JOINs related)

[nabeelisnabeel]

Hi

I am having trouble converting a query that contains AND operator in JOIN into LINQ. For example, our sample query is


SELECT
e.name, a.city
FROM
Emp e INNER JOIN Address a ON e.id = a.emp_id AND e.country = a.country
WHERE
e.prof = 'doctor'


The main thing that is confusing me how to deal with the last AND clause.

[cilu]

Try this:

var query =
from e in Emp
join a in Address on new {f1 = e.id, f2 = e.country} equals new {f1 = a.emp_id, f2 = a.country} into temp
from t in temp.DefaultIfEmpty()
where t.prof = "doctor"
select new {t.name, t.city};

[nabeelisnabeel]

Try this:

var query =
from e in Emp
join a in Address on new {f1 = e.id, f2 = e.country} equals new {f1 = a.emp_id, f2 = a.country} into temp
from t in temp.DefaultIfEmpty()
where t.prof = "doctor"
select new {t.name, t.city};


I think that you converted it into LEFT OUTER JOIN. will try it shortly