MySql with entity framework Code First ID jumping 10

Question

Navigation

#1 by (0 votes)

1

I'm setting up a MySql in Azure for an application I'm working on, however saving my records to identity column is increasing by 10.

Would this be an entity-adjustable setting or an adjustment made for all tables directly in the database?

In case, what and how should I change this option to auto increment only 1?

mysql entity-framework code-first windows-azure

asked by anonymous 29.07.2015 / 22:09

1 answer

About Object and Extensions [closed] My application does not find my method

score 0 · Answer 1

There is a variable that controls this: autoincrement

See if you can identify the value of it like this:

SELECT Auto_increment FROM information_schema.tables WHERE table_name='the_table_you_want';

To change it would look like this:

SET @@auto_increment_increment=1;