web api DelegatingHandler question?

Question

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<HttpResponseMessage> 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;
}
}

Raysefo · Answer

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. Motta · Answer

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

Raysefo · Answer

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. Motta · Answer

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; } } } }