public async Task UpdateLetterTest(int value) { var connection = new SqliteConnection("DataSource=:memory:"); connection.Open(); var options = new DbContextOptionsBuilder <LetterDbContext>() .UseSqlite(connection) .Options; using (var context = new LetterDbContext(options)) { context.Database.EnsureCreated(); LetterDbContextInitializer.Initialize(context); } LetterModel letterModel = new LetterModel() { Receivers = new List <ReceiverModel>(), SentStatus = true, SentDate = DateTime.Today, TemplateId = 1 }; using (var context = new LetterDbContext(options)) { LettersCommands lettersCommands = null; Letter letterUpdated = null; try { lettersCommands = this.GetStorageCommand(context); await lettersCommands.UpdateAsync(value, letterModel); letterUpdated = context.Letters.SingleOrDefault(let => let.Id == value); if (letterUpdated == null) { Assert.Null(letterUpdated); return; } } catch (Exception ex) { Debug.WriteLine(ex.Message); } Assert.True(letterUpdated.SentStatus == letterModel.SentStatus); Assert.True(letterUpdated.SentDate == letterModel.SentDate); } }
public async Task DeleteLetterTest(int value) { var connection = new SqliteConnection("DataSource=:memory:"); connection.Open(); var options = new DbContextOptionsBuilder <LetterDbContext>() .UseSqlite(connection) .Options; using (var context = new LetterDbContext(options)) { context.Database.EnsureCreated(); LetterDbContextInitializer.Initialize(context); } using (var context = new LetterDbContext(options)) { LettersCommands lettersCommands = null; Letter letterCreated = null; try { lettersCommands = this.GetStorageCommand(context); await lettersCommands.DeleteAsync(value); letterCreated = context.Letters.SingleOrDefault(let => let.Id == value); } catch (Exception ex) { Debug.WriteLine(ex.Message); } Assert.Null(letterCreated); } }