public void CanQuerySingle()
{
var expected = _testDb.GenerateRandomString();
var sql = "SELECT @description AS description";
var param = new DbParams("description", expected);
var result = _db.QuerySingle(sql, param, rd => rd.GetString("description"));
Assert.Equal(expected, result);
}
public void CanExecWithRollback()
{
var descripton = _testDb.GenerateRandomString();
var sql = "INSERT INTO test_values (description) VALUES (@description);";
var param = new DbParams("description", descripton);
var batch = _db.NewBatch();
var rowsAffected = batch.Exec(sql, param);
batch.Rollback();
var exists = _db.QuerySingle(
"SELECT description FROM test_values WHERE description = @description;",
param,
rd => rd.GetString("description"));
Assert.Null(exists);
}
