Update-Database command is not working in ASP.Net Core / Entity Framework 6 because object in database already exists

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

Question

I was updating my database by the command line, but then I manually updated one of my tables.

This seems to have disrupted my ability to update-database. I receive the following error when I try to update: 

 System.Data.SqlClient.SqlException: There is already an object named 'ClientsAndTestimonials' in the database.    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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(TaskCompletionSource`1 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, IReadOnlyDictionary`2 parameterValues, Boolean openConnection, Boolean closeConnection) 
    at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues, Boolean manageConnection) 
    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.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType) 
    at Microsoft.EntityFrameworkCore.Tools.Cli.DatabaseUpdateCommand.<>c__DisplayClass0_0.<Configure>b__0() 
    at Microsoft.Extensions.CommandLineUtils.CommandLineApplication.Execute(String[] args)
    at Microsoft.EntityFrameworkCore.Tools.Cli.Program.Main(String[] args)
 ClientConnectionId:d89989a8-ce8b-4167-be7e-fcddc4bcdf98
 Error Number:2714,State:6,Class:16
 There is already an object named 'ClientsAndTestimonials' in the database.

I have been trying to fix this problem for the past few days. Most fellow developers suggest some variation of using Add-migration "Reset" -IgnoreChanges, like John Salewski from the following link.

However, I keep getting an error that says "A parameter cannot be found that matches parameter name 'IgnoreChanges'".

Any suggestions would be greatly appreciated!

1
8
7/25/2019 6:54:32 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

First, that is not EF 6, it is EF Core. There is no -IgnoreChanges currently in EF Core (see here) but you can achieve the equivalent by commenting out all the code in the Up() method and applying the migration. This will take a snapshot of the current model state so that subsequent migrations will only include changes from that point forward.

So if you just made some incremental model change and you don't have this initial baseline you may need to remove those changes, apply the baseline migration, then add your changes back and add a 2nd migration.

20
4/28/2017 7:31:38 PM

Popular Answer

Use Alter column instead AddColumn in up() function

    migrationBuilder.AlterColumn<bool>(
        name: "IsActive",
        table: "Advertisements",
        nullable: false,
        defaultValue: true);

Or 

      public override void Up()
      {
        AddColumn("dbo.Products", "Description", c => c.String(maxLength: 50));
      }

asp.net migration

You can remark some parts in up function if you dont want to full effect to database.

If your migration command angried for making those. Reset and rebase migration. How: Delete migration content both from visualstudio and sql and add-migration again and update-database

Hamit YILDIRIM

Related Questions

Creating a database with ASP.NET Core RC 2 and Entity Framework core

Yes you can create the database using Entity Framework code first, just like previous versions of ASP.NET. It's a little different though, as you don't use Visual Studio, but rather you open up cmd.exe. Navigate to the project's src folder, then enter the following commands:...dotnet ef migrations add firstMig -c ...DbContextName...This will creat...
asp.net-core entity-framework-core
asked by Mr.Hardy

Entity framework Core with Identity and ASP.NET Core RC2 not creating user in database

Check the result of ..._userManager.createAsync.... ...var result = await _userManager.CreateAsync(user, "P@SSWORD"); if (!result.Succeeded) { // something went wrong, inspect the errors } ...You'll most likely find a required property on your ...IdentityUser... is missing or the password is not valid.
asp.net-core entity-framework-core
asked by Brad

asp.net core/EF-Core mysql update database error

Change your ConfigureServices methode code with:...services.AddDbContext<WebAPIDataContext>(options => options.UseMySQL(Configuration.GetConnectionString("SampleConnection")) ); ...Configuration.GetConnectionString("SampleConnection")... returns the connection string ...server=localhost;userid=root;pwd=root;port=3306;database=asptest;sslmode=no...
asp.net-core asp.net-core-mvc entity-framework-core
asked by Guillaume Sasdy

EF Core: Update-Database command not creating user tables

The solution was eventually simple to resolve for me using Visual Studio 2017, using Microsoft.AspNetCore.All 2.0.5.. I wasn't receiving any error messages I just had to change this in my ...appsettings.json.... I had to change "...Server=(localdb)\\mssqllocaldb;..." to this: "...Server=Localhost;...." Then I ran the command, "...Update-Database..
asp.net-core c# entity-framework-core
asked by Eric Milliot-Martinez

Update-Database command is missing in EF Core

Did you install the ...Microsoft.EntityFrameworkCore.Tools... package?...Install-Package Microsoft.EntityFrameworkCore.Tools Update-Database
.net-core aspnetboilerplate ef-migrations entity-framework entity-framework-core
asked by bricelam

Entity Framework Core - 'Update-Database' not working

The way I could solve the problem was in the following way, in order to understand the solution I placed the name of a fictitious connectionString. it´s solution ...public void ConfigureServices(IServiceCollection services) { services.AddDbContext<AuthenticDBContext>(options => options.UseSqlServer(Configuration.GetConnectionString("Connection...
asp.net-core c# entity-framework-core
asked by Flavio Cortes

Entity Framework Core on Azure: Update-Database parameter –ConnectionString does not work

How can automate database migrations?...EF does not support Automatic migrations..., you may need to manually execute ...Add-Migration... or ...dotnet ef migrations add... for adding migration files. You could explicitly execute the command to apply the migrations, also you could apply migrations in your code....If you want to apply migration ...at...
azure azure-sql-database database-migration entity-framework entity-framework-core
asked by Joey Cai

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

Error: Table 'Table_name' already exists after Update-Database command

By removing your previous migration that creates the table 'Student' EntityFramework now is generating the migration with a Create Table Script, if you want to remove a migration you must revert it from your database aswell. Now you can either recreate your database or revert/delete the 'Students' table on your database.
c# entity-framework entity-framework-core visual-studio
asked by Tiago Silva

Database Schema not changing at Runtime in Asp.net Core 2.2 & Entity Framework Core

I was able to change schema at runtime by changing onConfiguring Method... public class ApplicationDbContext : IdentityDbContext<ApplicationUser> { public string SchemaName { get; set; } public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options) { } public ApplicationDbContext(str...
asp.net asp.net-core asp.net-mvc c# entity-framework-core
asked by Nilesh Gajare

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