dbConn.Open inside using

Question

using (IDbConnection dbConn = new System.Data.SqlClient.SqlConnection(ConnectionString))
{
    dbConn.Open();
    ...
    return result;
}

Will the dbConn.Open() inside the using will use a different connection pool?
If the question number 1 is true and if the code reaches the return, will this code leaves 2 open connection hanging?

for the question #1, I mean will it open up another connection? — cypher-lad
– cypher-lad, Commented Jul 16, 2020 at 14:35
@RaoHammas using statement ensures that the connection will be closed and disposed, no need to close — apomene
– apomene, Commented Jul 16, 2020 at 14:41
@Mrky Correct, it will close and dispose when it goes out of scope, thanks to the using statement. I suggest you read more about IDisposable. — mason
– mason, Commented Jul 16, 2020 at 14:44

D Stanley · Accepted Answer · 2020-07-16 18:43:42Z

Will the dbConn.Open() inside the using will use a different connection pool?

There is only one "connection pool".

If the question number 1 is true and if the code reaches the return, will this code leaves 2 open connection hanging?

Well question 1 is false, but here's what actually happens:

The code in the using statement creates the connection object.
When you call Open(), the connection object asks for an existing database connection from the pool, and creates one if the pool does not have one (perhaps the pool actually creates it, but that's an implementation detail)
When the block ends (or an exception is thrown), the using block goes out of scope and the connection object is disposed of, which closes and releases the database connection.

So there is only one connection object and one database connection. It is automatically disposed of when the using block goes out of scope (either by completing or my throwing an exception).

C-Sharpie · Accepted Answer · 2020-07-16 14:47:00Z

0

It will create a new connection which will then be disposed of when the using block has reached the end. It's a good idea to close you connection when you no longer need it, if you have more going on in the using block but the using block will handle that.

When the code reaches the return, it exits out of the using statement so it then does the disposing. It's not like it returns and doesn't finish in case thats what you are asking. The dispose is called as soon as the execution leaves that scope. Even if you get an exception the Dispose will be called.

A using block gets compiled into a try catch finally block and the finally is always executed and the finally contains the Dispose

answered Jul 16, 2020 at 14:47

C-Sharpie

2253 silver badges12 bronze badges

1 Comment

mason Over a year ago

It will create a new connection object, but you're ignoring the pooling aspect of the question.

Collectives™ on Stack Overflow

dbConn.Open inside using

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related