When EntityFrameworkUpdate-Database is called, the error "System.Data.SqlClient.SqlException (0x80131904) is thrown. A network-related or instance-specific error occurred while establishing a connection to SQL Server. "

Праздники ...

Праздники ...

День Октябрьской революции (7 Ноября)

Концерты, выставки ...

Концерты, выставки ...

Спектакль "Чайка"|||г. Минск 9 сентября, 10 сентября, 1 октября 2026

Спорт занятия ...

Спорт занятия ...

Бокс, тайский бокс, фитнес : total body, стретчинг, кикбоксинг

Спорт занятие

Компьютер, программы...

Компьютер, программы...

Объявления ...

Объявления ...

ремонт двигателя ММЗ д245-26 для трактора мтз 102

Объявление

Новости ...

Новости ...

обсуждение...

Поиск

Концерты Спорт Форум Компьютер

Компьютер, программы

→

Entity Framework (EF5, EF6) for working with a C database#

При вызове EntityFramework\Update-Database появляется ошибка "System.Data.SqlClient.SqlException (0x80131904). A network-related or instance-specific error occurred while establishing a connection to SQL Server."

посмотрели 9545 раз

обновлено: 11 April 2019

При выполнении в Package Manager Console:
EntityFramework\Update-Database

Возникает ошибка:
Error: System.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Решение

Шаг 1. run service SQL Server Browser

Шаг 2. enable TCP/IP for SQL Server

Шаг 3. set TCP Port to 1433 for IPAll

Результат

В Package Manager Console выполняем:
EntityFramework\Update-Database

нет ошибок

← Previous topic
What is <connectionStrings> a .config file for Entity Framework (EF5, EF6)

Next topic →
When calling EntityFrameworkUpdate-Database, the error "Your startup project "..." doesn"t reference Microsoft.EntityFrameworkCore.Design"

Your feedback ... Comments ...

Объявления

Объявления

• What is Entity Framework?

Types in Entity Framework

• Entity Framework Type Conversion, Table Naming Conventions

• Foreign Key and Cascade Deletion

• DateTime & Date & Time Only in the Entity Framework

Code First

• Code First. We"re writing a C# class. Entity Framework uses our C# class → to create and populate a table in the database

• Auto Code First. Entity Framework creates a C# class from an existing table in the → database

Database First

• Database First. Entity Framework creates a C# class from an existing table in the → database

Model First

• Model First. We create a model in Visual Studio. Using the Entity Framework model, → creates C# classes and a Database

Working with data

• Iterating over data in the Entity Framework

• Adding Data to the Entity Framework

• Modifying (editing) data in the Entity Framework

• Deleting data in the Entity Framework

Database initialization and migration

• Initialize the database in the Entity Framework. DropCreateDatabaseAlways allows you to repopulate the database with each new run

• Performing a Database Migration to Entity Framework (if someone has already made a cs migration file, and I want to update the database on my computer, I perform the migration, that is, call EntityFramework\Update-Database)

• Creating and performing a Database migration to Entity Framework (I changed the c# class, then call EntityFramework\add-migration, i.e. the cs file with the migration code is automatically added to the project, then call EntityFramework\Update-Database, i.e. the migration file is executed and the database is changed)

SQL in Entity Framework

• SQL Commands in Entity Framework

Transactions in the Entity Framework

• Managing Transactions in the Entity Framework

Additional topics, questions

• What is <connectionStrings> a .config file for Entity Framework (EF5, EF6)

• When EntityFrameworkUpdate-Database is called, the error "System.Data.SqlClient.SqlException (0x80131904) is thrown. A network-related or instance-specific error occurred while establishing a connection to SQL Server. "

• When calling EntityFrameworkUpdate-Database, the error "Your startup project "..." doesn"t reference Microsoft.EntityFrameworkCore.Design"

WWW Sites to Learn Entity Framework

• Sites to learn Entity Framework

Ваши вопросы присылайте по почте: info@dir.by