I have the following SQL script that I'd like to convert into ASP.Net (LINQ) code. I figure out part of the solution but I need help with the rest.
SQL Script:
-
SELECT DISTINCT TOP 10 Orders.OrderID, Orders.OrderDate, [Order Subtotals].Subtotal AS SaleAmount, Customers.CompanyName AS CompanyName, Orders.ShippedDate
-
-
FROM Customers INNER JOIN (Orders INNER JOIN [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID) ON Customers.CustomerID = Orders.CustomerID
-
-
ORDER BY [Order Subtotals].Subtotal DESC;
-
Here's what I have so far:
-
var expr = ((from o in db.Orders
-
join c in db.Customers on o.CustomerID equals c.CustomerID
-
select new { o.OrderID, o.OrderDate, SalesAmount = o.OrderID, c.CompanyName, o.ShippedDate }).Take(10)).Distinct();
-
Thx in advance.
