Breaking News: Grepper is joining You.com. Read the official announcement!

Set database timeout in Entity Framework

Ram S answered on April 13, 2022 Popularity 3/10 Helpfulness 2/10

answer Set database timeout in Entity Framework

Set database timeout in Entity Framework

Comment

public class MyDatabase : DbContext
{
    public MyDatabase ()
        : base(ContextHelper.CreateConnection("Connection string"), true)
    {
        ((IObjectContextAdapter)this).ObjectContext.CommandTimeout = 180;
    }
}

<connectionStrings>

<add name="AdventureWorksEntities"
connectionString="metadata=.\AdventureWorks.csdl|.\AdventureWorks.ssdl|.\AdventureWorks.msl;
provider=System.Data.SqlClient;provider connection string='Data Source=localhost;
Initial Catalog=AdventureWorks;Integrated Security=True;Connection Timeout=60;
multipleactiveresultsets=true'" providerName="System.Data.EntityClient" />

</connectionStrings>

Popularity 3/10 Helpfulness 2/10 Language csharp

Source: entityframework.net

Tags: c# database entity-framework set timeout

Link to this answer
Share Copy Link