c# – 如何忽略Entity Framework Core SQLite数据库中的外键约束？

外键约束失败使用SQLite和Entity Framework Core

我在桌子上有关系

[Table("organizations")]
public class Organizations
{
    [Column("id")]
    public int Id { get; set; }

    [Column("parent_id")]
    [ForeignKey("id")]
    public int? ParentId { get; set; }

    [Column("person_id")]
    public int? PersonId { get; set; }
 }


public DbSet<Organizations> Organizations { get; set; }

using (var db = new SQLiteDbContext($"Filename={dbPath};"))
{
    db.Database.ExecuteSqlCommand("PRAGMA foreign_keys=OFF;");
    db.Database.ExecuteSqlCommand("PRAGMA ignore_check_constraints=true;");
    db.Organizations.AddRange(organizationsResult.Rows);
}

我从Sqlite数据库收到错误：

{“SQLite Error 19: ‘FOREIGN KEY constraint failed'”}

解决方法:

如果连接关闭,PRAGMA会失效.您需要通过在之前和之后调用db.Database.OpenConnection()和CloseConnection()来增加连接的生命周期.

您还可以调用optionsBiulder.UseSqlite(connectionString,x => x.SuppressForeignKeyEnforcement())来防止EF在每个连接上自动转换外键执行.

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！