Page 1 of 1

How to enable logging to track sql statements being generated.

Posted: Tue 05 Dec 2017 12:25
by mkkallepalli
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?

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

Posted: Wed 06 Dec 2017 15:26
by Shalex
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.