Converting a SQL statment into asp.net (Linq)

Joined
Jan 26, 2009
Messages
1
Reaction score
0
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;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,770
Messages
2,569,584
Members
45,075
Latest member
MakersCBDBloodSupport

Latest Threads

Top