I have an xmldatatype column(name: xmlColumn) in tbCustomer Tabel. now I
want to retrive in xmlColumn where /Address/street/No/text() in (1, 2,
3)
I can write it in SQL
- where xmlColumn.value('(/Address/street/No/text())[1]', 'INT') IN (1, 2, 3) // It works fine in sql editor
I wanted to include the above conditon in the following LINQ expression:
- var dataSource = from c in tbCustomer
- join o in tbOrder on c.custID = o.custid
- select new
- { c.custID,
- c.custtname,
- o.ordername
- }