Dapper logging when using connection from EF Core DbContext

Question

I have a legacy code that is using dapper's QueryAsync() on DbContext's dbconnection:

var connection = _context.GetConnection();
await connection.QueryAsync<Guid>(query, parameters);

How do I enable logging? Ideally I would like also SQL Dependencies to be logged as well (ApplicationInsights).

Marc Gravell · Accepted Answer · 2024-12-03 09:09:06Z

1

Dapper doesn't have additional inbuilt logging because usually (there are a few niche exceptions), what gets executed is exactly what you pass as query, making it possible for you to add your own logging wherever and however you like.

If you want general SQL-connection level logging i.e. of all SQL operations: MiniProfiler has DbConnection wrappers that offer that capability (or you could use the MiniProfiler implementation as a base to write your own).

answered Dec 3, 2024 at 9:09

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dapper logging when using connection from EF Core DbContext

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related