public async Task OneTimeTearDown() =>
await DatabaseTestsHelper.ExecuteSqlQueryAsync(
"DROP TABLE [ReminderItems]",
"DROP TABLE [ReminderContacts];",
"DROP TABLE [ReminderStatuses];",
"DROP PROCEDURE [AddReminderItem];",
"DROP PROCEDURE [UpdateReminderItem];");
public async Task OneTimeSetUp() =>
await DatabaseTestsHelper.ExecuteSqlQueryAsync(
ReminderStorageSctipts.CreateTableReminderStatuses,
ReminderStorageSctipts.CreateTableReminderContacts,
ReminderStorageSctipts.CreateTableReminderItems,
ReminderStorageSctipts.CreateProcedureAddReminderItem,
ReminderStorageSctipts.CreateProcedureUpdateReminderItem);
public async Task TearDown() =>
await DatabaseTestsHelper.ExecuteSqlQueryAsync(
"DELETE FROM [ReminderItems];",
"DELETE FROM [ReminderContacts];",
"DELETE FROM [ReminderStatuses];");
public async Task Setup() =>
await DatabaseTestsHelper.ExecuteSqlQueryAsync(
ReminderStorageSctipts.InsertReminderStatuses);