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);
}
}