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