I is ok.
I have mistake for class which I would like to use as entity.
W dniu poniedziałek, 27 stycznia 2014 15:46:43 UTC+1 użytkownik Mirosław
Sarna napisał:
>
> 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.
