Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I believe the correct answer is Kaliatech's and I would have left this as a comment and voted his up is I had enough reputation points, since I think his is basically correct. </p> <p>However, my situation called for the need to look at the encoding type type rather than the content type. Using this approach the calling system can still specify that the content type is json/xml/etc in the content type, but specify that the data is encoded using gzip or potentially another encoding/compression mechanism. This prevented me from needing to change the content type after decoding the input and allows any content type information to flow through in its original state.</p> <p>Here's the code. Again, 99% of this is Kaliatech's answer including the comments, so please vote his post up if this is useful.</p> <pre><code>public class CompressedRequestHandler : DelegatingHandler { protected override System.Threading.Tasks.Task&lt;HttpResponseMessage&gt; SendAsync(HttpRequestMessage request, System.Threading.CancellationToken cancellationToken) { if (IsRequetCompressed(request)) { request.Content = DecompressRequestContent(request); } return base.SendAsync(request, cancellationToken); } private bool IsRequetCompressed(HttpRequestMessage request) { if (request.Content.Headers.ContentEncoding != null &amp;&amp; request.Content.Headers.ContentEncoding.Contains("gzip")) { return true; } return false; } private HttpContent DecompressRequestContent(HttpRequestMessage request) { // Read in the input stream, then decompress in to the outputstream. // Doing this asynronously, but not really required at this point // since we end up waiting on it right after this. Stream outputStream = new MemoryStream(); Task task = request.Content.ReadAsStreamAsync().ContinueWith(t =&gt; { Stream inputStream = t.Result; var gzipStream = new GZipStream(inputStream, CompressionMode.Decompress); gzipStream.CopyTo(outputStream); gzipStream.Dispose(); outputStream.Seek(0, SeekOrigin.Begin); }); // Wait for inputstream and decompression to complete. Would be nice // to not block here and work async when ready instead, but I couldn't // figure out how to do it in context of a DelegatingHandler. task.Wait(); // Save the original content HttpContent origContent = request.Content; // Replace request content with the newly decompressed stream HttpContent newContent = new StreamContent(outputStream); // Copy all headers from original content in to new one foreach (var header in origContent.Headers) { newContent.Headers.Add(header.Key, header.Value); } return newContent; } </code></pre> <p>I then registered this handler globally, which could be a dicey proposition if you are vulnerable to DoS attacks, but our service is locked down, so it works for us</p> <pre><code>GlobalConfiguration.Configuration.MessageHandlers.Add(new CompressedRequestHandler()); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow do enable a .Net web-API to accept g-ziped posts
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USphasselbach
    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
    1. This table or related slice is empty.
 

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