title: Deadlock using linq to sql select
body: <p>I'm using linq to sql and running a direct SQL query - select statement - which queries a XML column using (XQuery). Multiple such queries are run in parallel and I'm getting deadlock exception.</p>
  
  <p>Does select acquire some sort of lock when running? There are also updates happening in parallel with Serializable isolation level.</p>
  
  <p>Any pointers how to get this problem resolved could be helpful. How do I specify NOLOCK in Linq To SQL?</p>