Adding new column using Update-Database in Entity Framework Core

c# database entity-framework entity-framework-core

Question

May be i'm missing something very obvious. But i haven't been able to figure out a way to add a new column to an existing table/model in EF Core.

This is the documentation that I'm following: https://docs.microsoft.com/en-us/ef/core/miscellaneous/cli/powershell

And this is what i have done so far:

  1. Created migration using this command: "Add-Migration -Name CodingSoldierDbContextMigration -OutputDir Migrations -Context CodingSoldierDbContext"
  2. Updated database using the command: "Update-Database -Migration CodingSoldierDbContextMigration -Context CodingSoldierDbContext". Tables got created in the Database.
  3. Now i need to add a new column to an existing table. I add that column to the model in the .cs file. And i remove the existing migration: "Remove-Migration -Force -Context CodingSoldierDbContext"
  4. Now i re-run the commands in steps 1 and 2. Add-Migration works and migration gets created. But Update-Database fails with the error: "There is already an object named 'AspNetRoles' in the database." which means the table is already present in the database which makes sense.

So how do i update an already existing table table ? 2 ways i can think of are:

  1. Drop the database. Create migration and update database. But all data will be gone.
  2. Add column in the model. Manually update the Table using a SQL script to add the new column.

But i feel there should be a better way to do this.

1
4
10/3/2017 7:03:24 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

This is how i resolved the issue. Not sure if it is the perfect way.

Key is NOT to delete the initial migration, before you create the new migration.

Adding the steps here:

  1. Creating initial migration: "Add-Migration -Name CodingSoldierDbContextMigration -OutputDir Migrations -Context CodingSoldierDbContext"
  2. Updated database using the command: "Update-Database -Migration CodingSoldierDbContextMigration -Context CodingSoldierDbContext". Tables gets created in the Database.
  3. Added new field in one of the models.
  4. Creating updated migration: "Add-Migration -Name CodingSoldierDbContextMigrationUpdated -OutputDir Migrations -Context CodingSoldierDbContext". This migration will have code only for updating the existing table.
  5. Updating DB with the updated migration: "Update-Database -Migration CodingSoldierDbContextMigrationUpdated". Ideally this should have resolved it. But for me, it gave error because(as from Verbose logs) it was trying to update with initial migration: "CodingSoldierDbContextMigration", i don't know why.
  6. So i generate scripts using Script-Migration: "Script-Migration -From CodingSoldierDbContextMigration -Idempotent -Output C:\MigrationScript.sql -Context CodingSoldierDbContext". It generated the script which had changes only from the updated migration. Running that script in DB created the column and added the migration entry in "__EFMigrationsHistory" table.
3
10/3/2017 10:12:07 AM

Related Questions

How to add new entity properties in Entity Framework without changing database model

A better approach...Although this can be easily done with Entity Framework, but as pointed out by other answers here, and I acknowledge 100%, that it is better to separate presentation/UI models from database models by creating ViewModel separate from your regular entities and put your calculated properties there....If you are stuck with EF, keep r...
asp.net-mvc c# entity-framework entity-framework-6
asked by Bishoy

Entity Framework Core 1.1 In Memory Database fails adding new entities

I am using the following code in a unit test for the test setup:...var simpleEntity = new SimpleEntity(); var complexEntity = new ComplexEntity { JoinEntity1List = new List<JoinEntity1> { new JoinEntity1 { JoinEntity2List = new List<JoinEntity2> { new JoinEntity2 { ...
entity-framework-core
asked by Tobias Bengtsson

How update entity after adding new entity in EF Core

You are using EF Core like when you write raw SQL queries, which kind of beats many of the advantages of an ORM....You don't need the ...ClientId... for ...ClientSecrets..., because EF Core can figure out the relations itself....var newClient = new Client { ClientName = client.ClientName, ClientId = client.ClientId, ClientSecrets = secr...
asp.net-core c# entity-framework entity-framework-core
asked by Tseng

EF Core - adding/updating entity and adding/updating/removing child entities in one request

Use this generic sub to mark the child state, easy to use...Notes:...PromatCon: the entity object...amList: is the child list that you want to add or modify...rList: is the child list that you want to remove...updatechild(objCas.ECC_Decision, PromatCon.ECC_Decision.Where(c => c.rid == objCas.rid & !objCas.ECC_Decision.Select(x => x.dcid).Contains(c...
asp.net-core aspnetboilerplate c# entity-framework entity-framework-core
asked by Basil

How to add new Scope in ClientScopes table using IdentityServer4 with Entity Framework Core

I have configured IdentityServer4 for an authentication with Entity Framework Core in my application and have also added a few clients. I tried to add a new scope for any client in ...ClientScopes... table. I was not able to add it from code level and also ...ClientScopes... table does not exist in ...ConfigurationDbContext.......using System; usin...
c# entity-framework-core identityserver4 openid-connect
asked by Parthi

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

I have a datamodel named "Document" which looks like this:...public class Document { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } //[ForeignKey("Id")] public List<DocumentLine> Lines { get; set; } public DateTime PurchaseDate { get; set; } public double TotalValue { get; set; } } ...It...
c# entity-framework-core xamarin.forms
asked by N.iw

Create new database using Entity Framework Core, npgsql, PostgreSQL

Newb here sorry. I'm reading up Entity Framework Core, npgsql and PostgreSQL (new to all of these things!!) Can someone please very kindly explain or point me where to read: I am trying to create a brand new database using code....From the things I have read, I am creating the DB using pgadmin or script directly. What I want to do is create a dat...
.net-core c# entity-framework-core npgsql postgresql
asked by PKCS12

How to update Entity Framework Core after adding a new table to the database

https://docs.microsoft.com/en-us/ef/core/get-started/aspnetcore/existing-db?toc=/aspnet/core/toc.json&bc=/aspnet/core/breadcrumb/toc.json&view=aspnetcore-2.2...I have followed this instruction above and it works. I have the database and the C# code....The next phase is that I add a new table named test ...Table: test ...Columns: Testid (int), tes...
c# entity-framework-core sql-server
asked by What'sUP

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

In a new project we are using Entity Framework Core instead of EntityFramework 6.2.0. Works good but it causes a problem when updating a parents children while also inserting new children....Example:...Current model:...public class Profile { public Profile() { Interests = new List<Interest>(); } [Key] [DatabaseGenerate...
c# entity-framework entity-framework-core entity-framework-core-2.2 entity-framework-core-3.1
asked by Ogglas

DateTime property causing new migration update even without any update on model in Entity Framework core

In entity framework, if I run the command "...add-migration <name>..." in package manager console, each and every time it creates migration with some update commands for the property datetime....Model:...public class TestDetailBase { public string TestTitle { get; set; } public int TotalTimeinMinutes { get; set; } public...
c# entity-framework entity-framework-core
asked by Bimal Das

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