public async void PSPMeasFetchTest() { string connStr = Configuration["psplabelsdbinfo:ConnectionString"]; Assert.NotNull(connStr); DbContextOptionsBuilder <PSPMeasDbContext> builder = new DbContextOptionsBuilder <PSPMeasDbContext>().UseSqlServer(connStr); PSPMeasDbContext measDbContext = new PSPMeasDbContext(builder.Options); List <PspMeasurement> measurements = await measDbContext.PspDbMeasurements.ToListAsync(); Assert.NotNull(measurements); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { // // Configure pspmeasurements from other project // PSPMeasDbContext.FluentMethods(modelBuilder); // // Configure label checks // // Configure primary key modelBuilder.Entity <LabelCheck>().HasKey(l => l.Id); //Configure NotNull Columns modelBuilder.Entity <LabelCheck>().Property(l => l.CheckType).IsRequired(); modelBuilder.Entity <LabelCheck>().Property(l => l.ConsiderStartTime).IsRequired().HasDefaultValue(LabelCheckUtils.DefaultCheckConsiderStartTime); modelBuilder.Entity <LabelCheck>().Property(l => l.ConsiderEndTime).IsRequired().HasDefaultValue(LabelCheckUtils.DefaultCheckConsiderEndTime); modelBuilder.Entity <LabelCheck>().Property(l => l.PspMeasurementId).IsRequired(); //Configure foriegn keys modelBuilder.Entity <LabelCheck>().HasOne(l => l.PspMeasurement).WithMany().HasForeignKey(l => l.PspMeasurementId); // set seeds //modelBuilder.Entity<LabelCheck>().HasData(DbInitializer.GetLabelSeeds()); // // Configure label check results // // Configure table name modelBuilder.Entity <LabelCheckResult>().ToTable("LabelCheckResults"); // Configure primary key modelBuilder.Entity <LabelCheckResult>().HasKey(r => r.Id); //Configure NotNull Columns modelBuilder.Entity <LabelCheckResult>().Property(r => r.IsSuccessful).IsRequired(); modelBuilder.Entity <LabelCheckResult>().Property(r => r.LabelCheckId).IsRequired(); modelBuilder.Entity <LabelCheckResult>().Property(r => r.CheckProcessStartTime).IsRequired(); modelBuilder.Entity <LabelCheckResult>().Property(r => r.CheckProcessEndTime).IsRequired(); //Configure foriegn keys modelBuilder.Entity <LabelCheckResult>().HasOne(r => r.LabelCheck).WithMany().HasForeignKey(r => r.LabelCheckId); // // Configure label check params // // Configure primary key modelBuilder.Entity <LabelCheckParam>().HasKey(r => r.Id); //Configure foriegn keys modelBuilder.Entity <LabelCheckParam>().HasOne(r => r.LabelCheck).WithMany(l => l.LabelCheckParams).HasForeignKey(r => r.LabelCheckId); //Configure uniqueness constraint modelBuilder.Entity <LabelCheckParam>().HasIndex(p => new { p.Name, p.LabelCheckId }).IsUnique(); }
public void PSPLabelsDBConnTest() { string connStr = Configuration["psplabelsdbinfo:ConnectionString"]; Assert.NotNull(connStr); DbContextOptionsBuilder <PSPMeasDbContext> builder = new DbContextOptionsBuilder <PSPMeasDbContext>().UseSqlServer(connStr); PSPMeasDbContext measDbContext = new PSPMeasDbContext(builder.Options); DbConnection conn = measDbContext.Database.GetDbConnection(); bool isError = false; try { conn.Open(); } catch (Exception e) { Console.WriteLine(e.Message); isError = true; } finally { //close the connection conn.Close(); // free the resources conn.Dispose(); } if (isError) { Assert.True(false); } else { Assert.True(true); } }
public PSPMeasRepo(PSPMeasDbContext dbContext) { _dbContext = dbContext; }