Given a criteria, is there an API to generate SQL string ? I would like to do a delete given a criterial. I understand that session has a delete API that I can pass SQL string. But that would force me to construct the SQL in the outer layer.


Thanks

Could you use a criteria search to find the object, and then pass the object to the session's Delete method?

Basically, use the method.

The problem is that

1) each object has to be constructed. Therefore all fields must be mapped.
2) I have to iterate each object.

The above 2 reasons would have some performance hit. If I were to constuct the sql statement, then it would be better.

BTW, I believe I can get the where clause since criteria's ToString return the condition. So, I am trying to find out how to get the table name from the criteria ??


Thanks