title: Async Await - CancellationTokens when calling a SQL Server. ASP.NET
body: <p>Is it good practice to be using cancellation tokens when making an asynchronous request to a SQL Server?</p>
  
  <p>Lets just say we have a situation where we could end up with the SQL Server reporting an 'Operation Time out' failure. </p>
  
  <p>Eventually SQL Server will return the exception to us.. and a Task from the thread pool that made receive a result containing the exception.</p>
  
  <p>But would it be better if we where to defend against this by introducing a cancellation token with a shortened timeout limit. </p>
  
  <p>My gut tells me that i should leave this up to the SQL Server to report any exceptions, but that could mean leaving the request hanging for minutes.. </p>
  
  <p>Hope this makes sense.</p>