'SQLite Error 19: 'FOREIGN KEY constraint failed'. how to fix it
The error occur when i can create relationship between two classes
when i can migrate the issue was there New class
public class Technology
{
public int TechnologyId { get; set; }
public int TechnologyName { get; set; }
public ICollection <ProjectMember>? ProjectMembers { get; set; }
}
}
public class ProjectMember
{
public int ProjectMemberId { get; set; }
public int ProjectId { get; set; }
public int TeamId { get; set; }
public int MemberId { get; set; }
public int RoleId { get; set; }
public int TechnologyId { get; set; }
public Technology? Technology { get; set; }
public Project? Project { get; set; }
public Member? Member { get; set; }
public Role? Role { get; set; }
public Team? Team { get; set; }
}
}
This is my Dbcontext i dont why this error occur i try but error does not fix............................................................................
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Identity;
using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;
using TeamManagement.Models;
public class TeamContext : IdentityDbContext<IdentityUser>
{
public TeamContext (DbContextOptions<TeamContext> options)
: base(options)
{
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
}
public DbSet<TeamManagement.Models.Member> Member { get; set; }
public DbSet<TeamManagement.Models.Project> Project { get; set; }
public DbSet<TeamManagement.Models.TeamMember> TeamMember { get; set; }
public DbSet<TeamManagement.Models.Role> Role { get; set; }
public DbSet<TeamManagement.Models.Team> Team { get; set; }
public DbSet<TeamManagement.Models.ProjectMember> ProjectMember { get; set; }
public DbSet<TeamManagement.Models.Technology> Technology { get; set; }
}```
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
