On insert, DapperExtensions returns "Invalid object name."

SqlException (0x80131904): 'dbo.Categories' is an invalid object name.

Try using model builder class.It is the way to configure or explicitly define the mapping between table and model class....In your entity/context class try adding this code...protected override void OnModelCreating(DbModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); modelBuilder.Entity<Category>().ToTable("Category"...

Entity Framework raises an exception: 'dbo.BaseCs' is an invalid object name.

It is most likely a mismatch between the model class name and the table name as mentioned by 'adrift'. Make these the same or use the example below for when you want to keep the model class name different from the table name (that I did for OAuthMembership). Note that the model class name is OAuthMembership whereas the table name is webpages_OAuthM...

When receiving data from a created table, the object name 'dbo.TableName' is invalid.

Ok, for me issue was that I had a table called ...dbo.UserState... and in C# EF was trying to access ...dbo.UserStates... because of pluralization. ...The solution was to put ...Table... attribute above class and specify the exact table name:...[Table("UserState")] public class UserState { [Key] public int UserId { get; set; } }

Why am I getting this "Invalid object name 'dbo.*'" error with MVC4?

I get this error:...Invalid object name 'dbo.ImageMetas'....On this line:...return View(db.Images.ToList());...Where my database context looks like this:...public class GalleryContext : DbContext { public GalleryContext() : base("DefaultConnection") { } public DbSet<ImageMeta> Images { get; set; } public DbSet<ImageFile...

Invalid object name 'dbo.EdmMetadata' and 'dbo.__MigrationHistory'

I am using Entity Framework 5 and doing a simple query to get a few users from a table....The SQL database is already created so I use my entities as a way to map what I have....When I run my query I detect that other queries were executed and 2 of them with errors:...QUERY 1...ERROR: Invalid object name 'dbo.__MigrationHistory'....SELECT [GroupBy1...

EF6 Code First Pluralizing Tables Invalid Object Name

EF6 is pluralizing my Code First table names no matter what I do. I am getting the error that it can't find the pluralized table {"Invalid object name 'dbo.TestStats'."}. The table is singular in the DB as dbo.TestStat...I tried removing the convention by ...protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBui...

Invalid object name 'dbo.__MigrationHistory' using Database.Create; EF6.02 when connection string is passed in

You can turn off code first database initialization for your database, by adding this to your context's constructor:...Database.SetInitializer<YourContext>(null); ...This should prevent the attempt to access ...dbo.__MigrationHistory....

Invalid object name 'dbo.AspNetUsers' in Asp.NET MVC 5 Entity Framework

In Visual Studio go to "Tools -> NuGet Package Manager -> Package Manager Console" and in console window (inside Visual Studio) execute "Update-Database" command

System.Data.SqlClient.SqlException: Invalid object name 'dbo.Slider'

I'm developing an ...asp.NET... application using ...Entity Framework... and I'm getting the following exception whenever I try to create a record in my ...dbo.Slider... table:...System.Data.Entity.Infrastructure.DbUpdateException:... An error occurred while updating the entries.... See the inner exception for details. --->... System.Data.Ent...

System.Data.SqlClient.SqlException: Invalid object name 'dbo.__TransactionHistory'

I get the error ..."System.Data.SqlClient.SqlException: Invalid object name 'dbo.__TransactionHistory'."...when I try creating a ...new dbcontext... using the ...TransactionContext... in EF 6.1.3. It seems like a bug where it's using the transactioncontext API before the ...DBMigrator/Initializer... even has a chance to create it since these oper...