In an existing SQL database, I delete a data record with using (var connection = new SQLiteConnection (System.IO.Path.Combine (folder, dbName)))
It works fine. Then a new data record is written to the DB. The new data record now has a new ID after it has been saved. The ID is the PrimaryKey. At first the data sets were marked with the ID 1,2,3,4 etc. After deleting data record 2 and adding a new data record, it is now 1,3,4,5. How is it possible to write the new data record in the line of the deleted data record 2 after saving and how does it get ID 2? Thanks for an answer.