How do I document section - see generated SQl

Posts   
 
    
erichar11
User
Posts: 268
Joined: 08-Dec-2003
# Posted on: 21-Mar-2005 00:35:29   

Frans, I was not sure where to put this. But could you add this to the how to section. Right now for adapter, I'm trying to figure out how to do this by looking back at previous post. Have yet to find the exact answer. I belive you added logging functionality for the next release, but having this info I could quickly step through a specific method. Thanks.

P.S. Could you let me what is the best way to do this for adapter?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 21-Mar-2005 09:39:26   

erichar11 wrote:

Frans, I was not sure where to put this. But could you add this to the how to section. Right now for adapter, I'm trying to figure out how to do this by looking back at previous post. Have yet to find the exact answer. I belive you added logging functionality for the next release, but having this info I could quickly step through a specific method. Thanks.

P.S. Could you let me what is the best way to do this for adapter?

The best way in adapter is to derive a class from DataAccessAdapter and override On<action>() and On<action>Complete() methods, which receive an IQuery based object, which contains the query generated.

In 1.0.2004.2, I've added a fine grained tracing framework which allows you to simply add a few lines to the .config file and you'll get the query text delivered to the vs.net output window simple_smile (or to a logfile if you add a trace listener already available to you in the .NET framework).

There is an SqlLogger template available in the 3rd party section too.

Frans Bouma | Lead developer LLBLGen Pro