I want to read sql query from nhibernate.
i'm using Icriteria ("criteria.List<IEntity>();") to get Data from a table.

how will i get sql query that nhibernate generates ?
how will i get insert, update and delete SQL statement from nhibernate?

Thanks in advance..

Set "hibernate.show_sql" to "true" in your configuration properties e.g.

or configure log4net to show "Debug" level warnings for the NHibernate.SQL logger.

Thanks for ur reply.

Yes i've done this


<nhibernate>
<add
key="hibernate.show_sql"
value="true" />


but i'm using following code


ICriteria criteria=m_session.CreateCriteria(type);
dataSource = criteria.List<IEntity>();

for save:
tx = m_session.BeginTransaction();
m_session.Save(item);
tx.Commit();


i'm getting the data from this but i want to use sqlquery after this code.
i want to save geenrated sql query in database also.
so how will i get sqlquery in a string?

Thanks..!