public async Task ExecuteNonQueryCommandParamsAsync() { using (SqlServerTestHelper helper = CreateHelper(CreateTable_TestTable)) { var query = $"INSERT INTO {Table_TestTable} (Id, Number, Description) VALUES (@Id, @Number, @Description)"; QueryProvider provider = CreateQueryProvider(helper.Connection); int result = await provider.ExecuteNonQueryAsync(query, 6, 666, "Sed ac lobortis magna."); result.Should().Be(1); // Inserted 1 row. } }
public async Task ExecuteNonQueryCommandWithoutParametersAsync() { using (SqlServerTestHelper helper = CreateHelper(CreateTable_TestTable)) { var query = $"DELETE FROM {Table_TestTable}"; QueryProvider provider = CreateQueryProvider(helper.Connection); int result = await provider.ExecuteNonQueryAsync(query); result.Should().Be(3); // Deleted 3 rows. } }
public async Task ExecuteNonQueryCommandAsync() { using (SqlServerTestHelper helper = CreateHelper(CreateTable_TestTable)) { var query = $"INSERT INTO {Table_TestTable} (Id, Number, Description) VALUES (@Id, @Number, @Description)"; var parameters = new CommandParameterCollection { { "@Id", 6 }, { "@Number", 666 }, { "@Description", "Sed ac lobortis magna." } }; QueryProvider provider = CreateQueryProvider(helper.Connection); int result = await provider.ExecuteNonQueryAsync(query : query, parameters : parameters); result.Should().Be(1); // Inserted 1 row. } }
public virtual Task <int> ExecuteAsync() { return(QueryProvider.ExecuteNonQueryAsync(BuildQuery())); }