title: Getting "the wait operation timed out" on simple query, other queries work, works on local db
body: <p>I have a very simple LINQ query where I call a view to get an object, basically it looks like this:</p>
  
  <pre><code>context.view.FirstOrDefault(p =&gt; p.id == key)
  </code></pre>
  
  <p>Key and id are strings, which is less than ideal I think. However, when I run it against my local database, it works fine.</p>
  
  <p>However, when I deploy my application, I get the message:</p>
  
  <pre><code>[Win32Exception (0x80004005): The wait operation timed out]
  [SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to
  completion of the operation or the server is not responding.]
  </code></pre>
  
  <p>etc.</p>
  
  <p>Other queries against views work quickly and as expected. They return lists rather than single objects, I'm not sure if that makes a difference.</p>
  
  <p>I'm unable to connect to my hosted database from my development environment due to how the environment is configured, so my troubleshooting options are somewhat limited. I have double checked that the view is the same across both the local and the hosted environment.</p>
  
  <p>When I run the query in SSMS against the hosted database it executes in under a second.</p>
  
  <p>I'm not sure what good next steps would be as far as troubleshooting and would appreciate any advice. </p>
  
  <p>I'm using Entity Framework 6, database first.</p>