Hi,

For debugging and comparison purposes our users would like to validate some of the Linq queries (which we dynamically generated based on their input in the UI) again the SQL server manually. Now we use SQL Monitor / Profiler for this purpose but that's quite cumbersome. Is there a way to get the actual queries during runtime using code so we can output them with the results to (in our case) the output file.

Thanks.

Enable (configure) tracing, and use a trace listener.

Please check this thread for more details. http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=21424

(please reply back here).

Or the documentation: http://www.llblgen.com/Documentation/5.0/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/gencode_troubleshootingdebugging.htm#dynamic-query-engine-tracing

Thanks! Got the data that I needed with that information.