End of SQL Statement indicator in LINQ Logging

End of SQL Statement indicator in LINQ Logging

Postby crazypit » Thu 01 Jul 2010 08:42

Hello,

It is apparent that a single SQL query/statement is not passed to the Log object in one method call but the DataContext class usually calls the WriteLine method multiple times. This is a major problem for logging/tracing tools because there is not a proper end-of-statement indicator that would help in buffering all the lines of a single SQL statement and properly flushing it.

Some commercial logging tools like Gurock's SmartInspect which is the one i use, depend on the last "Context" line provided by the Microsoft implementation in order to mark the end of statement. Nevetheless, such an indicator is not present in the Devart implementation and there is no way for someone who writes a logging tool to properly acknowledge where a single SQL statement starts and finishes unless he writes a complete SQL parser which of course is unacceptable.

It would be nice if Devart could provide the same end of line entry like the Microsoft implementation for the sake of better compatibility.
crazypit
 
Posts: 163
Joined: Wed 15 Apr 2009 08:43

Postby AndreyR » Thu 01 Jul 2010 13:36

Thank you for the activity. We will investigate the possibility to implement the requested functionality.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Fri 23 Jul 2010 18:07

We have changed the Log format as you requested.
Look forward to the nearest build.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Fri 30 Jul 2010 17:13

The new build of dotConnect for Oracle 5.70.152 is available for download now.
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=18588.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to LinqConnect (LINQ to SQL support)