Reputation: 391
I'm using LLBLGen to access a SQL Express database using LLBLGen runtime framework. Using Visual Studio 2010.
I have created a predicate expression, however It does not seem to be doing what I thought it should, how can I view the Generated SQL sent to the database?
thank you in advance.
Upvotes: 2
Views: 2414
Reputation: 10265
You can enable the build-in tracing, which you can configure like this (the value being the log level threshold):
<system.diagnostics>
<switches>
<add name="SqlServerDQE" value="3" />
<add name="AccessDQE" value="4" />
<add name="OracleDQE" value="4" />
<add name="FirebirdDQE" value="4" />
<add name="MySqlDQE" value="4" />
<add name="DB2DQE" value="4" />
<add name="PostgreSqlDQE" value="4" />
<add name="SybaseAsaDQE" value="4" />
<add name="SybaseAseDQE" value="4" />
<add name="ORMGeneral" value="0" />
<add name="ORMStateManagement" value="0" />
<add name="ORMPersistenceExecution" value="3" />
<add name="LinqExpressionHandler" value="3" />
</switches>
</system.diagnostics>
I can also recommend getting a profiler if you're doing a lot of development/debugging:
http://www.ormprofiler.com/ (by Frans Bouma)
http://llblgenprof.com/ (by Ayende)
Upvotes: 2
Reputation: 28036
For 2.6:
http://www.llblgen.com/documentation/2.6/hh_start.htm
You will want to use the ORMPersistenceExecution switch.
If it's another version, all the docs can be found here:
http://www.llblgen.com/documentation/
Upvotes: 2