How to log all the request to the sql server database?

Question

I'm working on some code that hit the database several times through NHibernate. I'd like to see how I can write a procedure.

To ease my work, this is what I want:

I'd like to log information from the prospective of the DB. I tried before to follow all the codes that make request to the database.

Thank for helping

In addition to these excellent suggestions, you can also configure nhibernate to emit the sql to the console or configure log4net to emit NHibernate.SQL to a text file or database — Darren Kopp, Commented Dec 5, 2013 at 19:21
I believe that what you seek is here stackoverflow.com/questions/474659/… stackoverflow.com/questions/819040/… — Paulo Lima, Commented Dec 13, 2013 at 16:30

jean · Accepted Answer · 2013-12-05 19:22:12Z

0

If you want to work with nhibernate I suggest you to give Rhino a try.

answered Dec 5, 2013 at 19:22

jean

4,3244 gold badges32 silver badges53 bronze badges

Any reason why this was downvoted? I love SqlServer Profiler but for nHibernate I found Rhino better as it helps with code analysis.
– jean
Commented Dec 6, 2013 at 19:27

Add a comment |

1 Answer 1