public void CompareTptContextSuppressViaIgnoreTheseErrors() { //SETUP var options = this.CreateUniqueClassOptions <TptDbContext>(); using var context = new TptDbContext(options); context.Database.EnsureClean(); var config = new CompareEfSqlConfig(); config.IgnoreTheseErrors(@"DIFFERENT: TptVer1->PrimaryKey 'PK_TptBases', constraint name. Expected = PK_TptBases, found = PK_TptVer1 DIFFERENT: TptVer1->Property 'Id', value generated. Expected = OnAdd, found = Never DIFFERENT: TptVer1->ForeignKey 'FK_TptVer1_TptBases_Id', delete behavior. Expected = ClientCascade, found = NoAction DIFFERENT: Entity 'TptVer1', constraint name. Expected = PK_TptBases, found = PK_TptVer1 DIFFERENT: TptVer2->PrimaryKey 'PK_TptBases', constraint name. Expected = PK_TptBases, found = PK_TptVer2 DIFFERENT: TptVer2->Property 'Id', value generated. Expected = OnAdd, found = Never DIFFERENT: TptVer2->ForeignKey 'FK_TptVer2_TptBases_Id', delete behavior. Expected = ClientCascade, found = NoAction DIFFERENT: Entity 'TptVer2', constraint name. Expected = PK_TptBases, found = PK_TptVer2"); var comparer = new CompareEfSql(config); //ATTEMPT var hasErrors = comparer.CompareEfWithDb(context); //VERIFY hasErrors.ShouldBeFalse(comparer.GetAllErrors); }
private static void SeedData(TptDbContext ctx, ILoggerFactory loggerFactory) { ctx.Database.Migrate(); if (ctx.People.Any()) { return; } using var innerCtx = GetTphContext(loggerFactory); innerCtx.SeedData(); }
public void CompareTptContext() { //SETUP var options = this.CreateUniqueClassOptions <TptDbContext>(); using var context = new TptDbContext(options); context.Database.EnsureClean(); var comparer = new CompareEfSql(); //ATTEMPT var hasErrors = comparer.CompareEfWithDb(context); //VERIFY hasErrors.ShouldBeFalse(comparer.GetAllErrors); }
public void CompareTptContext() { //SETUP var options = this.CreateUniqueClassOptions <TptDbContext>(); using var context = new TptDbContext(options); context.Database.EnsureClean(); var comparer = new CompareEfSql(); //ATTEMPT var hasErrors = comparer.CompareEfWithDb(context); //VERIFY _output.WriteLine("THIS TEST FAILS to show that this library doesn't handle Table-Per-Type entities"); hasErrors.ShouldBeFalse(comparer.GetAllErrors); }
private static void Tht() { using (var context = new TptDbContext()) { var people = context.People.ToList(); var customers = context.Customers.ToList(); var employees = context.Employees.ToList(); context.Customers.Add(new CustomerTpt { Person = new PersonTpt { Id = Guid.NewGuid(), FirstName = "KK", LastName = "kk" }, DateOfBirth = DateTime.Now }); context.SaveChanges(); } }
public Tpt_Queries(TptDbContext ctx, ILogger logger) { _ctx = ctx ?? throw new ArgumentNullException(nameof(ctx)); _logger = logger ?? throw new ArgumentNullException(nameof(logger)); }