It's certainly possible to get this working using ROW_NUMBER etc. but it wont be db agnostic (and it looked like you wanted that). Instead you could, in most scenarios, simply COUNT how many items come before the item in question, using the query type you prefer.
/G 2011/8/22 Ricardo Peres <[email protected]> > You can have a readonly property in your entity that is the result of > an SQL expression, for example: > > - "ROWNUM" on Oracle > - "ROW_NUMBER() OVER(ORDER BY Id)" on SQL Server > > On Aug 22, 1:43 pm, Evgeniy The Best <[email protected]> wrote: > > May be it's possible somehow to intercept plain SQL query and replace > > part of it while doing .Skip(...) to get just string like SELECT > > ROW_NUMBER() ONTO (...) ORDER BY (...) in MSSQL f.e. ? > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
