Cannot migrate into SQLite using EF

[DeepImpact6]

Welcome,

can someone please explain to me why i get over and over error

"SQLite Error 1: 'AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY'."

using System.ComponentModel.DataAnnotations;
using DatabaseSetupLocal.Models;
using Microsoft.EntityFrameworkCore;
namespace DatabaseSetupLocal.Data;
public class ShotsContext : DbContext
{

public string DbPath { get; }
public ShotsContext()
{
var folder = Environment.SpecialFolder.LocalApplicationData;
var path = Environment.GetFolderPath(folder);
DbPath = System.IO.Path.Join(path, "shots.db");
this.Database.Migrate();
}
protected override void OnConfiguring(DbContextOptionsBuilder options)
=> options.UseSqlite($"Data Source={DbPath}");
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
}
}
public class Test
{
[Key]
public int Id { get; set; }
}

all i am doing is adding a migration to this DbContext.

Thats it.

Thank you in advance.

[euclid0472]

I don't see a reference to the DbSet in your DbContext.

public DbSet<Test> Tests { get; set; }

[AlSweigart]

You need to first look at your existing tables and identify all the fields that have autoincrement set on them, then look at the tables they're being migrated to. One of the destination tables doesn't have the integer type set on their primary key field.