Is there any way to trace\log the sql using Dapper?

by

I got the same issue and implemented some code after doing some search but having no ready-to-use stuff. There is a package on nuget MiniProfiler.Integrations I would like to share.

Update V2: it supports to work with other database servers, for MySQL it requires to have MiniProfiler.Integrations.MySql

Below are steps to work with SQL Server:

1.Instantiate the connection

var factory = new SqlServerDbConnectionFactory(_connectionString);
using (var connection = ProfiledDbConnectionFactory.New(factory, CustomDbProfiler.Current))
{
 // your code
}

2.After all works done, write all commands to a file if you want

File.WriteAllText("SqlScripts.txt", CustomDbProfiler.Current.ProfilerContext.BuildCommands());

More Related Contents:

  1. Manually map column names with class properties
  2. Multi-Mapper to create object hierarchy
  3. Correct use of multimapping in Dapper
  4. How to implement Unit Of Work pattern with Dapper?
  5. Fastest way to perform nested bulk inserts with scope_identity() usage?
  6. SELECT * FROM X WHERE id IN (…) with Dapper ORM
  7. How do I map lists of nested objects with Dapper
  8. Is there a way to call a stored procedure with Dapper?
  9. Does Dapper support SQL 2008 Table-Valued Parameters?
  10. How to implement Generic Repository Design Pattern with Dapper?
  11. Dapper.NET and stored proc with multiple result sets
  12. How do I write one to many query in Dapper.Net?
  13. Performing Inserts and Updates with Dapper
  14. How do I perform an insert and return inserted identity with Dapper?
  15. Bulk inserts taking longer than expected using Dapper
  16. Why doesn’t Dapper dot net open and close the connection itself?
  17. Closing connection when using Dapper
  18. How do I handle Database Connections with Dapper in .NET?
  19. Dapper.Rainbow VS Dapper.Contrib
  20. Dapper and SQL Injections
  21. Dapper and anonymous Types
  22. Passing query parameters in Dapper using OleDb
  23. Why Entity Framework performs faster than Dapper in direct select statement [closed]
  24. What causes “extension methods cannot be dynamically dispatched” here?

Leave a Comment