How to create Autoincrement column in SQLite using EF core? : <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>
