Oh, I don't know how it could be =)
Imagine, class foo { Guid Id; string A; string B; int C; }
And f.e. we need get the number of the object with Id = ... where C >
10 and order by A ASC, B DESC
So how you'll do this???
Take a look at Dialect.GetLimitString, I think something we can
extract fromOn 23 авг, 01:47, Gunnar Liljas <[email protected]> wrote: > 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.
