Entity Framework creates a plural table name, but the view expects a singular table name?

by

So I gave up on trying to do it the way I felt it should be done and removed pluralization all together. I don’t really know for certain, but I assume the problem has to do with the mysql .net connector’s support of EF. Here is what I did.

First, there was a bug in my ApplicationStart method:

//WRONG
//Database.SetInitializer(new DropCreateDatabaseAlways<myDB>());
Database.SetInitializer(new myDBInitializer());

Second, I stopped calling the OnModelCreating base implementation which is not listed in the original code since I only implemented it as per jgauffin’s suggestion:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    //DONT DO THIS ANYMORE
    //base.OnModelCreating(modelBuilder);
    //modelBuilder.Entity<Vote>().ToTable("Votes")
    modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
}

Third, I read in some posts that the MySQL .net Connector doesn’t let EF actually CREATE a database, so I had initially created the blank DB. This seems to no longer be the case with connector 6.4.4+, and as long as your connection string’s user has the ability to create new databases, it works better if one is not existing initially.

Once, I did all of the above, it seemed to work. So now I can at least move forward. Hopefully we can figure out the cause of the plural / singular discrepancy in the future.

Thanks to everyone for their time and effort.

More Related Contents:

  1. EF Including Other Entities (Generic Repository pattern)
  2. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  3. Entity Framework Code First Lazy Loading
  4. Exclude a field/property from the database with Entity Framework 4 & Code-First
  5. EF4 Code First: how to add a relationship without adding a navigation property
  6. Entity Framework Code First naming conventions – back to plural table names?
  7. is there a more efficient way to write this sql code?
  8. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  9. How to connect to MySQL Database?
  10. Entity Framework Stored Procedure Table Value Parameter
  11. How can I automatically filter out soft deleted entities with Entity Framework?
  12. composite key as foreign key
  13. Implementing Zero Or One to Zero Or One relationship in EF Code first by Fluent API
  14. One to one optional relationship using Entity Framework Fluent API
  15. No connection string named ‘MyEntities’ could be found in the application config file
  16. When the same user ID is trying to log in on multiple devices, how do I kill the session on the other device?
  17. The mapping of CLR type to EDM type is ambiguous with EF 6 & 5?
  18. C# with MySQL INSERT parameters
  19. How can I change IIS Express port for a site
  20. CustomAttribute reflects html attribute MVC5
  21. Internal .NET Framework Data Provider error 1025
  22. Navigation Property without Declaring Foreign Key
  23. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  24. Asking for legitimate example of calling stored procedure C#: MYSQL
  25. Creating dynamic queries with entity framework
  26. Using SqlDataAdapter to insert a row
  27. How to add ASP.NET Membership Provider in a Empty MVC 4 Project Template?
  28. How to route EVERYTHING other than Web API to /index.html
  29. The principal end of this association must be explicitly configured using either the relationship fluent API or data annotations
  30. Incorrect string value: ‘\xEF\xBF\xBD’ for column

Leave a Comment