EF4 Code First make tables names singular

Question

I'm using standards for singular table names. EF4 Code First has by default to pluralize table names. I have put the code to override this convention, but seems is not working.

using section:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
using System.Data.Entity;
using System.Data.Entity.Database;
using System.Data.Entity.ModelConfiguration;
using System.Data.Entity.ModelConfiguration.Conventions.Edm;

Data context:

public class SiteDataContext : DbContext
    {
        public DbSet<Blog> Blogs { get; set; }
        public DbSet<BlogFeedback> BlogFeedbacks { get; set; }
        public DbSet<BlogCategory> BlogCategories { get; set; }

        // Twist our database
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Conventions.Remove<PluralizingEntitySetNameConvention>();
            base.OnModelCreating(modelBuilder);
        }
    }

Tables created:

• Blogs
• BlogFeedbacks
• BlogCategories

When because the convention override (and what I need) should be:

• Blog
• BlogFeedback
• BlogCategory

Anyone has an idea why the override line is not working? Thanks a lot.

Perni

Answer 1

Your using the wrong convention. You need to do the below.

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

Selfpropelled

That was a good one! You are right, I changed and now is working! Thanks a lot. – Perni

Note that in EF5 the parameter type is DbModelBuilder – Greenwell

+1: Useful, pointed me in the right direction. -1: Incomplete: System.Data.Entity.ModelConfiguration.Conventions.PluralizingTableNameConvention – Sarcomatosis

Answer 2

I our current project we had the same problem. I wrote about it in another question, but here it is:

Entity Framework v4 and underscores in column names

It's a little more complex than expected.

HTH

Maccabean