There is already an object named 'AspNetRoles' in the database when trying to update with Entity Framework

asp.net-core c# entity-framework-core

Question

I'm receiving this error with my ApplicationDbContext database when trying to update with Entity Framework. I've googled, tried fixes here on SO, but all to no avail. Currently I'm just deleting my database each time i make a change, but once I deploy, that will not be an option.
Here's the error:

PM> update-database -context applicationdbcontext System.Data.SqlClient.SqlException: There is already an object named 'AspNetRoles' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, String executeMethod, IReadOnlyDictionary2 parameterValues, Boolean closeConnection) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration) at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType) at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_1.<.ctor>b__0() at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action) ClientConnectionId:b2628a7e-7024-471e-9be2-2d0b25f3ad3c Error Number:2714,State:6,Class:16 There is already an object named 'AspNetRoles' in the database.

I have not used context.Database.EnsureCreated() anywhere in my code.

1
6
2/2/2018 10:49:38 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

The fastest solution is:

  • delete migration folder
  • delete database
  • enable-migrations
  • add initial migration
  • update-database
0
7/27/2017 11:39:03 AM

Related Questions

There is already an object named in the database

Update-Database failed from Package Manager Console. I've used Entity Framework 6.x and code-first approach. Error is..."There is already an object named 'AboutUs' in the database."...How can I solve this problem?...internal sealed class Configuration : DbMigrationsConfiguration<Jahan.Blog.Web.Mvc.Models.JahanBlogDbContext> { public Config...
database ef-code-first ef-migrations entity-framework entity-framework-6
asked by Said Roohullah Allem

EF Code First from Database - Already an object in the database

I'm not sure why but in VB.NET the Code First from Database works fine but in C# this does not work correctly for EF6. ...I decide to let C# create the "dbo.__MigrationHistory" and found that this worked great until I added a new class that was the same name as a table in the database.... This caused the following error: ...The model backing the ...
c# entity-framework entity-framework-6
asked by goroth

ef core: There is already an object named in the database

The simplest way is create the one DbContext that will include all sets of entities and relations between them. After that you can separate storage logic with repositories. The hard way is create context-specific migrations for each context. And if you need to add set of entities, that exists in another context - you will need to create an empty mi...
asp.net-core database entity-framework entity-framework-core
asked by R. Bukin

How to recover from Entity Framework nightmare - database already has tables with the same name

I originally wrote this as a self-answering question as I had struggled with the proble for some time, as had a few colleagues, but unfortunately, my answer was deleted and I can't recover it....Since it's a situation that I suspect can happen several times as people try to "clean up" old migrations, I thought I'd document it with step by step inst...
database-migration ef-migrations entity-framework entity-framework-6
asked by System.Exception

Entity Framework Inserts the entity Already Exists in Database

I'm using EF 6 Code-First MVC plus Identity ...I have customized the standard ApplicationUser class defined in Identity framework and when I try to register a new user through my web page, EF tries to insert an entity which is already exists in database. ...//some code above here using (ApplicationDbContext db = new ApplicationDbContext()) { /...
asp.net-mvc c# entity-framework entity-framework-6
asked by user6111463

Add child entities to database and assign them to parent object in database Entity Framework Core

"First of all I don't see where a foreign key is set for the instance of type "DocumentLine"."...Well, then first of all - check that. In the actual database created by EF. You're most probably gonna find an FK on ...DocumentId... in your ...DocumentLines... table....Your ...Document... and ...DocumentLines... are in a 1toMany relationship - a ...D...
c# entity-framework-core xamarin.forms
asked by V0ldek

EF Core There is already an object named 'AspNetRoles' in the database

I am receiving ...There is already an object named ...AspNetRoles... in the database.... error while attempting to use ...update-database... command in NuGet console. ...Context:...public class ApplicationDbContext : IdentityDbContext<IdentityUser> { public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options) { ...
asp.net-core asp.net-identity c# entity-framework entity-framework-core
asked by Storm

Entity Framework DbContext is trying to insert data, that already exists

As you mentioned, that you could change the code of the GetServersAsync method, I expect the DbContext-Call looks similar to this:...return ServerContext.Servers; ...You could change it to:...return ServerContext.Servers.Include(u=>u.User); ...This way, you could skip the error causing code outside, because the User is already populated....The erro...
.net-core asp.net asp.net-core entity-framework-core
asked by Nikolaus

There is already an object named 'xxx' in the database

This error shows up because you probably have migration that includes table, column same like in one of previous migrations. Check every migration if there is no some duplicates. It sometimes happen when you revert your snapshot file. If you want more help with this issue you will need provide more information about your migrations and schema.
ef-migrations entity-framework-core
asked by kyziur

Add or Update child entities when updating a parent entity in Entity Framework Core

Updated the following NuGets from ...2.2.6... to ...3.1.0... and then everything started working normally:...Microsoft.EntityFrameworkCore Microsoft.EntityFrameworkCore.SqlServer Microsoft.EntityFrameworkCore.Tools
c# entity-framework entity-framework-core entity-framework-core-2.2 entity-framework-core-3.1
asked by Ogglas

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow