title: Any way to set small timeout (milliseconds) in SQL Server (using ADO.NET)?
body: <p>The question is in the title...  Any way I set a SqlCommand to timeout in 100ms?  The <a href="https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout(v=vs.110).aspx" rel="nofollow">documentation</a> says SqlCommand / ADO supports timeouts in full seconds only.</p>
  
  <p>Basically, I have a very small insert that should take &lt;30ms.  Sometimes SQL decides to be slow and my insert is blocked and can take 1-2 seconds.  The data inserted, however, is not mission critical and I would rather it fail than wait and block.  Can I set a very small timeout using ADO.NET?  Or should I just leave the Sql Insert as a 1sec timeout and fire-and-forget using the ASYNC methods?</p>
  
  <p>Thanks in advance.</p>