public void Commit_throws_when_connection_closed()
{
using (var connection = new SQLiteConnection("Filename=:memory:"))
{
connection.Open();
using (var transaction = connection.BeginTransaction())
{
connection.Close();
var ex = Assert.Throws<InvalidOperationException>(() => transaction.Commit());
Assert.Equal(Strings.TransactionCompleted, ex.Message);
}
}
}
public void Close_can_be_called_more_than_once()
{
using (var connection = new SQLiteConnection("Filename=:memory:"))
{
connection.Open();
connection.Close();
connection.Close();
}
}
public void Close_works()
{
using (var connection = new SQLiteConnection("Filename=:memory:"))
{
connection.Open();
var raised = false;
StateChangeEventHandler handler = (sender, e) =>
{
raised = true;
Assert.Equal(connection, sender);
Assert.Equal(ConnectionState.Open, e.OriginalState);
Assert.Equal(ConnectionState.Closed, e.CurrentState);
};
connection.StateChange += handler;
try
{
connection.Close();
Assert.True(raised);
Assert.Equal(ConnectionState.Closed, connection.State);
}
finally
{
connection.StateChange -= handler;
}
}
}
public void Close_can_be_called_before_open()
{
using (var connection = new SQLiteConnection("Filename=test.db"))
{
connection.Close();
}
}
public bool UpdateTableField(
string tableName,
string keyFieldName,
string keyFieldValue,
string dataFieldName,
string dataFieldValue,
string additionalWhere)
{
bool result = false;
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE " + tableName + " ");
sqlCommand.Append(" SET " + dataFieldName + " = :fieldValue ");
sqlCommand.Append(" WHERE " + keyFieldName + " = " + keyFieldValue);
sqlCommand.Append(" " + additionalWhere + " ");
sqlCommand.Append(" ; ");
SQLiteParameter[] arParams = new SQLiteParameter[1];
arParams[0] = new SQLiteParameter(":fieldValue", DbType.String);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = dataFieldValue;
SQLiteConnection connection = new SQLiteConnection(connectionString);
connection.Open();
try
{
int rowsAffected = AdoHelper.ExecuteNonQuery(connection, sqlCommand.ToString(), arParams);
result = (rowsAffected > 0);
}
finally
{
connection.Close();
}
return result;
}
