Entity Framework Core RC2 table name pluralization

by

There is no convention for this as of EF RC2 build. This is from EF Core team:

In past pre-release of EF Core, the table name for an entity was the
same as the entity class name. In RC2 we now use the name of the DbSet
property. If no DbSet property is defined for the given entity type,
then the entity class name is used.

Now if you want to revert back to the RC1 naming conventions for tables, you have 3 ways to go with:

1. Choosing Singular Names for DbSet Properties:

One way is to singularize your DbSet property names (which I don’t like). Say for example you have a Book entity and you want to map to a Book table:

public DbSet<Book> Book { get; set; }

2. Using ToTable() Fluent API:

You can of course always use fluent API to override any convention in place and dictate the table name to whatever you want:

modelBuilder.Entity<Book>().ToTable("Book");

3. Writing a Custom Convention:

Just because EF Core RC2 does not have a convention for this, it doesn’t mean we can’t write our own. To do so, first we need to create an extension method on ModelBuilder object:

using Microsoft.EntityFrameworkCore.Metadata.Internal;

public static class ModelBuilderExtensions 
{
    public static void RemovePluralizingTableNameConvention(this ModelBuilder modelBuilder)
    {
        foreach (IMutableEntityType entity in modelBuilder.Model.GetEntityTypes())
        {
            entity.Relational().TableName = entity.DisplayName();
        }
    }
}

And then we simply call it from the OnModelCreating method on our DbContext object:

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.RemovePluralizingTableNameConvention();
}

On Closing:

I don’t like plural table names and I like the last option better than the others and went with that. That said, it’s my personal opinion and other developers might find any of these 3 ways more favorable than the others and choose to go with that 🙂

More Related Contents:

  1. Filtering on Include in EF Core
  2. Raw SQL Query without DbSet – Entity Framework Core
  3. EF Core returns null relations until direct access
  4. Entering keys manually with Entity Framework
  5. Entity Framework Core 2.0.1 Eager Loading on all nested related entities
  6. Dynamically access table in EF Core 2.0
  7. How to mock an async repository with Entity Framework Core
  8. .NET Core 2.1 Identity get all users with their associated roles
  9. Can I reuse code for selecting a custom DTO object for a child property with EF Core?
  10. Map category parent id self referencing table structure to EF Core entity
  11. Command dotnet ef not found
  12. Entity Framework Core Using multiple DbContexts
  13. How to make EF-Core use a Guid instead of String for its ID/Primary key
  14. How to seed in Entity Framework Core 2?
  15. How to auto create database on first run?
  16. In-memory database doesn’t save data
  17. EF Core Mapping EntityTypeConfiguration
  18. How do you show underlying SQL query in EF Core?
  19. Configuring Dbcontext as Transient
  20. EF Core queries all columns in SQL when mapping to object in Select
  21. ASP – Core Migrate EF Core SQL DB on Startup
  22. Entity Framework Core – Lazy Loading
  23. How to refresh an Entity Framework Core DBContext?
  24. How do I delete multiple rows in Entity Framework Core? [duplicate]
  25. Entity Framework Core Many to Many change navigation property names
  26. ef core doesn’t use ASPNETCORE_ENVIRONMENT during update-database
  27. How to load navigation properties on an IdentityUser with UserManager
  28. How to create a password protected database?
  29. Implementing recursive property loading in EF Core
  30. How to resolve .net core build error NETDSDK1061 and warning MSB3277

Leave a Comment