Linq. Where versus On

[shapper]

Hello,

What is the difference between using:

from a in A
join b in B on a.Name equals b.Name
select a;

and:

from a in A
join b in B where a.Name equals b.Name
select a;

I was using "on" but on this group Jon suggested me the Where example.

Shouldn't I use the "on" in Joins and "where" when I want to impose
some condition to filter items on a condition?

Thanks,
Miguel

[Jon Skeet [C# MVP]]

shapper <md*****@gmail.comwrote:

What is the difference between using:

from a in A
join b in B on a.Name equals b.Name
select a;

and:

from a in A
join b in B where a.Name equals b.Name
select a;

The first is valid, the second isn't.

I was using "on" but on this group Jon suggested me the Where example.

Just a typo in a hastily written post, I'm afraid.

Shouldn't I use the "on" in Joins and "where" when I want to impose
some condition to filter items on a condition?

Yes.

--
Jon Skeet - <sk***@pobox.com>
Web site: http://www.pobox.com/~skeet
Blog: http://www.msmvps.com/jon_skeet
C# in Depth: http://csharpindepth.com