我想知道在实例化一个新的MySqlConnection对象VS是否将实例化的MySqlConnection对象传递到C#中的“ using”语句中是否有区别吗?
如果可以,哪种方法更好?为什么比其他更可取?
以下是模拟这两种情况的示例代码:
public class QueryService() {
private IDbConnection con;
public QueryService() {
con = new MySqlConnection(connectionString));
}
public List QueryList() {
using (con)
{
con.Open();
// Do work here; connection closed on following line.
}
}
}
public class QueryService() {
public QueryService() {}
public List QueryList() {
using (var con = new MySqlConnection(connectionString)))
{
con.Open();
// Do work here; connection closed on following line.
}
}
}