How do I singularize my tables in EF Code First?

by

You’ve removed the wrong convention (PluralizingEntitySetNameConvention) for this purpose. Just replace your OnModelCreating method with the below and you will be good to go.

using System.Data.Entity.ModelConfiguration.Conventions.Edm.Db;
...
protected override void OnModelCreating(ModelBuilder modelBuilder)
{    
    modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
}

With Entity Framework 6, on your file that inherit from DbContext:

using System.Data.Entity.ModelConfiguration.Conventions;

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
}

More Related Contents:

  1. Code-first vs Model/Database-first [closed]
  2. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  3. Unique Key constraints for multiple columns in Entity Framework
  4. Entity Framework 6 Code first Default value
  5. EntityFramework code-first custom connection string and migrations
  6. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  7. Improve navigation property names when reverse engineering a database
  8. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  9. How do I detach objects in Entity Framework Code First?
  10. EF5 Code First Enums and Lookup Tables
  11. Debug code-first Entity Framework migration codes
  12. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  13. Entity framework code-first null foreign key
  14. Entity Framework loading child collection with sort order
  15. Set decimal(16, 3) for a column in Code First Approach in EF4.3 [duplicate]
  16. How to create index in Entity Framework 6.2 with code first
  17. DbSet.Find method ridiculously slow compared to .SingleOrDefault on ID
  18. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  19. mapping private property entity framework code first [duplicate]
  20. What is the syntax for self referencing foreign keys in EF Code First?
  21. How to create index in Entity Framework 6.2 with fluent configuration
  22. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  23. Mocking or faking DbEntityEntry or creating a new DbEntityEntry
  24. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  25. EF Code First foreign key without navigation property
  26. Entity Framework Code First Using Guid as Identity with another Identity Column
  27. LINQ To Entities + Include + Anonymous type issue
  28. Why does EF5 code first use datetime2 when inserting a nullable datetime into the database?
  29. Can anyone spot why I keep getting this error testing the EF 5 beta
  30. Entity framework code first delete with cascade

Leave a Comment