title: Linq to sql error with identitiy increment field
body: <p>I've just started to use linq to sql and have run into a problem with inserting a record with an auto incrementing field.</p>
  
  <p>I have created a new instance of a company object defined by linq. it has initialised an auto incrementing field 'companyID' to 0.
  InsertOnSubmit() fails with the following invalidOperationException.</p>
  
  <blockquote>
    <p>Incorrect autosync specification for
    member 'companyID'</p>
  </blockquote>
  
  <p>the column attribute IsDbGenerated is true for the companyID property.
  I am using sql server 2000.</p>
  
  <p>Edit: Auto-sync is set to OnIsert. The dataype is BigInt in TSQL, long in c#.</p>
  
  <p>Does anyone know why this error is occuring and how it can be resolved?</p>
  
  <p>thanks</p>