EF Code First: Need to update column length and data on production server

asp.net-core ef-migrations entity-framework-core

Question

We have an ASP.NET MVC Core app created with Code First approach - using SQL Server 2012. The app is already running in production where we need to change the length of a column from varchar(25) to varchar(30). The approach we've used to make the above change is as follows. This approach seems long-winded. Question: Is there a better and faster way of doing it? We're using ASP.NET Core 1.1.1 with VS2017

Our Approach [so far]:

A. On Developer machine, change the corresponding Model as:

[Column(TypeName = "varchar(30)")]
public string ColumnName { get; set; }

B. Run PM> Add-Migration ... and PM> Update-Database ... commands in Package Manager console of VS2017

C. Re-load the data to the corresponding table with changed column length

D. Re-deploy the database to production.

E. Re-deploy the project to production.

1
2
9/25/2017 6:19:53 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

It "migration time" (actual/real time required by RDBS to execute DDL and update whole production database) is not very big (you agree to take your app offline for this time, and you don't expect "command timeout") than you may run migrations during app startup:

public void Configure(IApplicationBuilder app)
{
    // your current app.UseXxx() calls

    using (var tempScope = app.ApplicationServices.GetRequiredService<IServiceScopeFactory>().CreateScope())
    {
        var db = tempScope.ServiceProvider.GetService<YourDbContext>();
        db.Database.Migrate();
    }
}
0
9/27/2017 12:34:28 PM

Related Questions

How to update model working with EF code first with 'Code First from Database'

One more option is just delete the auto generated classes from the project and once again generate them. While following this approach only thing we need to make sure that is, we should give the same name for the data model(class name which inherits from DbContext ) as the previous one.Data model name is highlighted in below snap.
.net c# ef-code-first entity-framework entity-framework-6
asked by Rajesh Pawde

How to create Multiple one-to-one relationships in EF Code first?

Third Edit: Changed plenty of my code at the end of the question, left the original just in case that was the way to go.......I'm having a problem understanding how to work with multiple one-to-one relationships in EF. I already had made a one-to-one relationship between two models, but when I tried to add another model one-to-one relationship to t...
asp.net-mvc c# ef-code-first entity-framework entity-framework-6
asked by Jorge Díaz

EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship

I'm attempting to do the following:...public class class1 { public int Id {get;set;} [ForeignKey("Class2")] public int Class2Id {get;set;} public virtual Class2 Class2 {get;set;} } public class class2 { public int Id { get; set;} [Required] public virtual int Class1Id {get;set;} [Required] [ForeignKey("Class1Id"...
c# database ef-code-first entity-framework entity-framework-6
asked by JensOlsen112

EF 6 - Code first invalid one-to-one foreign key relationship

DESIGN BACKGROUND...:...I'm trying to create code-first EF6 mappings for the following database structure:...The database design is as follow: Instead of having "CustomerID" as foreign key on all related entities (Employment, expenses, income, etc...), we have a CustomerRelationship table, which will contain the CustomerID, and then a "RelatedID" c...
c# ef-code-first entity-framework entity-framework-6
asked by FaNIX

Change SQL Server database alphabetic column ordering in Entity Framework code-first to sequential

I need to turn off alphabetic ordering in code first....Here is my class simplified...public class Person { [Key,Column("PersonId")] public int Id { get; set; } [MaxLength(50)] public string PersonName{ get; set; } public DateTime? JoinDate{ get; set; } public int? Gender{ get; set; } } ...and when I run the commands to gene...
entity-framework-core
asked by zoaz

Entity Framework 6 Code First VarBinary Length in mapping or computed column

I see it is possible to use a query to find a length of a varbinary field in a query....Entity framework and VARBINARY...But can you map a FileSize property to get the size of a varbinary in the Fluent API without having to write queries?...I want to be able to store some file information in SQL Server. This data is a filename, file contents. Thi...
code-first ef-fluent-api entity-framework entity-framework-6 sql-server
asked by Andez

One to One Relationship with Different Primary Key in EF 6.1 Code First

I am having an issue getting a reference to the employee object from the PayGroup object using Entity Framework 6.1. I have a foreign key in the database on PayGroup.SupervisorId -> Employee.EmployeeId. Note that this is a zero or one-to-one relationship (a pay group can only have one supervisor and an employee can only be the supervisor of one pay...
c# ef-fluent-api entity-framework entity-framework-6 sql-server
asked by Brian Swart

What is the difference between EF Core Database-First and EF Core Code-First approaches?

I was wondering... since there is no EDMX in EF Core, what is the difference between those 2? And if the major difference would be the possibility to change the database tables, why not use code first then use EF code-first migrations?
asp.net-core ef-code-first ef-database-first entity-framework-core
asked by shade1337

EF Can't update one-to-zero or one relationship fields, but updates the rest

Am trying to make an update on the database with one-to-one relationship models, but only the ...Student...model... fields are the only ones working. How can I make the rest update too?...This is my ...Repository... method for updating :... public void Edit(Student student) { var existingStudent = _context.Students ...
asp.net-core c# entity-framework-core
asked by Idris Stack

EF Core Update updates all columns even though only one has changed

I'm kind of new to using EF Core. It was my understanding that EF Core has a "Change Tracker" that looks at the data to see what columns have been modified and builds a SQL UPDATE statement that only updates the modified columns, as described in an answer here:...Does EF core compares value to include columns in update statement?...However, that is...
c# entity-framework-core
asked by JoeD

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