title: Entity Framework Error, One table always getting timeout
body: <p>I have following code to get a particular user details from DB, from 5 different tables. </p>
  
  <pre><code>var userValues = usrRepository.AsQueryable()
      .Where(user =&gt; user.UserType == (int)GlobalEnumeration.UserType.MDappUser &amp;&amp; user.IsActive == true)
      .Include(f =&gt; f.appusraddrs)
      .Include(c =&gt; c.usrcalendar)
      .Include(f =&gt; f.usrattributes)
      .Include("usrAttributes.usrAttributeValues")
      .Include("usrAttributes.usrAttributeValues.ApplicationAttributeValue")
      .ToList();
  </code></pre>
  
  <p>However I always get the Timeout error when ever I try to include the table <code>ApplicationAttributeValue</code> using the last include <code>.Include("usrAttributes.usrAttributeValues.ApplicationAttributeValue")</code>.</p>
  
  <p>If I do not include that table, I do not get an error.</p>
  
  <p><strong>Error Stack</strong></p>
  
  <pre><code>MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---&gt; System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---&gt; System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---&gt; System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
  at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
  --- End of inner exception stack trace ---
  at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
  at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
  --- End of inner exception stack trace ---
  at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
  at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
  at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
  at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
  at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
  at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32&amp; affectedRow, Int64&amp; insertedId)
  at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
  at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)
  at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
  at MySql.Data.Entity.EFMySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
  at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
  </code></pre>
  
  <p>And</p>
  
  <pre><code>at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
  at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
  at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
  at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable&lt;T&gt;.GetEnumerator()
  at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
  at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
  at MyBusiness.Business.SearchIndexing.SearchIndexBC.GetMyBusinessDetails()
  at MyBusiness.Framework.Indexing.Services.IndexingTaskExecutor.BatchIndex(String indexName, String settingsFilename, IndexSettings indexSettings)
  at MyBusiness.Framework.Indexing.Services.IndexingTaskExecutor.UpdateIndexBatch(String indexName)
  at MyBusiness.Business.ProfileManagement.ProfileManagementBC.UpdateOtherDetails(appuser user)
  </code></pre>