Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>We did just that using a <a href="http://msdn.microsoft.com/en-us/library/system.web.services.protocols.soapextension.aspx" rel="nofollow">SoapExtension</a> in the application making the web service requests.</p> <p>The entire system consisted of two classes, a <code>CopyStream</code> class that provided the ability to duplicate the contents of a stream to a second stream as it is read / written to, and a <code>SoapLogger</code> class that intercepts all SOAP requests and responses in the application and logs them to a file.</p> <p>You just need to register it in your app.config file:</p> <pre><code>&lt;configuration&gt; &lt;system.web&gt; &lt;webServices&gt; &lt;soapExtensionTypes&gt; &lt;add type="MyNamespace.SoapLogger, MyAssembly" priority="3" group="High" /&gt; &lt;/soapExtensionTypes&gt; &lt;/webServices&gt; &lt;/system.web&gt; &lt;/configuration&gt; </code></pre> <p>Apologies for the big blob of code, but here it is:</p> <pre><code>/// &lt;summary&gt; /// Extension to allow logging of SOAP request and response xml. /// &lt;/summary&gt; public class SoapLogger : SoapExtension { private MemoryStream copyStream; public override Stream ChainStream(Stream stream) { this.copyStream = new MemoryStream(); return new CopyStream(stream, copyStream); } public override object GetInitializer(Type serviceType) { return null; } public override object GetInitializer(LogicalMethodInfo methodInfo, SoapExtensionAttribute attribute) { return null; } public override void Initialize(object initializer) { } public override void ProcessMessage(SoapMessage message) { switch (message.Stage) { case SoapMessageStage.AfterSerialize: case SoapMessageStage.AfterDeserialize: Log(message); break; } } private void Log(SoapMessage message) { string messageType; if (message.Stage == SoapMessageStage.AfterDeserialize) { messageType = message is SoapServerMessage ? "SoapRequest" : "SoapResponse"; } else { messageType = message is SoapServerMessage ? "SoapResponse" : "SoapRequest"; } StreamReader reader = new StreamReader(new MemoryStream(this.copyStream.ToArray())); Logger.Log(string.Format( "{0} ({1}):\r\n{2}", messageType, message.MethodInfo.Name, reader.ReadToEnd() )); } } /// &lt;summary&gt; /// Implementation of a stream that wraps an existing stream while copying anything written /// or read to another stream. /// &lt;/summary&gt; public class CopyStream : Stream { public Stream BaseStream { get { return this.baseStream; } } private Stream baseStream; public Stream OtherStream { get { return this.otherStream; } } private Stream otherStream; public CopyStream(Stream BaseStream, Stream OtherStream) { if (BaseStream == null) { throw new ArgumentNullException("BaseStream"); } if (OtherStream == null) { throw new ArgumentNullException("OtherStream"); } this.baseStream = BaseStream; this.otherStream = OtherStream; } public override bool CanRead { get { return this.BaseStream.CanRead; } } public override bool CanSeek { get { return this.BaseStream.CanSeek; } } public override bool CanWrite { get { return this.BaseStream.CanWrite; } } public override void Flush() { this.BaseStream.Flush(); } public override long Length { get { return this.BaseStream.Length; } } public override long Position { get { return this.BaseStream.Position; } set { this.BaseStream.Position = value; } } public override int Read(byte[] buffer, int offset, int count) { int returnValue = BaseStream.Read(buffer, offset, count); this.otherStream.Write(buffer, offset, returnValue); return returnValue; } public override long Seek(long offset, SeekOrigin origin) { try { this.OtherStream.Seek(offset, origin); } catch { } return BaseStream.Seek(offset, origin); } public override void SetLength(long value) { try { this.OtherStream.SetLength(value); } catch { } this.BaseStream.SetLength(value); } public override void Write(byte[] buffer, int offset, int count) { try { this.OtherStream.Write(buffer, offset, count); } catch { } this.BaseStream.Write(buffer, offset, count); } } </code></pre> <p>Its not been performance / stress tested, but it seems to be holding up just fine - <em>hopefully</em> the way that the stream copying is done should mitigate any performance impact.</p>
    singulars
    1. This table or related slice is empty.
    1. POLogging for C# Webservices
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJustin
    1. USJustin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POLogging for C# Webservices
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COSoapLogger class will be at client end from where web service will be called or does it stay at server end.if possible please clarify
      singulars
      1. PO
      1. USThomas
    2. CO@Thomas This is in the application making the web service requests (i.e. the client) I've added a note to the question to clarify this.
      singulars
      1. PO
      1. USJustin
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload