c# - How to test for database connection issues? -

c# - How to test for database connection issues? -

in our application, notice there codes create database connections phone call unnecessary e.g every info row in info set making database connection phone call check data.

how can monitor these kind of issue either via code scanning or database queries monitoring? advises?

you can create utilize of "sql profiler" if using ms sql. anyway code walk through must give thought it.

put debug prints in database connection method can track of connections made , sources.

c#