EF5 default table name convention causes 'Invalid object name' exception

Question

I have a model with several entities in my MVC4 project with VS 2012. Recently I added a view to my DB named 'vwTeacherNames' and I tried to update the model and I unchecked the Plorizing option for that update.

Then, I rename my entity to 'TeacherName'. Now when I tun the Prj, this exception is thrown where I define a DropDownList for teachers:

Invalid object name 'dbo.TeacherNames'.

I tried many ways such as using custom tool, removing the .tt files and generating the again, ... However the problem stays firm!

So, how can I tell the EF the right table(in fact view) name which is vwTeacherNames?

Thanks a lot

Amin Saqi · Accepted Answer · 2013-06-04 07:33:29Z

Found it! and I add it here with some more tweaks:

public class myDbContext : DbContext
{
    public PtDbContext()
        : base("DefaultConnection")
    {

    }

    ... //some entities

    //Here it is:

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<TeacherName>().Property(t => t.FullName)
            .HasColumnName("TeacherName");

        modelBuilder.Entity<TeacherName>().ToTable("vwTeacherNames", schemaName: "dbo");                        

    }
}

Update: Why waisting your time by defining what you previously defined?! Just kill the default table naming convention and enjoy progressing your Prj:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        //Adding this line tells the EF not to go through that convention
        modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();               
    }

So, It should builds up your queries by EntitySetName and EntityName properties of your entities which the first of is the DB table name and the second is your entity name which you use in your DbContext.

Collectives™ on Stack Overflow

EF5 default table name convention causes 'Invalid object name' exception

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related