'RowNumber using Linq [duplicate]

How to use Linq to execute this sql query?

SELECT ROW_NUMBER() OVER(partition by T.SERRIA_NUMBER order by T.SERRIA_NUMBER),
       T.DATE_REG_END, 
       T.DATE_CHANGE
  FROM ZEM_LIC_UCH T
c++sharpsqllinqentity-framework


Solution 1:[1]

try this:

var query=db.ZEM_LIC_UCH.OrderBy(t=>t.SERRIA_NUMBER)
                        .Select((t,i)=>new
                             {
                               row=i,
                               t.DATE_REG_END, 
                               t.DATE_CHANGE
                             });

Solution 2:[2]

var tmpInt = 1;
var query = from x in db.ZEM_LIC_UCH
            order by x.SERRIA_NUMBER
            select new {
                RowNumber = tmpInt++,
                DATE_REG_END = x.DATE_REG_END,
                DATE_CHANGE = x.DATE_CHANGE
            };

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Tim.Tang
Solution 2 Juan Ruiz de Castilla

Related Questions