title: Linq insert on primary key field that is autosync
body: <p>I more or less want to do what this question suggests.
  <a href="https://stackoverflow.com/questions/507515/how-do-i-manually-set-an-identity-field-in-linq-to-sql-identity-insert">How do I MANUALLY set an Identity field in LINQ-To-SQL (IDENTITY INSERT)</a></p>
  
  <p>However, I want to explain. I have a client db. I load Linq objects from here and the send them across WCF. On the other side, I attach them to a data context and post them to the table. The issue is, they will have their Guid column set. This column is marked as AutoSync in the DBML. So in the case of an insert, Linq forces me to use the new value. I would like it to keep my value when I need it to.</p>
  
  <p><strong>Update 1</strong></p>
  
  <p>Basically I want to flip the AutoSync and IsDbGenerated setting on the fly programatically.</p>
  
  <pre><code>[Column(Storage="_cName", 
          AutoSync=AutoSync.OnInsert, 
          DbType="UniqueIdentifier NOT NULL", 
          IsPrimaryKey=true, IsDbGenerated=true)]
  </code></pre>