SQLite Forum

Can't migrate auto-increment bigint columns
Login
The problem is that SQLite doesn't support AUTOOINCREMENT the same as many other databases, but only I n a very specific case, and its creates direct behavior that makes it not just an 'optional' word.

It sounds like EFCore either doesn't really support SQLite or has a bug in its support for it. I would suggest filing a bug report there.

Note that Adding Autoincrement isn't just a do-nothing option, by adding it then SQLite promises that it will NEVER automatically create a duplicate value from anything it has previously generated.