web api DelegatingHandler question?

Raysefo

7y1.9k

Hello,

I wonder how to insert request/response JSON messages into database in delegatinghandler?

any help would be great.

public class LogRequestAndResponseHandler : DelegatingHandler
{
protected override async Task SendAsync(
HttpRequestMessage request, CancellationToken cancellationToken)
{
// log request body
string requestBody = await request.Content.ReadAsStringAsync();
Trace.WriteLine(requestBody);
// let other handlers process the request
var result = await base.SendAsync(request, cancellationToken);
if (result.Content != null)
{
// once response body is ready, log it
var responseBody = await result.Content.ReadAsStringAsync();
Trace.WriteLine(responseBody);
}
return result;
}
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raysefo7y ago
Hi,
Actually it is not another thing. I wanna know if I can somehow use entity framework or DAL in DelegatingHandler in order to insert requests/responses.
Jefferson S. Motta7y ago
Please, mark my answer as ok.

Now you want another thing, you must open another question.

But, may you Googling will find some samples:

https://www.google.com/search?q=entity+framework+and+DAL&oq=entity+framework+and+DAL&aqs=chrome..69i57.149259031j0j7&sourceid=chrome&ie=UTF-8
Raysefo7y ago
Hi Jefferson,

Thanks for your reply. I would be glad if you can show me via entity framework and DAL. Any tutorial would be great. I am currently researching repository pattern, trying to figure it out.

Best Regards.
Jefferson S. Motta7y ago
RaySefo, this is any help:
using System;

public class Class1
{
    public Class1()
    {

    public class LogRequestAndResponseHandler : DelegatingHandler
    {
        protected override async Task SendAsync(
            HttpRequestMessage request, CancellationToken cancellationToken)
        {
            // log request body
            string requestBody = await request.Content.ReadAsStringAsync();
            Trace.WriteLine(requestBody);

            // OPEN DATABASE WITH ASYNC OPERATION
            // INSERT/READ AS YOU WISH

            // https://www.infoworld.com/article/2902406/application-development/asynchronous-operations-in-ado-net.html
            using (var connection = new SqlConnection(connectionString)
            {
                await connection.OpenAsync();

            }

        // let other handlers process the request
        var result = await base.SendAsync(request, cancellationToken);

            if (result.Content != null)
            {
                // once response body is ready, log it
                var responseBody = await result.Content.ReadAsStringAsync();

                // OPEN DATABASE WITH ASYNC OPERATION
                // INSERT/READ AS YOU WISH

                Trace.WriteLine(responseBody);
            }

            return result;
        }
    }

}
}