public async Task InsertQueryTestAsync() { var queryDispatcher = new QueryDispatcher( new QueryExecutor( new CommandPreparer(), new ConnectionFactory(ConnectionString.Default))); var queries = new String[] { "DROP TABLE IF EXISTS insert_query_test;", "CREATE TABLE insert_query_test (value TEXT NOT NULL);", "INSERT INTO insert_query_test VALUES ('StraightSql');" }; foreach (var query in queries) { await queryDispatcher.ExecuteAsync(new Query(query)); } var countQuery = "SELECT COUNT(*) FROM insert_query_test;"; var count = await queryDispatcher.CountAsync(new Query(countQuery)); Assert.Equal(count, 1); }