public void TestExample() { //SETUP var options = this .CreateUniqueClassOptions <BookContext>(); using (var context = new BookContext(options)) { context.CreateEmptyViaWipe(); var logs = context.SetupLogging(); //ATTEMPT context.Add(new Book { Title = "New Book" }); context.SaveChanges(); //VERIFY context.Books.Count().ShouldEqual(1); foreach (var log in logs.ToList()) { _output.WriteLine(log.ToString()); } } }
public void TestExampleSqlDatabaseOk() { //SETUP var options = this .CreateUniqueClassOptions <BookContext>(); using (var context = new BookContext(options)) { context.CreateEmptyViaWipe(); //ATTEMPT context.SeedDatabaseFourBooks(); //VERIFY context.Books.Count().ShouldEqual(4); } }
public void TestApplyScriptTwoCommandsToDatabaseOk() { //SETUP var options = this.CreateUniqueClassOptions <BookContext>(); var filepath = TestData.GetFilePath("Script02 - Add two rows to Authors table.sql"); using (var context = new BookContext(options)) { context.CreateEmptyViaWipe(); //ATTEMPT context.ExecuteScriptFileInTransaction(filepath); //VERIFY context.Authors.Count().ShouldEqual(2); } }
public void TestApplyScriptExampleOk() { //SETUP var options = this .CreateUniqueClassOptions <BookContext>(); var filepath = TestData //#A .GetFilePath( //#A "AddUserDefinedFunctions.sql"); //#A using (var context = new BookContext(options)) { if (context.CreateEmptyViaWipe()) //#B { context //#C .ExecuteScriptFileInTransaction( //#C filepath); //#C } } }
public void TestCreateEmptyViaWipe() { //SETUP var options = this.CreateUniqueMethodOptions <BookContext>(); using (var context = new BookContext(options)) { context.Database.EnsureCreated(); context.SeedDatabaseDummyBooks(100); } using (var context = new BookContext(options)) { //ATTEMPT using (new TimeThings(_output, "Time to wipe the database")) { context.CreateEmptyViaWipe(); } //VERIFY context.Books.Count().ShouldEqual(0); } }