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