1
vote
2answers
38 views

Using for IDbConnection/IDbTransaction safe to use?

While my assumption may seem to sound subjective, after some research, I found that it's not uncommon to find developers who favour a dummy Try/Catch instead of using the Using statement for ...
1
vote
2answers
178 views

Is Close on database connection calling here?

I got this code: try { using (OracleConnection c = new OracleConnection(globalDict[byAlias(connAlias)].connString)) { c.Open(); using (OracleCommand recordExistentQuery = new ...
1
vote
2answers
391 views

C# / Informix: Do I need to explicitly call Close on my DB Connection if it's in a using statement?

Basically, if I'm doing the following: using (IfxConnection connection = ConnectionManager.GetConnection()) { connection.Open(); ... if (connection != null) connection.Close(); //Is this ...
4
votes
4answers
403 views

Am I closing this SQL connection in a C# function appropriately?

In an attempt to close my question on connections remaining open and exceeding the maximum pool, I'm trying tor rewrite the function that is used to connect to our database. The function exists ...