RowNumber() doesn't work properly in where clause

[Puchaczov]

the best description for this issue is how SQL code is transpiled to C# equivalent. Currently it is

for(....){
   queryStats.rowNumber+=1;
   if (...)
       ...
   ....
}

before changes it was

for (....){
 if(....)
    .....
 queryStats.rowNumber +=1;
}

which is also wrong. I think it should be mixed to have amended rowNumber either in if(...){...} clause and before for clause ends.