Rewrite SQL query using Linq to entity

Question

Hi guys I need to rewrite the sql query below using Linq to entity. Unfortunately I don't have a lot of experience of using Linq. Please help me

 With TempTableName AS 
(SELECT [ColumnName],  
        [ColumnName2], 
        [ColumnName3], 
        [ColumnName4], 
 ROW_NUMBER() OVER (order by ColumnName desc) as RowNumber from TableName )
         SELECT 
        [ColumnName],  
        [ColumnName2], 
        [ColumnName3], 
        [ColumnName4]
FROM TempTableName  WHERE ROWNUMBER 
Between 10 and 100

GvS · Accepted Answer · 2010-07-12 13:24:48Z

3

(from t in dbContext.TableName
order by ColumnName descending
select new { ColumnName = t.ColumnName, ColumnName2 = t.ColumnName2 /* ... */  })
.Skip(9)
.Take(91)

If you want to work all the columns from TableName, you can also use select t, this. Probably easier to use, but this will fetch all columns, and it is not clear from your question if that is what you want.

edited Jul 12, 2010 at 13:24

answered Jul 12, 2010 at 13:05

GvS

52.5k16 gold badges104 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Rewrite SQL query using Linq to entity

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related