I was wondering if it's possible to get the SQL that a Creteria would generate when executed?

I have some DAO objects where it's possible to set up some criteria filters and get the list of objects that meets those criteria's, but in some senarios I would like to just obtain the SQL that those criteria would have generated in order to use this as a subselect in another custum SQL. I just can't seem to find a way to get hold of the SQL that would be generated.

So the question basically is, am I missing something or is this just not possible?

I looked into doing this in order to take advantage of the SQL Cache invalidation in ASP.NET 2.0. You could go in and create and event that gets fired after the sql is constructed and pass it thru the event args, bubbling up to the handler for your other method. I think it is in one of the Loader classes but cant remember for sure.