c# - 企业库 5.0 强行关闭事件连接

Question

如何强制关闭数据库连接？

我用来创建连接的示例代码是:

class Customer{
     private readonly Database _db;
      public Customer(){
            _db = = DatabaseFactory.CreateDatabase(_userSettings.ConnstringName);
       }

   .. stuff to use this connection..

}

Answer 1

将代码(.. 使用此连接的东西..)放在 using block 中，这将确保关闭连接。例如:

using (DbCommand command = _db.GetStoredProcCommand(sprocName, parameters))    
{

和:

using (IDataReader rdr = _db.ExecuteReader(command))
{

Using block 是确保资源正确关闭的好方法:

The using statement allows the programmer to specify when objects that use resources should release them.

否则，您必须在连接对象上显式调用 Close() 方法:

if (command.Connection.State == ConnectionState.Open)
            command.Connection.Close();