title: Inserting record in SQL table with timestamp datatype
body: <p>I have a SQL Table with <code>TimeStamp</code> Column. The corresponding EF entity is below</p>
  
  <pre><code> public partial class Request : IEntityBase
  {
      public Request()
      {            
      }
  
      public int RequestID { get; set; }
      public Nullable&lt;int&gt; BatchID { get; set; }
      public string ClientID { get; set; }
      public Nullable&lt;System.DateTime&gt; CreatedDateTime { get; set; }
      public Nullable&lt;System.DateTime&gt; ModifiedDateTime { get; set; }
      public byte[] VersionStamp { get; set; }        
  }
  </code></pre>
  
  <p>The <code>VersionStamp</code> property has datatype <code>timestamp</code> is sql</p>
  
  <p>In C# i create a new entity and call savechanges()</p>
  
  <pre><code>        var request = new Request()
          {
              ClientID = "XYZ",
              CreatedDateTime = DateTime.Now,
              ModifiedDateTime = DateTime.Now,
          };            
          await _DBContext.SaveChangesAsync().ConfigureAwait(false);
  </code></pre>
  
  <p>But i get error</p>
  
  <blockquote>
    <p>"Cannot insert an explicit value into a timestamp column. Use INSERT
    with a column list to exclude the timestamp column, or insert a
    DEFAULT into the timestamp column."</p>
  </blockquote>
  
  <p>I am not setting <code>timestamp</code> anywhere in the code. I was expecting SQL will automatically update the column value</p>