I use log4net to log *NHibernate.SQL* at the *Debug *level. I use the MsSql2012Dialect dialect against the latest Sql Server database. The logged SQL is s bit different from the SQL that gets sent to the DB. Notably, for bit fields that are mapped a *Boolean*, NH produces values of *1* and *0*, but the logging output uses *True *and *False*. Also, today's DateTime gets sent to the DB as* '2023-06-16 08:32:09.9586347'* but gets logged as *2023-06-16T08:32:09.9586347Z* (different format, *sans *quotes). This is inconvenient because I can't simply paste a query from the log into a database client and run it; I first have to replace the Boolean and DateTime literals so that it will run.
Can someone explain why this is happening and/or suggest a solution? PS: I've written a log4net PatternLayout that gets rid of the parameters (as in @p1, @p2) and puts their values inline, making the SQL more readable. I'm happy to share it if anyone's interested. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/nhusers/db694c99-d2a8-4784-8b3c-f2afea5b3c3fn%40googlegroups.com.
