public void ExecuteDeleteQuery()
{
using (SqlServerTestHelper helper = CreateHelper(CreateTable_TestTable))
{
var query = $"DELETE FROM {Table_TestTable}";
QueryProvider provider = CreateQueryProvider(helper.Connection);
int result = provider.ExecuteNonQuery(query);
result.Should().Be(3); // Deleted 3 rows.
}
}
public void ThrowExceptionWhenParameterIsNullAndDataTypeIsNotSetInQuery()
{
var parameters = new CommandParameterCollection
{
{ "@Param1", 1 },
{ "@Param2", null }
};
using (SqlServerTestHelper helper = CreateHelper((string)null))
{
QueryProvider provider = CreateQueryProvider(helper.Connection);
Action executeNonQuery = () => provider.ExecuteNonQuery("NO QUERY", parameters);
executeNonQuery.Should().Throw <ArgumentException>().WithMessage("*@Param2*");
}
}
public void ExecuteUpdateQuery()
{
using (SqlServerTestHelper helper = CreateHelper(CreateTable_TestTable))
{
var query = $"UPDATE {Table_TestTable} SET Number = @Number WHERE Id >= @Id";
var parameters = new CommandParameterCollection
{
{ "@Id", 2 },
{ "@Number", 666 }
};
QueryProvider provider = CreateQueryProvider(helper.Connection);
int result = provider.ExecuteNonQuery(query, parameters);
result.Should().Be(2); // Updated 2 rows.
}
}
public void ExecuteInsertQuery()
{
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 = provider.ExecuteNonQuery(query, parameters);
result.Should().Be(1); // Inserted 1 row.
}
}
public virtual int Execute()
{
return(QueryProvider.ExecuteNonQuery(BuildQuery()));
}
