ADO.NET: Does ExecuteScalar close the connection automatically?

Question

Does ExecuteScalar close the connection automatically?

score 6 · Accepted Answer · answered Jul 12 '10 at 14:55

6

No, you need to explicitly open and close the connection when using ExecuteScalar().

answered Jul 12 '10 at 14:55

DCNYAM

11,966
8
53
70

Rodrick Chapman · Answer 2 · 2014-09-19T03:35:16.873

5

You could create an overload using an extension method though I'm not sure if it's a good idea.

public static object ExecuteScalar(this IDbCommand Command, bool CloseConnetion)
{

    (if Command == null)
        throw new NullReferenceException();

    object obj = null;

    try
    {
      obj = Command.ExecuteScalar();        
    }
    finally
    {
      if(CloseConnection && Command.Connection.State != ConnectionState.Closed)
        Command.Connection.Close();    
    }

    return obj;
}

edited Sep 19 '14 at 03:35

answered Jul 12 '10 at 15:11

Rodrick Chapman

5,437
2
31
32

this looks nice, but I can only develope against .NET 2.0 =) – Rookian Jul 12 '10 at 15:32
1

@Rookian, Since extension methods are just methods on a static class you could always call the method like so: Helper.ExecuteScalar(IDbCommandInstance, true); – Rodrick Chapman Jul 12 '10 at 15:38

score 3 · Answer 3 · answered Jul 12 '10 at 14:51

3

That depends.
One can write an implementation of IDbCommand that will close the connection.
But as far as I know the provided implementations does not close the connection.

answered Jul 12 '10 at 14:51

Itay Karo

17,924
4
40
58

1

+1 for noting that ExecuteScalar is a method on an interface. – Rodrick Chapman Jul 12 '10 at 15:15

ADO.NET: Does ExecuteScalar close the connection automatically?

3 Answers3