public void ExecuteNonQuery_can_be_called_more_than_once_when_connection_changed() { using (var command = new SQLiteCommand("SELECT 1")) { using (var connection = new SQLiteConnection("Filename=:memory:")) { command.Connection = connection; connection.Open(); command.ExecuteNonQuery(); } using (var connection = new SQLiteConnection("Filename=:memory:")) { command.Connection = connection; connection.Open(); command.ExecuteNonQuery(); } } }
public static int ExecuteNonQuery(SQLiteConnection connection, string commandText, params DbParameter[] parameters) { using (SQLiteCommand cmd = new SQLiteCommand()) { cmd.Connection = connection; cmd.CommandText = commandText; cmd.CommandType = CommandType.Text; if (parameters != null) { foreach (DbParameter p in parameters) { cmd.Parameters.Add(p); } } return cmd.ExecuteNonQuery(); } }
public void ExecuteNonQuery_throws_when_no_connection() { using (var command = new SQLiteCommand()) { var ex = Assert.Throws<InvalidOperationException>(() => command.ExecuteNonQuery()); Assert.Equal(Strings.FormatCallRequiresOpenConnection("ExecuteNonQuery"), ex.Message); } }