建立SQL连接后,执行完SQL语句后,需要将sql连接关闭,想问下connection的属性有close和dispose,二者的区别是什么?我关闭连接后还需要dispose吗?
disposed属性和dipose属性的区别,前者的符号是闪电后者是紫块.
代码如下:
public void recordConnect(string sql)
{
SqlConnection RecordTableconn = new SqlConnection(@"Data Source=LIMING-PC\SQLEXPRESS;" + @"Integrated Security=True;Database=db_TomeTwo");
SqlCommand cmd = new SqlCommand(sql, RecordTableconn);
RecordTableconn.Open();
cmd.ExecuteNonQuery();
RecordTableconn.Close();
RecordTableconn.Dispose();
}
SQLCONNECTION
close()是关闭连接,dispose是释放资源,直接关闭就好了一般using用得也挺多的
public void recordConnect(string sql)
{
using (SqlConnection RecordTableconn = new SqlConnection(@"Data Source=LIMING-PC\SQLEXPRESS;" + @"Integrated Security=True;Database=db_TomeTwo"))
{
SqlCommand cmd = new SqlCommand(sql, RecordTableconn);
RecordTableconn.Open();
cmd.ExecuteNonQuery();
}
}
using后连接自动关闭并释放吗?
close()是关闭连接,dispose是释放资源,直接关闭就好了