Entity Framework Exception "The underlying provider failed on Open"

c# entity-framework

Question

I have created a windows service which listen to a TCP/IP port and save received data in database using Entity Framework. Most of the time it works fine but some time its throwing an exception "The underlying provider failed on open." on save data in database. Here is my exception details: 

    Exception: 2/27/2014 10:31 AM:
    The underlying provider failed on Open.
     at System.Data.Entity.Core.EntityClient.EntityConnection.Open()
     at System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection()
     at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
     at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClassb.<GetResults>b__9()
     at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
     at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
    at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
     at System.Lazy`1.CreateValue()
     at System.Lazy`1.LazyInitValue()
     at System.Lazy`1.get_Value()
     at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
     at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
     at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__1[TResult](IEnumerable`1 sequence)
     at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
     at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[TResult](Expression expression)
    at System.Data.Entity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression)
    at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
    at Service.DemoService.Save(String received, TcpClient client)

What is the thing behind this exception and how to resolve it?

1
5
2/27/2014 5:48:08 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Usually, when working with Entity Framework you'll need to enable the multiple active result sets option in your connection string by setting MultipleActiveResultSets to true as follows.

<add name="conn" 
  connectionString="
    Data Source=.\;
    Initial Catalog=TDB;
    UID=admin123;
    PWD=123;
    MultipleActiveResultSets=True"
  providerName="System.Data.SqlClient" />

Verify that it solves your problem.

7
9/6/2015 9:30:38 AM

Popular Answer

In my case, the issue was that the account which I was using to connect to SQL server was not added to app pool identity. Once I added the account 'domain\username' to app pool, it started working.

Raj Chaurasia

Related Questions

"The underlying supplier failed on Open," says Entity Framework.

You should create a sql account for your web server to access the aspnetdb database. It is currently using integrated authentication (tries to logon with the identity the web server is using to run the application)....The example below uses integrated auth. I would use SQL auth though....http://msdn.microsoft.com/en-us/library/ff649314.aspx
asp.net entity-framework
asked by Raj Kaimal

"The underlying supplier failed on Open," says the Entity Framework error.

Might the issue be connection pooling? Would the SQL provider try to preserve the connection between tests, even though the EF object is disposed? In that case would it be having an issue w/ multiple connections to the same DB by the same user?...Try explicitly closing the connection in your cleanup:...db.Database.Connection.Close();
.net c# entity-framework
asked by Justin Denton

"The underlying provider failed on Open" with WCF, Entity Framework, and SQL Server

I am successfully running tests through the the WCF Test Client, until I try to pull in data with Entity Framework....To make sure I'm not doing anything stupid, I downloaded the sample code from this tutorial, which is doing something similar: ...http://www.codeproject.com/KB/WCF/WCFandEF.aspx......and when I run it, I get the same error in a simi...
c# entity-framework sql-server visual-studio wcf
asked by iKode

The underlying provider fails to open, resulting in an entity exception.

I would consider checking one of two things:...Create a connection to your SQL Express, either in VS server explorer, or by using the SQL management studio, and verify you do not already have a database by that name attached to your server....Move your project from it's current location to somewhere on the disk which is not user-specific (meaning n...
entity-framework wcf
asked by IdoFlatow

Timeout elapsed on the underlying provider, resulting in an entity exception.

OK, I'm stumped. I am trying to create a .NET Winforms app to talk to a database via Entity Framework. I originally created a ASP.NET MVC3 app (with a seperate DAL layer) that can talk to the database after initially failing. SO the first time that it tries to open the connection, it times out. If I then hit F5 in the browser, it connects fine! I r...
asp.net-mvc c#-4.0 connection-string entity-framework sql
asked by Lutz Kretzschmar

The underlying provider failed to open , login failed for user IIS APPPOOL

i am not a sql server guy but i am working on a client's application and want to connect to the database through EF Code first ...the Exception message that i have is...The underlying provider failed to open...The Exception details...Cannot open database [DatabaseName] requested by the login. the login failed ...login failed for user 'IIS APPPOOL\A...
ef-code-first entity-framework sql-server-2008
asked by Nadeem Khedr

The underlying provider failed on Open in entity framework connection

I don't know why you get this error but I use this connection string and I don't have any problem. remember the name of the DbContext class and connection string should be same...<add name="MyDB" connectionString="Server=127.0.0.1;User ID=sa;Password=password;Database=Database" providerName="System.Data.SqlClient"/>
c# connection-string entity-framework
asked by Saman Qaydi

Entity Framework: The underlying provider failed on Open - through WCF service

Probably the app pool user you have the WCF service running against does not have permissions to access the sql database. You can either add yourself as a user or assign permissions for the current app pool user....Similar problem to ...How to use domain windows user account as app pool identity
.net c# entity-framework iis wcf
asked by mattdone

Using singleton pattern with Entity Framework context - The underlying provider failed on open

I'm trying to add a singleton pattern to my DbContext with Entity Framework. I've always used the singleton pattern for this, and never experienced this error before. ...I know that singleton is best practice...(Apparently not)..., ...but if any of you have the time to spare, could you please explain why singleton is best practice?...Problem...Othe...
c# design-patterns entity-framework wcf
asked by Detilium

SQLite & Entity Framework 6 "The underlying data provider failed to open"

You cannot use a SqlConnectionStringBuilder with SQLite, use SQLiteConnectionStringBuilder instead, and set the DataSource property to the database file name
c# entity-framework-6 sqlite winforms
asked by ErikEJ

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