A sharp increase in the field

Question

I have a table in EntityFramework that has a field named ID, this field is the primary key and is Identity. when I add records to this table, this field value increases by each recorder, after adding several records this value suddenly increases For example, increased from 90 to 1010 While no transaction was unsuccessful. what is the problem?

Answer 1

If you are using Azure SQL, this may happen. We have done this several times. This is just the nature of Azure sql.

See this question . Windows Azure SQL Database - Identity. Auto-growing column skips values , in a detailed explanation for a case very similar to yours.