Using keyword

[INeedADip]

Can anyone here confirm for sure that reader.Close() and Dispose() will
get called using the following routine:

using(SqlDataReader reader = GetOpenReaderFunction())
{
while(reader.Read()) doSomething(reader);
}

I have seen examples here and there with mixed assumptions.

[Nicholas Paldino [.NET/C# MVP]]

INeedADip,

Yes, it will definitely close. For all intents and purposes, the C#
compiler translates that into:

SqlDataReader reader = GetOpenReaderFunction();

try
{
while(reader.Read()) doSomething(reader);
}
finally
{
if (reader != null)
{
((IDispose) reader).Dispose();
}
}

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
"INeedADip" <in*******@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Can anyone here confirm for sure that reader.Close() and Dispose() will
get called using the following routine:

using(SqlDataReader reader = GetOpenReaderFunction())
{
while(reader.Read()) doSomething(reader);
}

I have seen examples here and there with mixed assumptions.

[John Wood]

Dispose will be called automatically when the scope under the using
statement exits.

And Dispose will call Close().

"INeedADip" <in*******@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Can anyone here confirm for sure that reader.Close() and Dispose() will
get called using the following routine:

using(SqlDataReader reader = GetOpenReaderFunction())
{
while(reader.Read()) doSomething(reader);
}

I have seen examples here and there with mixed assumptions.

[Tom Porterfield]

INeedADip wrote:

Can anyone here confirm for sure that reader.Close() and Dispose() will
get called using the following routine:

using(SqlDataReader reader = GetOpenReaderFunction())
{
while(reader.Read()) doSomething(reader);
}

I have seen examples here and there with mixed assumptions.

Dispose will be called when the using block is exited, whether through
normal code execution or if an exception occurs. The Dispose method of
SqlDataReader calls Close to insure that the connection has been closed.

As a generic statement, using insures that Dispose will be called. It
is up to the implementation of Dispose that insures resources are
properly released.
--
Tom Porterfield

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

"INeedADip" <in*******@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Can anyone here confirm for sure that reader.Close() and Dispose() will
get called using the following routine:

using(SqlDataReader reader = GetOpenReaderFunction())
{
while(reader.Read()) doSomething(reader);
}

I have seen examples here and there with mixed assumptions.

To be exact it's Dispose which is called and in this particular case Dispose
does call Close.

Note that you still need to close the connection, as the closing of the
DataReader does not close it.
UNLESS you created your reader using SqlCommand.ExecuteReader(
CommandBehavior.CloseConnection );

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

[Ignacio Machin \( .NET/ C# MVP \)]

Hi Tom,

Dispose will be called when the using block is exited, whether through
normal code execution or if an exception occurs. The Dispose method of
SqlDataReader calls Close to insure that the connection has been closed.

It's the Close of the datareader or the one of the connection the one that
is called?
I was under the impression it was the Reader, as this is needed to have
access to stuff like, output parameters, records count. and return values.

The connection is only closed when the correct CommandBehaviour is passed in
the ExecuteReader

Correct me if I'm wrong

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

[Jon Skeet [C# MVP]]

INeedADip <in*******@gmail.com> wrote:

Can anyone here confirm for sure that reader.Close() and Dispose() will
get called using the following routine:

using(SqlDataReader reader = GetOpenReaderFunction())
{
while(reader.Read()) doSomething(reader);
}

I have seen examples here and there with mixed assumptions.

Close() won't be called, but Dispose() will be (which is enough).

The only problem would be if GetOpenReaderFunction() acquired a
SqlDataReader but then threw an exception before returning it.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[John Wood]

> Close() won't be called, but Dispose() will be (which is enough). <
Well, Close will be called by Dispose. (at least according to the
disassembled code for SqlDataReader).
But you probably mean that the using clause calls dispose directly, not
close.

"Jon Skeet [C# MVP]" <sk***@pobox.com> wrote in message
news:MP************************@msnews.microsoft.c om...

INeedADip <in*******@gmail.com> wrote:

Can anyone here confirm for sure that reader.Close() and Dispose() will
get called using the following routine:

using(SqlDataReader reader = GetOpenReaderFunction())
{
while(reader.Read()) doSomething(reader);
}

I have seen examples here and there with mixed assumptions.

Close() won't be called, but Dispose() will be (which is enough).

The only problem would be if GetOpenReaderFunction() acquired a
SqlDataReader but then threw an exception before returning it.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Jon Skeet [C# MVP]]

John Wood <john.wood@priorganize_nospam__.com> wrote:

Close() won't be called, but Dispose() will be (which is enough). <

Well, Close will be called by Dispose. (at least according to the
disassembled code for SqlDataReader).
But you probably mean that the using clause calls dispose directly, not
close.

Exactly :)

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Tom Porterfield]

Ignacio Machin ( .NET/ C# MVP ) wrote:

Correct me if I'm wrong

You are correct, it is the reader that is closed, not the connection.
Thanks.
--
Tom Porterfield

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,
"John Wood" <john.wood@priorganize_nospam__.com> wrote in message
news:%2***************@tk2msftngp13.phx.gbl...

Close() won't be called, but Dispose() will be (which is enough). <

Well, Close will be called by Dispose. (at least according to the
disassembled code for SqlDataReader).
But you probably mean that the using clause calls dispose directly, not
close.

A bad thing is this is not clearly stated in the documentation. I did not
check msdn2 though.

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation