How to do a "null-table" select in NHibernate?

Question

In other words how do you do something simple like this:

select 1

Or more specifically in the particular problem I'm dealing with, something like this:

SELECT (case when exists (<subquery>) then 1 else 0 end) AS result

So in short is there a way in NHibernate to do a select without having it generate the "FROM table" clause?

Thanks

Answer 1

You are approaching this problem wrong.

Execute the subquery you are after using a count projection then do the if else logic in code.