title: The underlying provider failed on Open
body: <p>I made 3 Ajax processes to run the below code at the same time.
  but one of the processes throw exception that message says <em>"The underlying provider failed on Open."</em></p>
  
  <pre><code>try{
      orderRepository orderRepo = new orderRepository(); // get context (Mysql)
  
      var result = (from x in orderRepo.orders
            where x.orderid == orderno
            select new {x.tracking, x.status, x.charged }).SingleOrDefault();
  
      charged = result.charged;
  }catch(Exception e){
      log.Error(e.Message); //    The underlying provider failed on Open.
  } 
  </code></pre>
  
  <p>And, I run the 1 Ajax call that failed before, then It passes through.</p>
  
  <p>It happen to 1 of 3 (Ajax) process, sometimes, 2 of 5 process. </p>
  
  <p>I guess it because all process try to using Database same time. but I couldn't find the solution.</p>
  
  <p>This is my connection string,</p>
  
  <pre><code>&lt;add name="EFMysqlContext" connectionString="server=10.0.0.10;User Id=root;pwd=xxxx;Persist Security Info=True;database=shop_db" providerName="Mysql.Data.MySqlClient" /&gt;
  </code></pre>
  
  <p>Anybody know the solution or something I can try, please advise me.</p>
  
  <p>Thanks</p>