How to know query generated by Fluent NHibernate

Question

I am using linq to Nhibernate to fire some select query to data base.

My question is, how do I know, the query generated by Fluent NHibernate?

Fluent NHibernate **does not** generate any queries. It's NHibernate that generates them. — Mauricio Scheffer, Jun 17 '10 at 15:24
I think this question might help you: http://stackoverflow.com/questions/474659/how-to-log-sql-calls-with-nhibernate-to-the-console-of-visual-studio — HerbalMart, Nov 14 '12 at 16:24

score 37 · Answer 1 · edited Mar 09 '16 at 09:21

37

With Fluent NHibernate, you can turn on show_sql like this:

Fluently.Configure()
    .Database( MsSqlConfiguration.MsSql2005.ShowSql().ConnectionString(...) )...

NHibernate will now print every sql statement to Console.Out.

edited Mar 09 '16 at 09:21

Jeroen

60,696
40
206
339

answered May 22 '09 at 12:09

Kevin Berridge

6,251
6
41
42

1

Hi Kevin, Thanks for posting this! I'm wondering if you've also hooked up Log4Net so it sends the generated SQL to a file? – 5x1llz Jun 06 '09 at 02:04
14

This is so frustrating. Any idea why this would ever not work? I'm looking through my Console and it's just not there. – Milimetric Jun 14 '11 at 22:26

Joey V. · Accepted Answer · 2009-10-07T15:23:20.303

6

If you want the SQL to be in log4net, make sure you set the logger in your configuration section.

I put the NHibernate package at "INFO" to reduce the noise and the NHibernate.SQL to all so I can log all SQL statements.

  
 <logger name="NHibernate">
   <level value="INFO" />
 </logger>


  <logger name="NHibernate.SQL">
    <level value="ALL" />
  </logger>

edited Oct 07 '09 at 15:23

answered Oct 07 '09 at 15:16

Joey V.

1,866
1
22
18

Jugal Panchal · Answer 3 · 2016-09-14T15:06:21.003

I have found 4 options to know sql query in nhibernate and fluent nhibernate.

Log - Joey V. said in answer of this same question.
ShowSql - Kevin Berridge said in answer of this same question.
NHProf - This is a awesome profiler. NHProf

Intercepter - It is really good to see sql. we can put it in our Output of Visual Studio and even in log file.

ISessionFactory sf = Fluently.Configure()
        .Database(MySQLConfiguration.Standard.ConnectionString(ConnectionString).ShowSql())
        .Mappings(m => m.FluentMappings.AddFromAssemblyOf<Stock>())
        .ExposeConfiguration(c => c.SetInterceptor(new ABCInterceptor()))
        .BuildSessionFactory();


public class ABCInterceptor : EmptyInterceptor
{
    public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
    {
       Trace.WriteLine(sql.ToString());
       return sql;
    }
 }

score 6 · Answer 4 · answered May 22 '09 at 13:49

6

You might also find this useful http://nhprof.com/

answered May 22 '09 at 13:49

Chris Canal

4,824
9
35
45

Whilst this may theoretically answer the question, [it would be preferable](//meta.stackoverflow.com/q/8259) to include the essential parts of the answer here, and provide the link for reference. – Mat Nov 07 '18 at 08:33

score 2 · Answer 5 · answered May 04 '09 at 06:56

2

See this. What you need is hibernate.show_sql.

answered May 04 '09 at 06:56

Anton Gogolev

113,561
39
200
288

7

How do you configure that with Fluent NHibernate? – Kevin Berridge May 22 '09 at 11:57

score 0 · Answer 6 · answered Oct 16 '09 at 06:11

0

Definitely buy and use NHProf. This is an awesome product and not only shows you what queries are being run, but also shows you any potential performance problems with your NHibernate mappings and queries.

answered Oct 16 '09 at 06:11

Deeksy

5,304
2
23
27

score 0 · Answer 7 · answered May 22 '09 at 13:51

0

You can use sql profilers like this one too.

answered May 22 '09 at 13:51

Arnis Lapsa

45,880
29
115
195

score -1 · Answer 8 · answered May 22 '09 at 18:46

-1

You can also hook in log4net.

answered May 22 '09 at 18:46

Paco

8,335
3
30
41

How to know query generated by Fluent NHibernate

8 Answers8

Linked