What is difference between Where and Join in linq ?
Posted
by Freshblood
on Stack Overflow
See other posts from Stack Overflow
or by Freshblood
Published on 2010-06-10T09:06:52Z
Indexed on
2010/06/10
9:12 UTC
Read the original article
Hit count: 263
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,UrunAdi=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,UrunAdi=product.Name };
© Stack Overflow or respective owner