SQL Query Converting select-from-join to LinQ

Question

I'm working on 'NorthWind' database and I want to convert my SQL codes to LinQ.

Here my codes:

select s.CompanyName,o.OrderID, o.Freight 
from Orders as o 
join Shippers as s on o.ShipVia = s.ShipperID

Sergey Berezovskiy · Accepted Answer · 2013-02-27 11:50:15Z

2

var query = from o in db.Orders
            join s in db.Shippers on o.ShipVia equals s.ShipperID
            select new {
               o.OrderID,
               o.Freight,
               s.CompanyName
            };

I suggest you to use LINQ Pad for learning LINQ and testing your queries.

answered Feb 27, 2013 at 11:50

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

Collectives™ on Stack Overflow

SQL Query Converting select-from-join to LinQ

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related