Criteria API + SQL

[mynkow]

Hi,

I want to add a specific SQL to 1 query which will work only on MSSQL. How to do that:

Criteria:

                 Session
                    .CreateCriteria<User>()
                    .Add(Expression.Sql("TABLESAMPLE (100 PERCENT)"))
                    .SetMaxResults(count)
                    .List<User>();

Generated SQL:

SELECT

TOP (6)

 this_.user_id

FROM users this_

WHERE TABLESAMPLE (100 PERCENT)

EXPECTED SQL:

SELECT

 TOP (6)

  this_.user_id

FROM users this_

TABLESAMPLE (100 PERCENT)

The WHERE keyword should no exist. How to do that without using raw sql for the whole query?

10x