You can use NHibernate Profiler from Hibernating Rhino, or you can configure log4net logging to show NHibernate.SQL, or, depending on the type of application, you can set show_sql = true in your configuration.
On Sun, Jul 18, 2010 at 10:18 PM, alexey_baranov <[email protected]> wrote: > Hi! > > What is the best practice to watch SQL generated by HQL. For example: > > var q= sess.CreateQuery("from Obj o where :path like o.Path + '%' > order by o.Path") > .SetString("path", Current.Path); > > Thanks! > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
