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...