What is difference between Where and Join in linq ?

Question

hello

What is difference between of these 2 queries ? they are completely equal ?

from order in myDB.OrdersSet
    from person in myDB.PersonSet
    from product in myDB.ProductSet
    where order.Persons_Id==person.Id && order.Products_Id==product.Id
    select new { order.Id, person.Name, person.SurName,  product.Model,UrunAdı=product.Name };

and

from order in myDB.OrdersSet
    join person in myDB.PersonSet on order.Persons_Id equals person.Id
    join product in myDB.ProductSet on order.Products_Id equals product.Id
    select new { order.Id, person.Name, person.SurName,  product.Model,UrunAdı=product.Name };

Answer 1

The end result should be the same.

But using JOIN is clearer - it's more obvious what you're doing (joining three sets of data).

My personal "best practice" approach would be:

• use WHERE to reduce and limit the number of rows returned - it's typically limiting one set of data (by defining some criteria to be met)

• use JOIN to express the intent of joining two tables / sets of data together on a common field (or set of fields)

Answer 2

Join shows the relationship between table clearer and also in less keystrokes.