DbDataAdapter

When DbDataAdapter is used to retrieve or update data, it examines the status of the con-
nection. If the connection is open, the DbDataAdapter uses the open connection and leaves
the connection open. If the connection is closed, DbDataAdapter opens the connection, uses
it, and then closes it automatically. If you never open the connection, you don’t have to close
the connection. However, if you have many data adapters that will be used in one operation,
you can get better performance by manually opening the connection before you call all the
data adapters; just be sure to close the connection when you’re done.