title: Update without first selecting data in LINQ 2 SQL?
body: <p>How can you go about updating a record without having to select the data first in LINQ?</p>
  
  <p>As you must first perform a linq select (obviously calls a SQL SELECT which is costly), change required properties, then perform SubmitChanges().  I wish to avoid this and just perform a SQL UPDATE, I already know the ID.</p>