Add-Migration works, but Update-Database says "no migrations to update". I tried deleting the Mig.. Folder

John Murphy 25

Visual Studio and EF Core problem. Migrations don't work. Add-Migration Title works to update the schema, but Update-Database in NuGet Command Console says that the db is already up to date, but the db does not have my new table in it.

I tried deleting the Migrations folder in the project. Have not tried to delete the Migrations History Table in the db for fear that if I can't update the db, then I would not be able to get a new

Migrations History table by the same token.

John

1 answer

Jack J Jun 24,486 Reputation points Microsoft Vendor

2024-01-01T03:09:46.6466667+00:00

@John Murphy, Welcome to Microsoft Q&A,

Based on your description, you meet an error when you use the Update-Database to add table to database.

I recommend that you keep Migrations folder and delete all the migration files. Then you could run the command Add-Migration InitialCreate. Last you could run the Update-Database again.

Please feel free to let me know if you have any questions.

Best Regards,

Jack

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
John Murphy 25 Reputation points

2024-01-02T01:45:31.5333333+00:00

It seems that Update-Database throws the error at the bottom here whenever there exists a migrations folder within the Solution Explorer. The program runs without error only if there is one migration folder in the folder view. But, again if I add even so much as a Migrations folder in the solution explorer without files within it, it seems to get confused and think that it is duplicating the database. That Migrations folder containing the initial create migration and the snapshot appear in the solution explorer upon Update-Database while throwing the error below. The error is thrown on the line of code

`await context.Database.MigrateAsync();`

in my Program.cs file.

If I delete the above code in the Program.cs then it won't throw an error but it still will not migrate or update the database with the below error.

Failed executing DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] CREATE TABLE [AspNetRoles] ( [Id] nvarchar(450) NOT NULL, [Name] nvarchar(256) NULL, [NormalizedName] nvarchar(256) NULL, [ConcurrencyStamp] nvarchar(max) NULL, CONSTRAINT [PK_AspNetRoles] PRIMARY KEY ([Id]) ); It says it already has the AspRoles Table in the error too, I paraphrase here

Jack J Jun 24,486 Reputation points Microsoft Vendor

2024-01-02T02:17:17.3166667+00:00

@John Murphy, thanks for the feedback,

The program runs without error only if there is one migration folder in the folder view.

Yes, it is correct. As usual, a project often contains only one Migration Folder.

It seems that you did not follow the advice I mentioned in the answer. Could you have a try?

keep Migrations folder and delete all the migration files. Then you could run the command Add-Migration InitialCreate. Last you could run the Update-Database again.

John Murphy 25 Reputation points

2024-01-03T04:29:14.8966667+00:00

Jack,

Right now there is one migrations folder in the folder view with nothing in it. Run the program, fine. Then do Add-Migration InitialCreate then Update-Database, it give above error in the output window then fine but running update-database puts a migration folder into the folder view. It runs fine but I am not updated for the additional table that I made a data model for, and that I updated my context for.

Jack J Jun 24,486 Reputation points Microsoft Vendor

2024-01-03T06:05:08.78+00:00

@John Murphy, to better analyze your problem, provide the model class before the update and the model class after the update? If you make some changes on dbcontext, please also provide it. I will make a test to check if I could reproduce your problem if I get the above information.

Thanks for your understanding.

John Murphy 25 Reputation points

2024-01-03T14:53:39.15+00:00

Context before:

using System; using System.Collections.Generic; using System.Text; using Microsoft.AspNetCore.Identity.EntityFrameworkCore; using Microsoft.EntityFrameworkCore; using CommunityPricing.Models; using CommunityPricing.Areas.Data; namespace CommunityPricing.Data { public class CommunityPricingContext : IdentityDbContext<ApplicationUser> { public CommunityPricingContext(DbContextOptions<CommunityPricingContext> options) : base(options) { } public DbSet<CommunityPricing.Models.ProductCategory> ProductCategory { get; set; } public DbSet<CommunityPricing.Models.Product> Product { get; set; } public DbSet<CommunityPricing.Models.Vendor> Vendor { get; set; } public DbSet<CommunityPricing.Models.Offering> Offering { get; set; } public DbSet<CommunityPricing.Models.ArchivedOffering> ArchivedOffering { get; set; } } }

The models that existed before I made the model in question:

Model and Context after:

using Microsoft.AspNetCore.Identity.EntityFrameworkCore; using Microsoft.EntityFrameworkCore; using CommunityPricing.Models; namespace CommunityPricing.Data { public class CommunityPricingContext : IdentityDbContext { public CommunityPricingContext(DbContextOptions<CommunityPricingContext> options) : base(options) { } public DbSet<CommunityPricing.Models.ProductCategory> ProductCategory { get; set; } public DbSet<CommunityPricing.Models.Product> Product { get; set; } public DbSet<CommunityPricing.Models.Vendor> Vendor { get; set; } public DbSet<CommunityPricing.Models.Offering> Offering { get; set; } public DbSet<CommunityPricing.Models.ArchivedOffering> ArchivedOffering { get; set; } public DbSet<CommunityPricing.Models.ConstantsBusinessReference> ConstantsBusinessReference { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); modelBuilder.Entity<Product>().ToTable("Product"); modelBuilder.Entity<ArchivedOffering>().ToTable("ArchivedOffering"); modelBuilder.Entity<Offering>().ToTable("Offering"); modelBuilder.Entity<ProductCategory>().ToTable("ProductCategory"); modelBuilder.Entity<Vendor>().ToTable("Vendor"); modelBuilder.Entity<ConstantsBusinessReference>().ToTable("ConstantsBusinessReference"); // Customize the ASP.NET Identity model and override the defaults if needed. // For example, you can rename the ASP.NET Identity table names and more. // Add your customizations after calling base.OnModelCreating(builder); } } }

using CommunityPricing.Areas.Models.HelperModels; using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace CommunityPricing.Models { public class ConstantsBusinessReference { [Key] [Display(Name = "Reference ID")] public int ID { get; set; } [Display(Name = "Economic Statistic")] public string Classification { get; set; } [Display(Name = "Detailed Statistic")] public string SubClassification { get; set; } [Display(Name = "Date")] [DataType(DataType.Date)] [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}")] public DateTime EndDate { get; set; } [Display(Name = "Duration")] public TimeSpan Duration { get; set; } [Display(Name = "% Rate or Quantity")] [Column(TypeName = "decimal(18,2)")] public double Figure { get; set; } [Display(Name = "Source")] [StringLength(maximumLength: 30)] public string SourceName { get; set; } [Display(Name = "Notes")] [DisplayFormat(ConvertEmptyStringToNull = true, NullDisplayText = "")] public string Notes { get; set; } } }

John Murphy 25 Reputation points

2024-01-04T03:45:35.74+00:00

Jack, I provided the additional information in the answer section.

Migration has my new class model in the Snapshot, but Update-Database doesn't update the database with that table. It always thinks that it is duplicating tables that are already there. ...I even tried to comment out the "OnModelCreating" section in the context. Did not matter.

Jack J Jun 24,486 Reputation points Microsoft Vendor

2024-01-05T01:20:16.5766667+00:00

@John Murphy, it seems that you did not provide the model class before the update? Or did you use the same model class for them? If you only add the OnModelCreating method, there is no need to use migrations. If you used dbcontext instance, it will automactically call the OnModelCreating method.

John Murphy 25 Reputation points

2024-01-06T01:55:45.97+00:00

The model class for that new model in question is ConstantsBusinessReference.cs.

That class is the same both before and after the update-database. We may be doing migrations differently here. For me, I make the class, as above, then build, then run add-migration in the nuget console, then update-database there as well. That's all. I wouldn't have saved the model class right at the point after I made it and right before I ran add-migration, then update-database? Am I missing something. So as for a before snap of the model class, it is exactly the same as the after.

As for the OnModelCreating, I didn't know that that is a substitute for running a migration. How would I do that, or more precise question is where would I run that from.

For your last sentence, I'm not sure how to "use dbcontext instance" but I think of that as just how .NET runs makes the tables when things are working fine (unlike my situation), sure it makes the tables on its own.

Mea culpa, I did do a scaffold of the ConstantsBusinessReference for all CRUD functions before running migrations and database

John

John Murphy 25 Reputation points

2024-01-07T03:28:08.5566667+00:00

Jack, let me know if you can go on the information that we have so far. I don't have any more than that so far

Thanks

John

John Murphy 25 Reputation points

2024-01-08T00:34:50.48+00:00

Oh right it was a new model class, not a change to a model, so right, again it there was no model class before.

Jack J Jun 24,486 Reputation points Microsoft Vendor

2024-01-09T03:04:00.44+00:00

@John Murphy, Sorry for the late response, based on your all description, I think that your database already has a table before you update the schema. I recommend that you could change a new database to make a test to do the code first to check if it works for you.

John Murphy 25 Reputation points

2024-01-10T14:10:01.5633333+00:00

Could you show me how to make a new database from an existing visual studio project without harming the database that already exists with that project. Can a project have two databases?

Jack J Jun 24,486 Reputation points Microsoft Vendor

2024-01-16T08:05:11.6466667+00:00

@John Murphy, you could just change the connection string to another database. I recommend that you could use a new project to test for it.

John Murphy 25 Reputation points

2024-01-27T03:06:48.25+00:00

After a long time, Can I ask you, if I start over, new project, new database, copy all of the code from old project, publish, Can I drag and copy and paste all of the data in that database on Azure over? So can I just highlight 50 or 100 lines of data and plop it over onto the new db from the old one??

John Murphy 25 Reputation points

2024-03-31T03:02:11.36+00:00

Hi Jack,

Long time. I took your advice and beyond. I made a whole new project with a new db.

There was no winning with the other one. If you could address my new snag, that would be great. One of my data models looks like this:

public class ProductCategory { [Display(Name = "Category Number")] [DatabaseGenerated(DatabaseGeneratedOption.None)] public int ProductCategoryID { get; set; } [StringLength(50, MinimumLength = 3)] [Display(Name = "Category Name")] public string? Name { get; set; } [Timestamp] public byte[] ConcurrencyToken { get; set; } public ICollection<Product>? Product { get; set; } }

This code:

if (!ModelState.IsValid) { Message = ModelState.Values.SelectMany(v => v.Errors).ToString(); return Page(); }

gives this error message:

System.Linq.Enumerable+SelectManySingleSelectorIterator`2[Microsoft.AspNetCore.Mvc.ModelBinding.ModelStateEntry,Microsoft.AspNetCore.Mvc.ModelBinding.ModelError]

when I try to Create an instance of this entity. And it won't create anything.

Thanks, John

John Murphy 25 Reputation points

2024-03-31T03:03:25.3133333+00:00

The above is that the data model is invalid, of course
Sign in to comment

Share via

Add-Migration works, but Update-Database says "no migrations to update". I tried deleting the Mig.. Folder

1 answer