linq - how combine conditions in a join statement

Question

im working with xml and linq.

I have 2 xml files both contain "ID" and "LANGUAGE"

I want to do a join based on where the both the ID and LANGUAGE are equal in both files I have something like this:

var data= 
from details in h_details.Descendants("ROW")

join inst in instance.XPathSelectElements("//Row")
on details.Element("ID").Value
equals inst.XPathSelectElement("Field[@Name=\'h_id\']").Value
and on details.Element("LANGUAGE").Value
equals inst.XPathSelectElement("Field[@Name=\'h_lang\']").Value

basically the "and" statement wont work, so how do i join based on 2 conditions?

This looks like a duplicate of http://stackoverflow.com/questions/373541/how-to-do-joins-in-linq-on-multiple-fields-in-single-join — dariom, Jul 09 '09 at 09:57

score 2 · Accepted Answer · answered Jul 09 '09 at 15:54

Anonymous types to the rescue.

var data=
  from details in h_details.Descendants("ROW")
  join inst in instance.XPathSelectElements("//Row")
  on new {
    x = details.Element("ID").Value,
    y = details.Element("LANGUAGE").Value
  } equals new {
    x = inst.XPathSelectElement("Field[@Name=\'h_id\']").Value,
    y = inst.XPathSelectElement("Field[@Name=\'h_lang\']").Value
  }
  select ... ;

score 0 · Answer 2 · answered Jul 09 '09 at 09:48

0

try union to get the both lists and join them

answered Jul 09 '09 at 09:48

chugh97

9,274
25
83
134

linq - how combine conditions in a join statement

2 Answers2