using System; using System.Collections.Generic; using System.Text; using Microsoft.EntityFrameworkCore; using CertAuth.Domain; namespace CertAuth.Data { public class CertAuthContext: DbContext { public CertAuthContext(DbContextOptions options) :base(options) { ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; } public DbSet Collector_ItemAssoc { get; set; } public DbSet Collectors { get; set; } public DbSet Items { get; set; } public DbSet Item_TagAssoc { get; set; } public DbSet RFIDTagMstr { get; set; } public DbSet TableDtl { get; set; } public DbSet TableMstr { get; set; } public DbSet Users { get; set; } public DbSet VendorMstr { get; set; } //added 12/1/2020 public DbSet UserVendrKey { get; set; } public DbSet CollectorItemsList { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity() .HasKey(c => new { c.Id, c.TagUID }); //modelBuilder.Entity(eb => { eb.HasNoKey(); }); //modelBuilder.Entity(eb => { eb.HasNoKey(); }); //modelBuilder.Entity().Property(t => t.TagID).HasColumnType("UniqueIdentifier"); } //protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) //{ // optionsBuilder.UseSqlServer("Data Source=smartcuredbserver.database.windows.net;Initial Catalog=Quartexxdb;Persist Security Info=True;User ID=SmartCureAdmin;Password=NApex135!"); //} } }