Entity Framework Error: Unable to track an entity of type OrderItem because primary key property ProductVariant is null

jon

in my OrderItems table i need a composite key as

Id, ProductCode,ProductVariant

I tested insert in sqlite with null ProductVariant but from webapi post

i recive error

InvalidOperationException: Unable to track an entity of type 'OrderItem' because primary key property 'ProductVariant' is null.

Microsoft.EntityFrameworkCore.ChangeTracking.Internal.NullableKeyIdentityMap<TKey>.Add(InternalEntityEntry entry)

How can solve?

jon

0 18

Now i solved with a raw query and inside

if (item.Codvar == null)
    Codvar = new SqliteParameter("@Codvar", DBNull.Value);
else
    Codvar = new SqliteParameter("@Codvar", item.Codvar);

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html