This is an old revision of the document!
DAL project:
Install-Package Microsoft.EntityFrameworkCore.SqlServer Install-Package Microsoft.EntityFrameworkCore.Design
Add Models
Add a DbContext
public class MixerDbContext : DbContext { public MixerDbContext() { }
public MixerDbContext(DbContextOptions<MixerDbContext> options) : base(options) { }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer(@"server=192.168.1.176;user id=sa;password=!Q2w#E4rqq;database=trader"); }
public static MixerDbContext Create() { var optionsBuilder = new DbContextOptionsBuilder<MixerDbContext>(); optionsBuilder.UseSqlServer(Config.ConnectionString); return (new MixerDbContext(optionsBuilder.Options)); } protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.RemovePluralizingTableNameConvention();
base.OnModelCreating(modelBuilder); } public DbSet<Parent> Parents { get; set; } public DbSet<Child> Children { get; set; } }
Main project:
Add ViewModels Add Profiles Add Specifications