Retrieve the generated SQL or QueryExecuted

Posts   
 
    
Kris Nobels avatar
Posts: 118
Joined: 02-Apr-2008
# Posted on: 25-Dec-2009 19:26:38   

Hello,

I would like to know if there is a way to see what llblgen generated code looks like during the ORMQueryExecution ?

For example I have this entity and I created my filter for it.

I would like to see:

select field a, field b from logging where date > your value.

But when you have an error in your sql syntax you can see the QueryExecuted. simple_smile wonderful

Is it possible however to log the query that is executed each time ?

This is only required in debug or development mode.

thanks

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 26-Dec-2009 04:56:50   

You should use the Generated Sql and then you could configure a trace listener. Here is a related thread about that: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5832

You also could use an external sql tracing application.

David Elizondo | LLBLGen Support Team