Unable to generate an explicit migration in entity framework

Lokesh K

Hi,

i am adding new migration but this message keep showing not able to move to next step

Unable to generate an explicit migration because the following explicit migrations are pending: [201503301347224_Init, 201511241650256_Add_RecycledItemId_To_SharePointIds, 201512151527077_LastDeletedDate, 201609051444513_ManagedProperty, 201609260953212_UsageStatistics, 201610231729560_Formats, 201611151545173_TargetRepository, 201611151621518_OptDocAndRepoRelWithTgtRep, 201611171020118_MandatoryAndOptional, 201612141136540_ObjectId]. Apply the pending explicit migrations before attempting to generate a new explicit migration.

Can anyone help me in this regards

Lokesh K.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Lokesh K9y ago
Hi Nilesh,
some how did like below. it works for me and 100% it will work for others also.

Actually my db is located in local machine each time when i run the application i will generate the new db file.

without changing the data model i run the application, i stopped the application after database gets created.

Now i changed the data model as i expected to create new column in my table

So.. when i run this command
Add-Migartion -Name MigrationName -StartupProjectName ProjectName

it was showing the same error as initial my post.
Unable to generate an explicit migration because the following explicit migrations are pending: [201503301347224_Init, 201511241650256_Add_RecycledItemId_To_SharePointIds, 201512151527077_LastDeletedDate, 201609051444513_ManagedProperty, 201609260953212_UsageStatistics, 201610231729560_Formats, 201611151545173_TargetRepository, 201611151621518_OptDocAndRepoRelWithTgtRep, 201611171020118_MandatoryAndOptional, 201612141136540_ObjectId]. Apply the pending explicit migrations before attempting to generate a new explicit migration.

Even if i run the command like
Update-Database -Verbose
this error shows
An unexpected error occurred while checking the sector size for file 'H:\Source\Repos\Api\App_Data\IntegrationTestDatabase.mdf'. Move the file to a local NTFS volume, where the sector size can be retrieved. Check the SQL Server error log for more information.

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
here what actually the problem is.. when i run these two commands(Add-Migration/Update-Database) by default my entity framework looks for database in project folder. but i configured my Db to create in different disk.

finally the soluation is:
change the AttachDbFileName(where your local db.mdf file is created) path in web.config.cs file like below

name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=D:\USERS\USERNAME\DOCUMENTS\TestDatabase\testdb.mdf;Initial Catalog=testdb;Integrated Security=True" providerName="System.Data.SqlClient" />

if we configure like this entity framework will search the db file in specified path.
now,
Add-Migration -Name MigrationName - StartUpProjectName ProjectName
after completion of migration
Update-Database -Verbose
Specifying the '-Verbose' flag to view the SQL statements being applied to the target database

100% it will work

With Best,
Lokesh K.
0
Nilesh Shah9y ago
Yes I know this is a headache in EF, I faced it many times.

How big is your DB? Can you afford to have it rebuilt from scratch?

If yes, first take DB bakup, then delete it,

first of all run Update-Database, once it runs successfully then only add any new or pending migration.

If no, try to add a dummy migration without anything into it. It may stabilize EF, then try update-database
0
Lokesh K9y ago
Hi Nilesh,
i tried all the commends in
PM> Add-Migration AddColumn and
PM>Update-Database

but still the problem persist.

Regards,
Lokesh K.
0
Nilesh Shah9y ago
Please update your database to current state first, only then new migration will be allowed to be created

Go to package manager console, select the Entoty Framework Project and run:
Update-Database
0