Exemple #1
0
        public void CanExec()
        {
            var descripton = _testDb.GenerateRandomString();
            var sql        = "INSERT INTO test_values (description) VALUES (@description);";
            var param      = new DbParams("description", descripton);

            var rowsAffected = _db.Exec(sql, param);

            Assert.Equal(1, rowsAffected);
        }
        public async Task CanExecAsync()
        {
            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 = await batch.ExecAsync(sql, param);

            batch.Commit();
            Assert.Equal(1, rowsAffected);
        }