public async Task VerifyWorkItemStatePersistedTest() { var entities = new List <InstanceEntityBase>(); entities.Add(Utils.InfiniteWorkItemTestData(Guid.NewGuid().ToString("N"), Guid.NewGuid().ToString("N")).First()); await InstanceStore.WriteEntitiesAsync(entities); //second call should simply update each entity, not write new ones await InstanceStore.WriteEntitiesAsync(entities); await InstanceStore.DeleteEntitiesAsync(entities); using (var connection = GetConnection()) using (var command = connection.CreateCommand()) { command.CommandText = $"SELECT COUNT(1) FROM {Settings.WorkItemTableName}"; await connection.OpenAsync(); var count = (int)await command.ExecuteScalarAsync(); Assert.AreEqual(0, count, "Incorrect Work Item row count."); } }
public async Task VerifyOrchestrationStatePersistedTest() { var entities = new List <InstanceEntityBase>(); entities.AddRange(Utils.InfiniteOrchestrationTestData().Take(5)); await InstanceStore.WriteEntitiesAsync(entities); //second call should simply update each entity, not write new ones await InstanceStore.WriteEntitiesAsync(entities); await InstanceStore.DeleteEntitiesAsync(entities); using (var connection = GetConnection()) using (var command = connection.CreateCommand()) { command.CommandText = $"SELECT COUNT(1) FROM {Settings.OrchestrationStateTableName}"; await connection.OpenAsync(); var count = (int)await command.ExecuteScalarAsync(); Assert.AreEqual(0, count, "Incorrect Orchestration Instance row count."); } }