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(Config.ConnectionString);
	}

	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.1627722434.txt.gz · Last modified: 2021/07/31 11:07 by nebol