For some reason EF adds column to insert query. That column didn’t ever exist in my model, anybody has more info about this?
My model:
public partial class EvidencijaAktivnosti
{
public Guid Id { get; set; }
public int IdAuto { get; set; }
[Required]
public Guid IdAktivnosti { get; set; }
[Required]
public Guid IdSkupina { get; set; }
public string? IdKorisnika { get; set; }
public DateTime Datum { get; set; }
public string? Napomena { get; set; }
public Guid IdKlub { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
Here is DbContext of that entity
modelBuilder.Entity<EvidencijaAktivnosti>(entity =>
{
entity.HasKey(e => e.Id).HasName("EvidencijaAktivnosti_pkey");
entity.ToTable("EvidencijaAktivnosti");
entity.Property(e => e.Id).HasDefaultValueSql("uuid_generate_v4()");
entity.Property(e => e.CreatedAt)
.HasDefaultValueSql("CURRENT_TIMESTAMP")
.HasColumnType("timestamp without time zone");
entity.Property(e => e.Datum).HasColumnType("timestamp without time zone");
entity.Property(e => e.IdAuto).ValueGeneratedOnAdd();
entity.Property(e => e.Napomena).HasMaxLength(5000);
entity.Property(e => e.UpdatedAt)
.HasDefaultValueSql("CURRENT_TIMESTAMP")
.HasColumnType("timestamp without time zone");
});
Here is code that saves it:
db.EvidencijaAktivnosti.Add(data);
await db.SaveChangesAsync();
End lastly here is generated query (note: “AktivnostiId”):
INSERT INTO "EvidencijaAktivnosti" ("Id", "AktivnostiId", "CreatedAt", "Datum", "IdAktivnosti", "IdAuto", "IdKlub", "IdKorisnika", "IdSkupina", "Napomena", "UpdatedAt")
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10);
Ofc I get error:
Npgsql.PostgresException (0x80004005): 42703: column "AktivnostiId" of relation "EvidencijaAktivnosti" does not exist
MessageText: column "AktivnostiId" of relation "EvidencijaAktivnosti" does not exist
In DB i don’t have this column, I have tried searching for “AktivnostiId” but no luck, I have tried cleaning project with no luck!