public void Setup()
{
//InMemory DB did not catch violation of foreign key constraint due to incorrect context configuration
options = new DbContextOptionsBuilder <AbsaPhonebookContext>().UseSqlServer(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=AbsaPhonebook;Integrated Security=True;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False").Options;
//"Data Source=(local);Initial Catalog=AbsaPhonebook;Integrated Security=True;" - MSSQL connection string
var context = new AbsaPhonebookContext(options);
context.RemoveRange(context.Phonebook);
context.RemoveRange(context.PhonebookEntry);
context.SaveChanges();
phonebook = PhonebookFactory.Create();
phonebook.Name = "Stellenbosch Directory";
phonebook.PhonebookEntries.Add(CreateEntry(phonebook, "Dave Worthington", "021979452"));
phonebook.PhonebookEntries.Add(CreateEntry(phonebook, "Bill Lumsden", "0215554334"));
repository = new PhonebookRepository(context);
entryRepository = new PhonebookEntryRepository(context);
repository.Add(phonebook);
repository.Commit();
}
public void Setup()
{
options = new DbContextOptionsBuilder <AbsaPhonebookContext>().UseInMemoryDatabase(databaseName: "AbsaPhonebook").Options;
var context = new AbsaPhonebookContext(options);
context.RemoveRange(context.Phonebook);
context.RemoveRange(context.PhonebookEntry);
context.SaveChanges();
phonebook = PhonebookFactory.Create();
phonebook.Name = "Stellenbosch Directory";
phonebook.PhonebookEntries.Add(CreateEntry(phonebook, "Dave Worthington", "021979452"));
phonebookEntry = CreateEntry(phonebook, "Bill Lumsden", "0215554334");
phonebook.PhonebookEntries.Add(phonebookEntry);
repository = new PhonebookRepository(context);
entryRepository = new PhonebookEntryRepository(context);
repository.Add(phonebook);
repository.Commit();
controller = new PhonebookController(repository, entryRepository);
}
