How to know query generated by Fluent NHibernate

sql nhibernate logging output
Rahul Somwanshi picture Rahul Somwanshi · May 4, 2009 · Viewed 24k times · Source

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?

Answer

Kevin Berridge picture Kevin Berridge · May 22, 2009

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.

Related questions

How can I have NHibernate only generate the SQL without executing it?

I know how to log the SQL to log4net/NLog/trace window at runtime with the show_sql configuration option. What I'm looking for is a way to give a Query<T>() to NHibernate retrieve the generated …

Read More
Use OR Clause in queryover in NHibernate

I am using Nhibernate. I am writing query through queryover method. I am able to write and clause as in code below. Its working fine. db.QueryOver(Of Users)() .Where(Function(x) x.Role = "Guest") .And(Function(x) x.Block = 0) .…

Read More
SQL Union to NHibernate Criteria

There's a way to convert this SQL statement to a NHibernate Criteria? (select b1.FieldA as Name, b1.FieldA as FullName from Sale b1 where b1.FieldA like '%john%' or b1.FieldA like '%john%' order by …

Read More