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: 322
        
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