public void CompareWithBookDatabase() { //SETUP string connectionString; using (var context = new BookContext(GetBookContextOptions())) { connectionString = context.Database.GetDbConnection().ConnectionString; context.Database.EnsureCreated(); } using (var context = new BookOrderContext(_options)) { var comparer = new CompareEfSql(); //ATTEMPT var hasErrors = comparer.CompareEfWithDb(connectionString, context); //VERIFY hasErrors.ShouldBeTrue(); var errors = CompareLog.ListAllErrors(comparer.Logs).ToList(); errors.Count.ShouldEqual(2); errors[0].ShouldEqual( "NOT IN DATABASE: Entity 'LineItem', table name. Expected = LineItem"); errors[1].ShouldEqual( "NOT IN DATABASE: Entity 'Order', table name. Expected = Orders"); } }
public void CompareDatabaseViaConnectionName() { //SETUP const string connectionStringName = "BookOrderConnection"; //#A //!!!!!!!!!! LEAVE OUT OF BOOK - START var connectionString = AppSettings.GetConfiguration().GetConnectionString(connectionStringName); var optionsBuilder = new DbContextOptionsBuilder <BookOrderContext>(); optionsBuilder.UseSqlServer(connectionString); var options = optionsBuilder.Options; //!!!!!!!!!! LEAVE OUT OF BOOK - END //... I left out the option building part to save space using (var context = new BookOrderContext(options)) //#B { var comparer = new CompareEfSql(); //#C //ATTEMPT bool hasErrors = comparer.CompareEfWithDb //#D (connectionStringName, context); //#D //VERIFY hasErrors.ShouldBeFalse(comparer.GetAllErrors); //#E } }
public ComparerBooksAndOrders(ITestOutputHelper output) { _output = output; _options = this .CreateUniqueClassOptions <BookOrderContext>(); using (var context = new BookOrderContext(_options)) { _connectionString = context.Database.GetDbConnection().ConnectionString; context.Database.EnsureCreated(); } }
public void CompareViaConnection() { //SETUP using (var context = new BookOrderContext(_options)) { var comparer = new CompareEfSql(); //ATTEMPT var hasErrors = comparer.CompareEfWithDb(_connectionString, context); //VERIFY hasErrors.ShouldBeFalse(comparer.GetAllErrors); } }