I have the following statement that I'd like help with in converting from SQL to aps.net (Linq). The script comes from Access 2007 using the Northwind database; it's a stored procedure I think. Thx in advance.
SELECT DISTINCTROW TOP 10 Orders.[Order ID], Orders.[Order Date], [Order Subtotals].Subtotal AS SaleAmount, [Customers Extended].Company AS CompanyName, Orders.[Shipped Date]
FROM [Customers Extended] INNER JOIN (Orders INNER JOIN [Order Subtotals] ON Orders.[Order ID] = [Order Subtotals].[Order ID]) ON [Customers Extended].ID = Orders.[Customer ID]
ORDER BY [Order Subtotals].Subtotal DESC;
SELECT DISTINCTROW TOP 10 Orders.[Order ID], Orders.[Order Date], [Order Subtotals].Subtotal AS SaleAmount, [Customers Extended].Company AS CompanyName, Orders.[Shipped Date]
FROM [Customers Extended] INNER JOIN (Orders INNER JOIN [Order Subtotals] ON Orders.[Order ID] = [Order Subtotals].[Order ID]) ON [Customers Extended].ID = Orders.[Customer ID]
ORDER BY [Order Subtotals].Subtotal DESC;