Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Definitely use an <code>IHttpModule</code> and implement the <code>BeginRequest</code> and <code>EndRequest</code> events.</p> <p>All of the "raw" data is present between <code>HttpRequest</code> and <code>HttpResponse</code>, it just isn't in a single raw format. Here are the parts needed to build Fiddler-style dumps (about as close to raw HTTP as it gets):</p> <pre><code>request.HttpMethod + " " + request.RawUrl + " " + request.ServerVariables["SERVER_PROTOCOL"] request.Headers // loop through these "key: value" request.InputStream // make sure to reset the Position after reading or later reads may fail </code></pre> <p>For the response:</p> <pre><code>"HTTP/1.1 " + response.Status response.Headers // loop through these "key: value" </code></pre> <p>Note that <strong>you cannot read the response stream</strong> so you have to add a filter to the Output stream and capture a copy.</p> <p>In your <code>BeginRequest</code>, you will need to add a response filter:</p> <pre><code>HttpResponse response = HttpContext.Current.Response; OutputFilterStream filter = new OutputFilterStream(response.Filter); response.Filter = filter; </code></pre> <p>Store <code>filter</code> where you can get to it in the <code>EndRequest</code> handler. I suggest in <code>HttpContext.Items</code>. There can then get the full response data in <code>filter.ReadStream()</code>.</p> <p>Then implement <code>OutputFilterStream</code> using the Decorator pattern as a wrapper around a stream:</p> <pre><code>/// &lt;summary&gt; /// A stream which keeps an in-memory copy as it passes the bytes through /// &lt;/summary&gt; public class OutputFilterStream : Stream { private readonly Stream InnerStream; private readonly MemoryStream CopyStream; public OutputFilterStream(Stream inner) { this.InnerStream = inner; this.CopyStream = new MemoryStream(); } public string ReadStream() { lock (this.InnerStream) { if (this.CopyStream.Length &lt;= 0L || !this.CopyStream.CanRead || !this.CopyStream.CanSeek) { return String.Empty; } long pos = this.CopyStream.Position; this.CopyStream.Position = 0L; try { return new StreamReader(this.CopyStream).ReadToEnd(); } finally { try { this.CopyStream.Position = pos; } catch { } } } } public override bool CanRead { get { return this.InnerStream.CanRead; } } public override bool CanSeek { get { return this.InnerStream.CanSeek; } } public override bool CanWrite { get { return this.InnerStream.CanWrite; } } public override void Flush() { this.InnerStream.Flush(); } public override long Length { get { return this.InnerStream.Length; } } public override long Position { get { return this.InnerStream.Position; } set { this.CopyStream.Position = this.InnerStream.Position = value; } } public override int Read(byte[] buffer, int offset, int count) { return this.InnerStream.Read(buffer, offset, count); } public override long Seek(long offset, SeekOrigin origin) { this.CopyStream.Seek(offset, origin); return this.InnerStream.Seek(offset, origin); } public override void SetLength(long value) { this.CopyStream.SetLength(value); this.InnerStream.SetLength(value); } public override void Write(byte[] buffer, int offset, int count) { this.CopyStream.Write(buffer, offset, count); this.InnerStream.Write(buffer, offset, count); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POLogging raw HTTP request/response in ASP.NET MVC & IIS7
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAndrew Savinykh
    1. USmckamey
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CONice answer. One comment though: you said "There can then get the full response data in filter.ToString()." -don't you mean filter.ReadStream()? (I'm implementing in vb.net not c# but if I run ToString I just get the class name as a string. .ReadStream returns the desired response body.
      singulars
      1. PO
      1. USAdam
    2. COI agree, good answer. I've used it as the basis for a custom logger but have now come across a problem where some headers are missing and most importantly when using IIS compression I can't access the final compressed response. I started a new related question (http://stackoverflow.com/questions/11084459/logging-raw-and-compressed-http-responses-in-asp-net-iis7) for this.
      singulars
      1. PO
      1. USChris
    3. COI think mckamey is a genius. Can you go work for Microsoft so that we just get intelligent solutions instead of needing to have brilliant workarounds?
      singulars
      1. PO
      1. USAbacus
 

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