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:
[code=sql]
SELECT DISTINCT TOP 10 Orders.OrderID, Orders.OrderDat e, [Order Subtotals].Subtotal AS SaleAmount, Customers.Compa nyName AS CompanyName, Orders.ShippedD ate
FROM Customers INNER JOIN (Orders INNER JOIN [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID) ON Customers.Custo merID = Orders.Customer ID
ORDER BY [Order Subtotals].Subtotal DESC;
[/code]
Here's what I have so far:
Thx in advance.
SQL Script:
[code=sql]
SELECT DISTINCT TOP 10 Orders.OrderID, Orders.OrderDat e, [Order Subtotals].Subtotal AS SaleAmount, Customers.Compa nyName AS CompanyName, Orders.ShippedD ate
FROM Customers INNER JOIN (Orders INNER JOIN [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID) ON Customers.Custo merID = Orders.Customer ID
ORDER BY [Order Subtotals].Subtotal DESC;
[/code]
Here's what I have so far:
Code:
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();