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