How to prevent model first from looking for pluralized entity names

Question

I am getting the error invalid object name dbo.JobDefinitions. In my case I know that the issue is that what entity framework is looking for is different than my actual table names (my table name is singular and ef is looking for pluralized).

I'm using a model first edmx style setup. How can I force ef to use the singular name instead, as I don't want to change my tables in the db? The config in modal viewer "Pluralize New Objects" = false does not work.

Answer 1

Hello..

Your OnModelCreating method should be this way..

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

Thanks.

---

Happy Coding, Kishore.

Answer 2

He CLEARLY says model first in his question, the answer is for code first and therefore useless.

---

Joe

Answer 3

Depending upon what version of EF you are using, you can tell EF to not generate the objects with a plural naming convention when using the model first approach on model creation.

Answer 4

This doesn't work in all cases. Not sure why but I have singular table in the DB, mapped to its singular name, I have added the code above to the OnModelCreating and it STILL pluralizes during the read. Maybe this is a bug with EF6?

Answer 5

I get this to. It creates the tables fine, but trying to read from them it tries the plural name.