EF4 Code First make tables names singular

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.

---

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

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

---

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

链接地址: http://www.djcxy.com/p/90202.html

上一篇: 如何防止EF4动态加载所有程序集

下一篇: EF4代码首先让表名称单数