User Tools

Site Tools


Sidebar

Nebol Software Projects:

.NET Class Libraries

Contact info:

johan@nebol.se

nebolcontroller_netcore_mssql_adjustments

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

nebolcontroller_netcore_mssql_adjustments.1627722305.txt.gz · Last modified: 2021/07/31 11:05 by nebol