Therefore I spent the last few weekends writing a small utility to do that. You only need to add reference to the DLL and run your .NET app, it will output the query in the Profiler similar to how it's done in NHibernate Profiler.
I appreciate any feedback and suggestion. Thanks.