==== WORK IN PROGRESS ====

DAL project:

<code>
Install-Package Microsoft.EntityFrameworkCore.Design
Install-Package Microsoft.EntityFrameworkCore.SqlServer # if needed for any MSSQL stuff in your DbContext
</code>

Add Models

Add a DbContext

<code>
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; }
}
</code>

Here's a RemovePluralizingTableNameConvention() that works for .NET Core:

<code>
public static class ModelBuilderExtensions
{
	public static void RemovePluralizingTableNameConvention(this ModelBuilder modelBuilder)
	{
		foreach (IMutableEntityType entity in modelBuilder.Model.GetEntityTypes())
		{
#if (NETSTANDARD2_0 || NETSTANDARD2_1 || NETCOREAPP2_0 || NETCOREAPP2_1 || NETCOREAPP2_2)
			entity.Relational().TableName = entity.DisplayName();
#else // for 3.0 and onwards
			entity.SetTableName(entity.DisplayName());
#endif
		}
	}
}
</code>

=== Update Entity Framework Tools if needed ===
PM> dotnet tool update --global dotnet-ef


=== Create a migration ===
<code>
dotnet ef migrations add InitialCreate --project MyProject.DAL
</code>

=== Update the database ===
<code>
dotnet ef database update --project Mixer.DAL
</code>

Main project:

Add ViewModels
Add Profiles
Add Specifications