Question

我只想就使用SqlConnection物体的适当使用或适当设计发表意见。以下2种最佳用途:

一种数据提供者类别,其方法(其中每一种方法)含有SqlConnection物体(并在使用时处理)。和:

IList<Employee> GetAllEmployees() 
{ 
  using (SqlConnection connection = new SqlConnection(this.connectionString)) { 
  // Code goes here... 
  } 
} 

Employee GetEmployee(int id) 
{ 
  using (SqlConnection connection = new SqlConnection(this.connectionString)) { 
  // Code goes here... 
  } 
}

或

SqlConnection connection; // initialized in construct或 
IList<Employee> GetAllEmployees() 
{ 
  this.TryOpenConnection(); // tries to open member SqlConnection instance 
  // Code goes here... 
  this.CloseConnection(); 
  // return 
} 

Employee GetEmployee(int id) 
{ 
  this.TryOpenConnection(); // tries to open member SqlConnection instance 
  // Code goes here... 
  this.CloseConnection(); 
  // return 
}

Or is there a better approach than this? I have a focused web crawler type of application and this application will crawl 50 或 m或e websites simultaneously (multithreaded) with each website contained in a crawler object and each crawler object has an instance of a data provider class (above).

Answer 1

实际数据库链接将汇集起来。只要你所有的<代码>SqlConnection都使用同样的连接线,它们就能够真正使用同样的连接线。

I find it cleaner to create the connection instance, use it, then dispose it (in a using block). That way, if the code needs to change to use a different connection string, to use a transaction, or whatever, you have all you need to make the change available right there.

Answer 2

也许与实际无关,但我把任何联系分开的唯一时间反对叙级一级,是我要明确把对每种方法的关切分开...... 也许它太长,需要重新纳入几个部分,其中每一个部分都需要在作为交易一部分的同一关系下运作。

页: 1

Create a connection
Start transaction
Call a subroutine to update an order header (passing along the connection or get it from the instance)
Call a subroutine to update all order details (passing along the conneciton or get it from the instance)
End transaction
Close connection

否则,我基本上坚持选择。 1. W/联接基本上为你付出了代价。

友情链接