kBeeGQTy

1CREATE TABLE IF NOT EXISTS VoronoiDiagram(
2                                            ID integer PRIMARY KEY  AUTOINCREMENT,
3                                            InteriorCells integer,
4                                            DateCreated text,
5                                            DateProcessed text
6                                        )
7
8                                        CREATE TABLE IF NOT EXISTS VoronoiCell(
9                                            ID integer PRIMARY KEY AUTOINCREMENT,
10                                            IsProcessed integer,
11                                            DateCreated text,
12                                            DateProcessed text,
13                                            VoronoiDiagram_ID integer,
14                                            FOREIGN KEY([VoronoiDiagram_ID]) REFERENCES VoronoiDiagram([ID])) 
15     
16protected override void OnModelCreating(DbModelBuilder modelBuilder)
17    {
18        //var sqliteConnectionInitializer = new SqliteCreateDatabaseIfNotExists<MyContext>(modelBuilder);
19        //Database.SetInitializer(sqliteConnectionInitializer);
20        modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
21        base.OnModelCreating(modelBuilder);
22
23        modelBuilder.Entity<VoronoiDiagram>()
24             .HasKey(s => s.ID)
25            .HasMany<VoronoiCell>(c => c.VoronoiCells)
26            .WithMany();
27        modelBuilder.Entity<VoronoiCell>()
28            .HasKey(x => x.ID)
29            .HasRequired(c => c.VoronoiDiOnMagram);
30    } 
31     
32{"SQL logic errorrntable VoronoiCell has no column named VoronoiDiagram_ID1"}