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].
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.
