SqlCommand不执行

Question

我不明白为什么我的代码不正确地执行SqlCommand，即使我没有收到任何错误。

这是我的代码：

_connection.Connection.OpenAsync();
_connection.SqlCommand.Connection = _connection.Connection;
_connection.SqlCommand.CommandText = "insert into test (id, name) values ('dq1we3','d2qwe3')";
_connection.SqlCommand.ExecuteNonQueryAsync();
_connection.Dispose();

这里我初始化了SqlConnection和SqlCommand：

private readonly string _conString = Settings.Default.RssConnectionString;

public SqlConnection Connection;
public SqlCommand SqlCommand;

public TestConnection()
{
    Connection = new SqlConnection(_conString);
    SqlCommand = new SqlCommand();
}

public void Dispose()
{
    Connection.Close();
}

Answer 1

应该这样做：

using (var myConnection = new SqlConnection(connectionString)) // using automatically disposes of object
{
    myConnection.Open();

    string commandText = "insert into test (id, name) values ('dq1we3','d2qwe3')";

    using (var myCommand = new SqlCommand(commandText, myConnection))
    {
        myCommand.CommandType = CommandType.Text;
        myCommand.ExecuteNonQuery();
    }
}

Answer 2

在打开连接之前，需要先设置连接字符串吗？

_connection.SqlCommand.Connection = _connection.Connection;
_connection.Connection.OpenAsync();