EF Core 3.0–Conventions

After upgrading to Entity Framework Core 3.0 the extension methods I used to manipulate the naming conventions no longer worked.

The RelationalMetadataExtensions class is gone in EF Core 3.0(next to a whole list of other breaking changes).

To fix it I found the EFCore.NamingConventions plugin which also allows you to set your table and column names to snake_case.

Here is my updated DbContext that uses the .UseSnakeCaseNamingConvention():

	using Crisis.Server.Data.Configurations;
	using Crisis.Server.Domain;
	using Crisis.Server.Domain.DomainServices;
	using Microsoft.EntityFrameworkCore;
	using Microsoft.EntityFrameworkCore.Diagnostics;
	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Text;
	using System.Threading;
	using System.Threading.Tasks;
	namespace Server.Data
	{
	public class SampleContext : DbContext
	{
	private readonly string _connectionString;
	public SampleContext(string connectionString)
	{
	_connectionString = connectionString;
	}
	public SampleContext(DbContextOptions<CrisisContext> options) : base(options)
	{
	}
	protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
	{
	base.OnConfiguring(optionsBuilder);
	optionsBuilder.EnableSensitiveDataLogging();
	if (!string.IsNullOrWhiteSpace(_connectionString))
	optionsBuilder
	.UseNpgsql(_connectionString)
	.UseSnakeCaseNamingConvention();
	}
	}
	}

view raw SampleContext.cs hosted with ❤ by GitHub

More information: https://www.npgsql.org/efcore/modeling/table-column-naming.html