I am currently attempting to switch from Entity Framework Automatic Migrations to Code-First Migrations. For a little backstory, this solution is split into four seperate projects: Data, Models, Services, and Web. The connection string information is located in the Web project, and the context is located in the data project.
Now, I have ran "Enable-Migrations", and that appears to have worked correctly.
From there, I delete the existing migrationHistory table in the database.
Running "Add-Migration -projectName Data" will generate an appropriate migration.
The Problem is when I attempt to run Update-Database, it results in a generic error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I can connect to the database using the credentials supplied in the web.config, and the database connections have worked appropriately for the past several months, so I do not believe it is a connectivity problem unless Code-First migrations requires a different port than Automatic Migration.
I assumed that it was just not seeing the connection string supplied in the web.config, however running
"Update-Database -projectName data -startupprojectname web" results in the same error.
How do I get around the generic network-related error, given the above information? Is this problem a visiblity problem, in which the data project code-first migrations cannot see the connection string in the web project?