Saturday, 17 August 2013

LINQ equivalent of a join query;

LINQ equivalent of a join query;

Normally in t-sql if i use:
SELECT *
FROM Orders
INNER JOIN Customers
ON Orders.CustomerID=Customers.CustomerID;
it returns all columns of all tables,how can i achieve that in linq?
Tried:
var query = from siparis in db.Siparis
join kazan in db.Kazan on siparis.ID equals
kazan.Siparis_ID into Joined
select Joined;
But it only returns me objects,not everything.

No comments:

Post a Comment