How would I perform an ExecuteScalar() style function? I know it seems like a simple request, but I cant seem to find out how to do it anywhere.

Also, is there a way to simply check to see whether a record exists in the database? The only catch is I dont want to pass the ID identity column. I want to check to see if a record exists by checking a column that isnt the primary key.

For example, pass a string to check if a certain username exists, in a table where there is a column called ID that is the identity and primary key.

(In simple ado.net, I used an ExecuteScalar() and if it didnt return anything, I returned false, and if it did return a record, i returned true. fairly simple. jut wondering if there is a way to do this simply in nHibernate?)

Thanks!

You need to take a look at the 'scalar queries' at the docs:
http://nhibernate.sourceforge.net/h2.0.3-docs/reference/html/manipulating-data.html#manipulating-data-s4

The first tip at 'tips&tricks' may apply also:
http://nhibernate.sourceforge.net/h2.0.3-docs/reference/html/query-language.html#query-language-s11

hth

Do

or

(to be able to directly use the ID to load the user :) )

Just one more question though. I put this into a session.Find()? or session.Query()?

Im a newbie at nhibernate...

Thanks for the help!