public static void SetError(QueueConnection queueConnection, ICreationScope scope)
{
var connection = new SqlConnectionInformation(queueConnection);
var helper = new SqlServerTableNameHelper(connection);
using (var conn = new SqlConnection(queueConnection.Connection))
{
conn.Open();
using (var command = conn.CreateCommand())
{
command.CommandText = $"update {helper.StatusName} set status = 2";
command.ExecuteNonQuery();
}
}
}
public static void Verify(QueueConnection queueConnection, long messageCount, ICreationScope scope)
{
var connection = new SqlConnectionInformation(queueConnection);
var helper = new SqlServerTableNameHelper(connection);
using (var conn = new SqlConnection(queueConnection.Connection))
{
conn.Open();
using (var command = conn.CreateCommand())
{
command.CommandText = $"select count(*) from {helper.StatusName}";
using (var reader = command.ExecuteReader())
{
Assert.True(reader.Read());
var records = reader.GetInt32(0);
Assert.Equal(messageCount, records);
}
}
}
}
