SqlException - A transport-level error has occurred when receiving results from the server

asp.net-mvc-5 c# entity-framework-6 hangfire sqlexception

Question

An hourly recurring job runs in my MVC 5 internet application that I'm currently developing. This task uses the DbContext class to update various model objects. The program is made available as an Azure website.

I encounter the next error every few hours:

System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) ---> System.ComponentModel.Win32Exception (0x80004005): The semaphore timeout period has expired

Why is that so? How can I stop this from happening, too?

I appreciate it.

1
4
3/26/2015 6:41:53 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Essentially, SQL server is just reporting an error that the network layer is throwing.

0
2/1/2016 8:52:11 AM

Related Questions

SQL Server Compact does not allow keys and values produced by the server.

When I came across this restriction, I switched the type to uniqueidentifier.
compact-framework entity-framework
asked by mostlytech

WCF - An error occurred while receiving the HTTP response to http://xxxxx/Service/

After much cursing and contemplation of the pleasant weather outside, the root problem was discovered. The UserDetails object, which is contained within the User object, has the virtual keyword removed from it....It now operates!...My best guesses as to why this resulted in a problem are serialization or DbContext difficulties, but I will have to d...
c# ef-code-first entity-framework wcf
asked by ledgeJumper

A network-releated or instance-specific error occurred while establishing a connection to SQL Server

Add a...<clear/>... To make sure no strings are being inherited, place the connectionstrings element as the first element underneath. Additionally, am I correct in assuming that the firewall settings for your Azure SQL DB, where the ASP.net code is deployed, allow for your IP?
asp.net-mvc azure-sql-database azure-web-roles connection-string entity-framework
asked by Bart Czernicki

Entity Framework with SQLite Error: An error occurred while reading from the store provider's data reader

The issue was brought on by many threads utilizing the same DBContext to query the database....The issue is resolved by giving each thread its own DBContext....In my situation, the DBContext was injected into the class that executes the query using Castle Windsor. The issue was resolved by setting the DBContext's lifestyle to one per thread.
.net-4.5 c# entity-framework sqlite wpf
asked by abrfra

Running update-database results in the error: "A file activation error occurred"

The issue is as follows:...AttachDbFilename=|DataDirectory|\Pbn.mdf ...That is being taken to mean "Pbn.mdf," which doesn't exist. This is because the value for |DataDirectory| is blank because you haven't set it. To set it, refer to ...here....
database entity-framework entity-framework-6 visual-studio
asked by simon at rcl

System.Data.SqlClient.SqlException' occurred in EntityFramework.dll but was not handled in user code

My problem was resolved once I downloaded and installed SqlLocalDb. I was assisted by this link, ...connection to local db failed with error 52....
asp.net-mvc c# entity-framework sql-server
asked by Ales

A transport-level error has occurred (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)

ZZZ_tmp
azure-sql-database c# enterprise-library entity-framework-6
asked by Alberto Morillo

Connection String Issue: System.Data.SqlClient.SqlException (0x80131904) - Unable to connect to SQL Server Management Studio

ZZZ_tmp
c# entity-framework-6
asked by penleychan

Receiving 500 internal server error even though I receive data from LINQ

ZZZ_tmp
asp.net-web-api c# entity-framework-6 https
asked by RMH

Entity Framework 6 BulkInsert receiving an invalid column length from the client SQL SERVER 2012 Express

ZZZ_tmp
c# entity-framework-6 sql-server-2012-express
asked by Jonathan Magnan

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