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 MyDbContext : DbContext
{
	public MyDbContext()
	{
	}

	public MyDbContext(DbContextOptions<MyDbContext> options) : base(options)
	{
	}

	protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
	{
		optionsBuilder.UseSqlServer(Config.ConnectionString);
	}

	public static MyDbContext Create()
	{
		var optionsBuilder = new DbContextOptionsBuilder<MyDbContext>();
		optionsBuilder.UseSqlServer(Config.ConnectionString);
		return (new MyDbContext(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.1627722486.txt.gz · Last modified: 2021/07/31 11:08 by nebol