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 :-(.
W dniu poniedziałek, 27 stycznia 2014 16:12:03 UTC+1 użytkownik Oskar
Berggren napisał:
>
> 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 <[email protected] <javascript:>>
>
>> 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
>>
>>
>>
>>
>> --
>> 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 [email protected] <javascript:>.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> Visit this group at http://groups.google.com/group/nhusers.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/groups/opt_out.
