Will the connection close?

[Rafferty Uy]

Hi! Simple C# question, I'm just wondering the the connection will close in the code below:

try {
connection.Open();
command.ExecuteNonQuery();
throw new Exception();
} catch(Exception) {
throw;
}
finally {
connection.Close();
}

Rafferty

[rah_sin]

yes becouse finally block gets excecuted in any situation whether there is exception or code excecutes successfully.

rahul

[N a v a n e e t h]

Yes

Navaneeth How to use google | Ask smart questions

[Rafferty Uy]

So, in the statement sequence, will the connection.Close() be executed before or after the exception is rethrown in the catch(...) block? If after, what if this whole thing is contained in another try... catch statement, will the catch statement in the parent next be executed first?

Rafferty

[N a v a n e e t h]

What happened when you tried? All you are asking can be easily checked by writing a simple program.

Navaneeth How to use google | Ask smart questions

[Rafferty Uy]

haha okay okay, i'll try then.

Rafferty

[rah_sin]

it will excecuted after the exception is rethrown and the outer catch block will be excecuted next.

rahul

[Rafferty Uy]

You're right! I just made a small experiment as Navaneeth suggested and it looks like the case. Thanks much!

Rafferty