Why doesn't In Memory Database autogenerate int property?

Question

.NET

In Memory Database doesn't autogenerate int property, huh?
Trying to sequence a simple int value builder.Property

(x => x.SerialNumber).ValueGeneratedOnAdd()

after AddAsync() - 0

.net Core 3.1

Answer 1

Decided differently in OnModelBuilding

if (DataBase.IsInMemory())
var autoGenIntProperties = modelBuilder.Model.GetEntityTypes()
                .SelectMany(t => t.GetProperties())
                .Where(p => p.ClrType == typeof(int) && p.ValueGenerated != ValueGenerated.Never);

            foreach (var property in autoGenIntProperties)
                property.SetValueGeneratorFactory((p, t) => new InMemoryIntegerValueGenerator<int>(p.GetIndex()));

This is most likely because:
1. The keys are clear how to increment, but there are no custom fields
2. Each database has a different implementation of this case, so you need to explicitly specify in InMemory how to win back this
case initialization, so that users do not rack their brains for hours

Answer 2

Try this solution.
https://stackoverflow.com/questions/47754939/how-t...
Other than that it looks like the problem is reoccurring, read the advice here in this thread.