Problem with loging generated SQL query from LINQ

[Mirosław Sarna]

Hi,

My general question:

Could I see in log sql query which was generated by LINQ?

I have ling query:

var q = (from u in s.Query<AppUser>()

                                 where u.Name.EndsWith("AlaMoKota")

                                 select u).ToList();

I have option show_sql = true

but I can find only this information in app log :

2014-01-27 15:28:42.0080 - 8/Domain-BB.AppCore.DbCommon.Tests.dll - NHibernate.Impl.SessionImpl - [session-id=31b3874b-dfaf-4fdf-81ab-91cfae013099] opened session at timestamp: 635264333220, for session factory: [/8987a802c98d4e68ac775f035e524e81] 

2014-01-27 15:28:42.0236 - 8/Domain-BB.AppCore.DbCommon.Tests.dll - NHibernate.Impl.SessionImpl - setting cache mode to: Ignore 

2014-01-27 15:28:42.0547 - 8/Domain-BB.AppCore.DbCommon.Tests.dll - NHibernate.Linq - Expression (partially evaluated): value(NHibernate.Linq.NhQueryable`1[ModelAV1.AppUser]).Where(u => u.Name.EndsWith("AlaMoKota")) 

2014-01-27 15:28:42.0720 - 8/Domain-BB.AppCore.DbCommon.Tests.dll - NHibernate.Engine.Query.QueryPlanCache - unable to locate HQL query plan in cache; generating (.Where[ModelAV1.AppUser](NHibernate.Linq.NhQueryable`1[ModelAV1.AppUser], Quote((u, ) => (u.Name.EndsWith(p1, ))), )) 

2014-01-27 15:28:42.4867 - 8/Domain-BB.AppCore.DbCommon.Tests.dll - NHibernate.Engine.Query.QueryPlanCache - located HQL query plan in cache (.Where[ModelAV1.AppUser](NHibernate.Linq.NhQueryable`1[ModelAV1.AppUser], Quote((u, ) => (u.Name.EndsWith(p1, ))), )) 

2014-01-27 15:28:42.4867 - 8/Domain-BB.AppCore.DbCommon.Tests.dll - NHibernate.Engine.Query.HQLQueryPlan - find: .Where[ModelAV1.AppUser](NHibernate.Linq.NhQueryable`1[ModelAV1.AppUser], Quote((u, ) => (u.Name.EndsWith(p1, ))), ) 

2014-01-27 15:28:42.4867 - 8/Domain-BB.AppCore.DbCommon.Tests.dll - NHibernate.Engine.QueryParameters - named parameters: {} 

2014-01-27 15:28:42.4867 - 8/Domain-BB.AppCore.DbCommon.Tests.dll - NHibernate.AdoNet.ConnectionManager - after autocommit 

2014-01-27 15:28:42.4867 - 8/Domain-BB.AppCore.DbCommon.Tests.dll - NHibernate.Impl.SessionImpl - transaction completion 

I can't find information about with SQL.

But in other places I could find e.g.:

2014-01-27 15:28:41.3848 - 8/Domain-BB.AppCore.DbCommon.Tests.dll - NHibernate.SQL - -- Void BB.AppCore.DbCommon.Tests.TestsForDbCommon.T_InitializeSession() [File=TestsForDbCommon.cs, Line=61]

--- BB.AppCore.DbCommon.BBSessionManager BB.AppCore.UnitTestCommon.TestTools.CreateSession(System.String[], InitDatabaseSettings) [File=TestTools.cs, Line=129]

---- Void BB.AppCore.DbCommon.BBSessionManager.PrepareStructure() [File=BBSessionManager.cs, Line=332]

----- BB.AppCore.DbCommon.StructureVersionStatus BB.AppCore.DbCommon.BBSessionManager.DoUpgrade() [File=BBSessionManager.cs, Line=514]

------ Void BB.AppCore.DbCommon.BBSessionManager.SaveVersionInfoInDB(BB.AppCore.DbCommon.MappAtr.IDbModuleInfo) [File=BBSessionManager.cs, Line=565]

------- Void BB.AppCore.DbCommon.Logging.NLogLogger.Debug(System.Object) [File=NLogFactory.cs, Line=163]

-------- System.String BB.AppCore.DbCommon.Logging.NLogLogger.msgConverter(System.String) [File=NLogFactory.cs, Line=108]

----------------------------

Batch commands:

    UPDATE

        ACDC_DB_MODULE_VERSION 

    SET

        DB_MODULE_ID = 2 

    WHERE

        ID = 2;

    @p0 = 2 [Type: Int32 (0)], @p1 = 2 [Type: Int32 (0)]

For HQL is also working:

2014-01-27 15:28:40.2811 - 8/Domain-BB.AppCore.DbCommon.Tests.dll - NHibernate.Hql.Ast.ANTLR.HqlSqlGenerator - SQL: select max(dbmoduleve0_.VERSION) as col_0_0_ from ACDC_DB_MODULE_VERSION dbmoduleve0_ where dbmoduleve0_.MODULE_NA

[Oskar Berggren]

SQL corresponding to LINQ-queries are logged from the NHibernate.SQL logger using the DEBUG priority level. They should also be visible from the NHibernate.Loader.Loader logger, with priority level INFO (in this case without parameter values).

This is independent of the show_sql setting, which only affects logging of SQL statements to the console.

/Oskar

2014-01-27 Mirosław Sarna <mirosla...@gmail.com>

--
You received this message because you are subscribed to the Google Groups "nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nhusers+u...@googlegroups.com.
To post to this group, send email to nhu...@googlegroups.com.
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/groups/opt_out.

[Mirosław Sarna]

I have used (NLog)

  <logger name="*" minlevel="Trace" writeTo="file,console"/>

I have tried: 

    <logger name="NHibernate.SQL" minlevel="Trace" writeTo="file,console"/>

    <logger name="NHibernate.Linq" minlevel="Trace" writeTo="file,console"/>

    <logger name="NHibernate.Hql.Ast.ANTLR.HqlParseEngine" minlevel="Trace" writeTo="file,console"/>

    <logger name="NHibernate.Hql.Ast.ANTLR.HqlSqlGenerator" minlevel="Trace" writeTo="file,console"/>

    <logger name="NHibernate.Engine.Query.HQLQueryPlan" minlevel="Trace" writeTo="file,console"/>

    <logger name="NHibernate.Engine.QueryParameters" minlevel="Trace" writeTo="file,console"/>

    <logger name="NHibernate.Loader.Loader" minlevel="Trace" writeTo="file,console"/>

but I could not see sql generated from linq :-(.

[Mirosław Sarna]

I is ok.

I have mistake for class which I would like to use as entity.