Add column to table in C# & Entity Framework code-first without deleting DB content

Question

I have a database with several tables in AZURE SQL Server.

I want to add a new column to one of the tables, but I want to keep all the content of the tables including the table with the new column; hence I don't want to use the

Database.SetInitializer<MyDbContext>(new DropCreateDatabaseIfModelChanges<MyDbContext>());

My code looks like this:

public class DBTables : DbContext
{
    public DBTables() : base(ProductKeys.GetDbKey()) 
    {
    }

    public DbSet<ElementsForPointTable> ElementsForPointTable { get; set; }
    public DbSet<StationsDetailsTable> StationsDetailsTable { get; set; }
}

How do I do it?

What's the issue with normal Add-Migration and Update-Database through package console? — Hassan
– Hassan, Commented Aug 19, 2017 at 12:50

Ivan R. · Accepted Answer · 2021-05-28 09:24:24Z

1

You could use migrations to update the database scheme.

Open Package Manager Console (Tools -> Library Package Manager -> Package Manager Console)
Run Enable-Migrations command
Change your model
Run Add-Migration command in Package Manager Console.
Run Update-Database command to apply your model changes to the database.

edited May 28, 2021 at 9:24

answered Aug 19, 2017 at 12:52

Ivan R.

1,9151 gold badge13 silver badges13 bronze badges

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

3 Comments

asaf Over a year ago

But i am connecting the db name dynamically so how does the migration tools knows to what db to migrate to ? I have attached my code sample above

Jephren Naicker Over a year ago

By your connection string in your Web.config

brinch Over a year ago

Suppose bullet number 2 should be Enable-Migrations (with an s)

Collectives™ on Stack Overflow

Add column to table in C# & Entity Framework code-first without deleting DB content

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related