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