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