Demo Project Database Initialization Issue #6475

sunflowerlab created 5 years ago

I downlaoded the ASP.NET MVC & Jquery demo Project.

Is there any difference between Demo and Real project? I downloaded the demo project and ran the Migrator tool. It created the database but didn't load the default data. All tables are blank. I deleted the database and project. Extracted the project again and executed the command "Update-Database" from NuGet package console for EntityFramework. I am getting the following error. **I creates the database but deosn't add any initial data. **

Unable to update database to match the current model because there are pending changes and automatic migration is disabled. Either write the pending model changes to a code-based migration or enable automatic migration. Set DbMigrationsConfiguration.AutomaticMigrationsEnabled to true to enable automatic migration. You can use the Add-Migration command to write the pending model changes to a code-based migration.

Also gets following warning.

_Applying explicit migration: 201505162037045RenamedBinaryObjectTable. Caution: Changing any part of an object name could break scripts and stored procedures. Caution: Changing any part of an object name could break scripts and stored procedures. Applying explicit migration: 201506061210411AddedAuthenticationSourceToUser.

_Warning! The maximum key length is 900 bytes. The index 'IXNotificationNameEntityTypeNameEntityIdUserId' has maximum length of 1032 bytes. For some combination of large values, the insert/update operation will fail.

Caution: Changing any part of an object name could break scripts and stored procedures

I haven't changed anything in the code except the connection string on a web project.

5 Answer(s)