title: How to create Autoincrement column in SQLite using EF core?
body: <p>I am using Entity Framework Core 2.0 for Sqlite code first in my <a href="https://docs.microsoft.com/en-us/ef/core/get-started/uwp/getting-started" rel="noreferrer">UWP and .NET Standard</a> app. My model has an entity of type Primary Key integer which should be served as auto increment according to <a href="https://sqlite.org/autoinc.html" rel="noreferrer">SQLite documentation</a>. But in real for every row that Identity column is getting 0 as a value.
  Please help because i found no helping material related to this issue.</p>
  
  <p>This is my property without any data annotaion.</p>
  
  <p><code>public Int32 No { get; set; }</code></p>
  
  <p>I have used fluent API</p>
  
  <pre><code>modelBuilder.Entity&lt;TurnosGeneral&gt;()
              .HasKey(c =&gt; new { c.No, c.Cod_Turno });
  </code></pre>
  
  <p>And value is inserted here</p>
  
  <pre><code>db.TurnosGenerals.Add(new TurnosGeneral { Cod_Turno = numeroTurnoTextBlock.Text });
  </code></pre>
  
  <p><code>db.SaveChanges();</code></p>
  
  <p>For every row inserted c.No is 0.</p>