Click here to Skip to main content
15,886,788 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi friends. What is equivalent LINQ of following T-SQL statement.
these T-sql statement works with Northwind DataBase and Order Table.
SQL
WITH Members AS
          (
              select ROW_NUMBER() OVER (ORDER BY OrderID DESC) as row, OrderDate, OrderId, ShipName, ShipPostalCode
              from  dbo.Orders
          )
        Select row, OrderDate, OrderId, ShipName, ShipPostalCode
        from Members

Thanks.
Posted
Updated 24-Jul-13 1:06am
v2
Comments
ZurdoDev 24-Jul-13 8:10am    
Where are you stuck?
aliwpf 24-Jul-13 8:46am    
i see a wpf example. this example is a Paging control and it has NextItemButton , LastButton etc. in its code behind OrderDataGrid.ItemsSource is populated with T-SQl. i want to convert it to LINQ.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900