Error in update-database command in code first migration

c# code-migration entity-framework sql-server

Question

I am working on Desktop application in WPF and creating SqlRepository with LocalDB to store data. I am using following tools

  • Visual Studio 2013 Community with update 2
  • Entity Framework 6.1.2 for Code first migration

I have created local database with Microsoft SQL Server Database File (SqlClient) configuration. Database created successfully and below is connection string fetched from Sql

Data Source=(LocalDB)\v11.0;Initial Catalog=D:\USERS\USERNAME\DOCUMENTS\TestDatabase\testdb.MDF;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False

I am using same connection string in app.config. I can view database object in SQL Server Database explorer in Visual Studio. But when run update-database command in Nuget package manager console, I am getting below 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)

1
21
1/4/2015 5:25:46 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I had similar problem and fixed it when I changed the "start-up project" from another module to the module containing references to all other projects in the solution. Right-click module >> click "Set as StartUp Project"

62
1/24/2015 10:54:44 PM

Popular Answer

Diego's answer is correct.

This problem occurs when there is no connection string in project marked as startup project. Then EF tries to connect to some default database engine to perform update. In my case it tried to use express, and for some reason it couldn't connect. And the error was thrown.

Run your "update-database" with option "-Verbose". One of the lines there shows which StartUp project is used. Check your connection string in this project, or change the startup project to the one that has correct connection string. That solves the problem.

Mikk

Related Questions

Update-Database tries to do an automatic migration even with automatic migrations disabled

public class Configuration : DbMigrationsConfiguration<bailencasino.com.dal.Context.BlncnoContext> { public Configuration() { AutomaticMigrationsEnabled = false; AutomaticMigrationDataLossAllowed = true; } ...Add ...AutomaticMigrationDataLossAllowed = true;... so you assume that you want to allow EF to add remove SQL obj...
ef-migrations entity-framework
asked by user761172

Entity framework code first - how to run Update-Database for production database

See ...Using Entity Framework (code first) migrations in production... so that your application automatically updates the database when the Entity Framework initializes....Now if you're more comfortable having manual control over the migration, you could use the -Script argument to the Update-Database command on your developer machine to generate S...
asp.net-mvc c# entity-framework
asked by David Moore

Update-Database fails due to Pending Changes, but Add-Migration Creates a Duplicate Migration

I see this all the time also. I don't know why, wish i did, but my solution is to do a add-migration which will make a duplicate. Now this duplicate opens in the editor and then i edit it, so that the Up and Down methods are empty. So the result is a migration file that does nothing! VS is happy and you can do the update-database without errors (un...
c# ef-migrations entity-framework
asked by Lars

EF Add-Migration indicates "No pending explicit migrations" but Update-Database complains "..there are pending changes"

For me the issue was that we had renamed the namespace of the migration 2014123456_Initial.cs.... But VS had not regenerated the namespace in its associated 2014123456_Initial.Designer.cs....Once the Designer.cs was changed to use the same namespace, it all started working again.
ef-migrations entity-framework
asked by demoncodemonkey

EF Code Frirst: Before you update your database using Code First Migrations,

I believe it's a one time occurrence while you upgrade your database. ...You can read more at the ....NET Web Development and Tools Blog.... And also see ...Updating ASP.NET applications from ASP.NET Identity 1.0 to 2.0.0-alpha1... linked from that blog post.
asp.net-identity entity-framework
asked by Michael Fürstenberg

Error running code first migration update-database

I ran into this same issue and here is how I resolved it. I hope this helps someone else....I deleted Entity Framework from my References and removed the lines from my package.config file(s)....Closed Visual Studio and deleted all the EntityFramework DLL files in my project folders...Opened Visual Studio, then did a Clean and Build...Re-install En...
asp.net-web-api c# entity-framework
asked by L_7337

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

Go through the generation process, and during the generation process, it allows you to select tables. Select the newer ones only....Instead of selecting all tables, expand the little triangle and select what you need. You also will have to select any dependent tables, or else the process will fail. If those dependent tables are already there, just ...
.net c# ef-code-first entity-framework entity-framework-6
asked by Mrchief

Entity Framework 6 Migrations: How to disable automatic Update-Database on Database initialize?

Migrations also have a Seed method you can override that takes place after the Up() method. You can use the AddOrUpdate command in case data may exist. ...http://www.asp.net/web-api/overview/data/using-web-api-with-entity-framework/part-3
ef-migrations entity-framework-6
asked by Steve Greene

update-database -force command is not updating the base in entity framework code -first

Using an Existing Database...Depending on the state of your context you need to the one of the following......IF YOUR DATABASE CONTEXT CONTAINS ONLY YOUR EXISTING TABLES AND NO CUSTOM CHANGES DO THE FOLLOWING...Add-Migration Initial -IgnoreChanges ...This will create a blank migration script...update-database ...This will update the database to thi...
asp.net-mvc ef-code-first entity-framework sql-server
asked by heymega

Entity Framework Code-First: Generate SQL script with 'Update-Database' produces XML error while parsing

I normally use a command like:...Update-Database -Script -SourceMigration:"201502201618119_Migrations17" -TargetMigration:"201503031134340_Migrations18" ...and then run the resultant script on the server. ...SourceMigration... is the last entry in the ...__MigrationHistory... table on the server....The other 'trick' I use with mig...
c# ef-code-first ef-migrations entity-framework
asked by Peter Smith

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