LINQ join with multiple conditions of different kind

Question

I'm trying to translate following T-SQL query into LINQ:

SELECT * FROM table_A JOIN table_B ON table_A.key = table_B.key AND table_A.Trouble <> table_B.Trouble

Stackoverflow is full with similar questions, but in my case there are two conditions but each of them has different operator ("equals to" and "not equals to"). Is there any way to get the same result using LINQ?

Linq to SQL / LINQ to entities ?

Habib
– Habib

2015-07-03 15:41:52 +00:00
Commented Jul 3, 2015 at 15:41 — Habib
– Habib, Commented Jul 3, 2015 at 15:41
See: stackoverflow.com/questions/10642421/…

Habib
– Habib

2015-07-03 15:44:04 +00:00
Commented Jul 3, 2015 at 15:44 — Habib
– Habib, Commented Jul 3, 2015 at 15:44

Aducci · Accepted Answer · 2015-07-03 15:55:15Z

3

You can't use the join syntax, you have to use a where clause to connect the two

var query = from a in table_A from b in table_B where a.key = b.key && a.Trouble != b.Trouble select new { a, b };

edited Jul 3, 2015 at 15:55

answered Jul 3, 2015 at 15:45

Aducci

26.8k8 gold badges67 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dzienny Over a year ago

I think it doesn't compile in C# <> ;)

Mukesh Kalgude · Accepted Answer · 2015-07-03 17:42:07Z

You can also write this query. It should be work fast

var query = from a in table_A from b in table_B.where(x=>x.key==a.key && x.Trouble != a.Trouble) select new { a, b };

Collectives™ on Stack Overflow

LINQ join with multiple conditions of different kind

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related