Entity framework - Invalid Object Name

Question

I have a project where i use EF 4.1.

At Data Context:

 public DbSet<Customer> Customer { get; set; }       
 protected override void OnModelCreating(System.Data.Entity.ModelConfiguration.ModelBuilder modelBuilder)      {            }

Entity model class:

[Table("User",SchemaName="dbo")]
public class User{  
public int Id { get; set; }  
public string FirstName { get; set; }  
public string LastName { get; set; } 
}

Once I run the application I was getting following error.

Invalid object name dbo.User

Why? What is wrong?

Dana Addler · Accepted Answer · 2012-02-20 19:44:16Z

5

What is in your OnModelCreating method?

Try to remove default plural table name:

modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();

answered Feb 20, 2012 at 19:44

Dana Addler

9838 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Brian Lacy · Accepted Answer · 2014-08-06 16:51:19Z

1

If you happen to be using configuration mapping (EntityTypeConfiguration) classes to define your tables, you'll get this error if you forget to attach the Configuration class for the table to the Model Builder.

In my case, it really stumped me for a bit, because I already had another table (SomeThing) working perfectly within this Context class. After simply adding a new table (OtherThing) where everything seemed to be setup identical to the first, I got the error: Invalid object name 'dbo.OtherThings.

The answer was in my Context class:

public DbSet<SomeThing> SomeThings { get; set; }
public DbSet<OtherThing> OtherThings { get; set; }

...

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Configurations.Add(new SomeThingMap());

    // OOPS -- Forgot to add this!!
    modelBuilder.Configurations.Add(new OtherThingMap());
}

For reference, here's my SomeThingMap class:

public class SomeThingMap : EntityTypeConfiguration<SomeThing>
{
    public SomeThingMap()
    {
        ...

        this.ToTable("SomeThing");

        ...
    }
}

And my new OtherThingMap class:

public class OtherThingMap : EntityTypeConfiguration<OtherThing>
{
    public OtherThingMap()
    {
        ...

        this.ToTable("OtherThing");

        ...
    }
}

It's a long shot, but I hope this helps point someone else in the right direction, at least.

answered Aug 6, 2014 at 16:51

Brian Lacy

19.2k11 gold badges57 silver badges73 bronze badges

2 Comments

Bercovici Adrian Over a year ago

I have tried unsuccessfully to use ToTable and also annotations but i still keep getting this error.For more info check my post

Aetos2501 Over a year ago

Add schema name like -> this.ToTable("TableName", "SchemaName")

Collectives™ on Stack Overflow

Entity framework - Invalid Object Name

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related