怎样关闭数据库连接

Question

我想判断数据库的连接是否是开着的
if(Connection.state==1)
Connection.Close();
但是不对啊，应该怎样写呢？？？

Answer 1

if(Connection.state==ConnectionState.Open)
Connection.Close();

Answer 2

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

Answer 3

if(Connection.state==ConnectionState.Open)
Connection.Close();

Answer 4

if(Connection.state==ConnectionState.Open)
Connection.Close();

Answer 5

if(Connection.state==ConnectionState.Open)
Connection.Close();

Answer 6

if(Connection.state!=ConnectionState.Close)
Connection.Close();