TraceSwitch output formatting for DateTime milliseconds

Posts   
 
    
jovball
User
Posts: 443
Joined: 23-Jan-2005
# Posted on: 09-Jul-2011 07:01:28   

Some of the key fields in our database are datetime with sub-second precision.

I use the diagnostics trace switches to see the queries that are generated by the DQE. I would like to be able to see the full precision of the date time parameters rather than the US long date format. Is there any way for me to do this?

Also, I'd like to cast a vote for you adding stored procedure tracing in a future version. (http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=19636).

It's always helpful to be able to verify that the correct call is being sent to the database server.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 11-Jul-2011 00:25:41   

Hi Joel,

You can override some methods on DataAccessAdapter to add tracing info. Here is an example about that.

I'm attaching a class you can add to your DBSpecific project to see your datetime in custom format in tracing. To add SP tracing you can do similar as stayed in the thread you posted.

Attachments
Filename File size Added on Approval
DataAccessAdapterTraceExtended.cs 4,745 11-Jul-2011 00:26.01 Approved
David Elizondo | LLBLGen Support Team