Invantive Estate

To save the SQL statements in a file the following code needs to be part of app.config or web.config:

 

 <system.diagnostics>

   <sources>

     <source name="System.ServiceModel" switchValue="Error">

       <listeners>

         <add name="xmlTrace" />

       </listeners>

     </source>

     <source name="System.ServiceModel.MessageLogging" switchValue="Verbose">

       <listeners>

         <add name="xmlTrace" />

       </listeners>

     </source>

   </sources>

   <sharedListeners>

     <add name="xmlTrace" type="System.Diagnostics.XmlWriterTraceListener" initializeData="C:\temp\client_verbose.svclog" />

   </sharedListeners>

   <trace autoflush="true">

     <listeners>

       <add name="xmlDataTrace" traceOutputOptions="Callstack,DateTime,LogicalOperationStack,ProcessId,ThreadId,Timestamp" type="System.Diagnostics.XmlWriterTraceListener" initializeData="C:\temp\client_data_verbose.svclog" />

     </listeners>

   </trace>

 </system.diagnostics>

 

In the specified file (in this example ‘C: \ temp \ client_verbose.svclog’), the SQL statements will be logged. This file can be read with SvcTraceViewer (can be found in the Windows SDK, but also in the Invantive tools).