How to enable logging to track sql statements being generated.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
mkkallepalli
Posts: 1
Joined: Tue 05 Dec 2017 12:19

How to enable logging to track sql statements being generated.

Post by mkkallepalli » Tue 05 Dec 2017 12:25

We are looking for an option to log pg SQL statements when retrieved or inserted to database into a file. Is there an option available to log the statements when using ADO.Net entity data model?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: How to enable logging to track sql statements being generated.

Post by Shalex » Wed 06 Dec 2017 15:26

Please employ dbMonitor: http://www.devart.com/dotconnect/postgr ... nitor.html. When it is enabled, it should trace all database events.

In case of EF Core, there is an alternative solution: https://docs.microsoft.com/en-us/ef/cor ... us/logging.

Post Reply