using System;
|
using Microsoft.EntityFrameworkCore;
|
using Microsoft.EntityFrameworkCore.Metadata;
|
|
#nullable disable
|
|
namespace zhengcaioa.Models
|
{
|
public partial class zcUserInfoN_dbContext : DbContext
|
{
|
public zcUserInfoN_dbContext()
|
{
|
}
|
|
public zcUserInfoN_dbContext(DbContextOptions<zcUserInfoN_dbContext> options)
|
: base(options)
|
{
|
}
|
|
public virtual DbSet<GadeRole> GadeRoles { get; set; }
|
public virtual DbSet<UsergGadeRole> UsergGadeRoles { get; set; }
|
|
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
|
{
|
if (!optionsBuilder.IsConfigured)
|
{
|
#warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see http://go.microsoft.com/fwlink/?LinkId=723263.
|
optionsBuilder.UseSqlServer("Data Source=.;Initial Catalog=zcUserInfoN_db;User ID=sa;Password=123456");
|
}
|
}
|
|
protected override void OnModelCreating(ModelBuilder modelBuilder)
|
{
|
modelBuilder.HasAnnotation("Relational:Collation", "Chinese_PRC_CI_AS");
|
|
modelBuilder.Entity<GadeRole>(entity =>
|
{
|
entity.ToTable("gadeRoles");
|
|
entity.HasIndex(e => e.FrameworkRoleId, "IX_gadeRoles_FrameworkRoleId");
|
|
entity.Property(e => e.Id)
|
.ValueGeneratedNever()
|
.HasColumnName("ID");
|
|
entity.Property(e => e.CreateBy).HasMaxLength(50);
|
|
entity.Property(e => e.OnShelf).HasColumnName("onShelf");
|
|
entity.Property(e => e.Price)
|
.HasColumnType("decimal(18, 2)")
|
.HasColumnName("price");
|
|
entity.Property(e => e.UpdateBy).HasMaxLength(50);
|
|
entity.Property(e => e.XiaoCaiQandA).HasColumnName("XiaoCaiQAndA");
|
|
entity.Property(e => e.XiaocaiKeTang).HasColumnName("xiaocaiKeTang");
|
});
|
|
modelBuilder.Entity<UsergGadeRole>(entity =>
|
{
|
entity.ToTable("usergGadeRoles");
|
|
entity.HasIndex(e => e.SecondUserGadeRolesId, "IX_usergGadeRoles_SecondUserGadeRolesId");
|
|
entity.HasIndex(e => e.UserGadeRolesId, "IX_usergGadeRoles_UserGadeRolesId");
|
|
entity.HasIndex(e => e.UserId, "IX_usergGadeRoles_UserId");
|
|
entity.Property(e => e.Id)
|
.ValueGeneratedNever()
|
.HasColumnName("ID");
|
|
entity.Property(e => e.CreateBy).HasMaxLength(50);
|
|
entity.Property(e => e.UpdateBy).HasMaxLength(50);
|
|
entity.HasOne(d => d.SecondUserGadeRoles)
|
.WithMany(p => p.UsergGadeRoleSecondUserGadeRoles)
|
.HasForeignKey(d => d.SecondUserGadeRolesId);
|
|
entity.HasOne(d => d.UserGadeRoles)
|
.WithMany(p => p.UsergGadeRoleUserGadeRoles)
|
.HasForeignKey(d => d.UserGadeRolesId);
|
});
|
|
OnModelCreatingPartial(modelBuilder);
|
}
|
|
partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
|
}
|
}
|