Hi,

How can I do this using NHibernate?

1) Begin a transaction
2) Create a User object + save it to the database, BUT don't commit the database transaction.
3) In a SQL query, find User object (using Session.Find method)
4) Do some more work that causes an error
5) Because of error, rollback all work, including User object created in step 2).

Basically, I want to know if it is possible to commit work to DB without commiting the transaction using NHibernate? Does anyone do this sort of thing?

Thanks,

Jon Paugh

Yes, it's possible. ISession.Flush does exactly this, and ISession.Find calls Flush internally to ensure that it retrieves correct results.

very nice thanks.