protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer( @ "Server=AHMET;Database=test;Trusted_Connection=True" ); } public DbSet Products { get ; set ; } public DbSet ProductFavorites{ get ; set ; } public DbSet ProductImages { get ; set ; } public DbSet Categories { get ; set ; } public DbSet SubCategories { get ; set ; } public DbSet Members { get ; set ; } public DbSet Users { get ; set ; } public DbSet Blogs { get ; set ; } protected override void OnModelCreating(ModelBuilder modelBuilder) { base .OnModelCreating(modelBuilder); } public class Category { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public Guid CategoryId { get ; set ; } [Required] [DisplayName( "Category" )] public string Name { get ; set ; } public virtual IList SubCategory { get ; set ; } } public class SubCategory { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public Guid SubCategoryId { get ; set ; } [Required] [DisplayName( "Subcategory" )] public string Name { get ; set ; } [DisplayName( "Category" )] public Guid CategoryId { get ; set ; } [ForeignKey( "CategoryId" )] public virtual Category Category { get ; set ; } public virtual IList Products { get ; set ; } } I give migrations the update-database command, I get the following error: Error Number:1767,State:0,Class:16 "Foreign key 'FK_Products_Categories_CategoryId' references invalid table 'Categories'. Could not create constraint. See previous errors." Thanks in advance for your interest.

Hi, Create a foreign key reference with correct table name please refer below link, https://stackoverflow.com/questions/20107178/foreign-key-references-invalid-table

Answer

I'm getting this error while updating the db

Ozdemir Selcuk

599

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlServer(
@"Server=AHMET;Database=test;Trusted_Connection=True");
}
public DbSet<Product> Products { get; set; }
public DbSet<ProductFavorite> ProductFavorites{ get; set; }
public DbSet<ProductImage> ProductImages { get; set; }
public DbSet<Category> Categories { get; set; }
public DbSet<SubCategory> SubCategories { get; set; }
public DbSet<Member> Members { get; set; }
public DbSet<User> Users { get; set; }
public DbSet<Blog> Blogs { get; set; }
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
}
public class Category
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public Guid CategoryId { get; set; }
[Required]
[DisplayName("Category")]
public string Name { get; set; }
public virtual IList<SubCategory> SubCategory { get; set; }
}
public class SubCategory
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public Guid SubCategoryId { get; set; }
[Required]
[DisplayName("Subcategory")]
public string Name { get; set; }
[DisplayName("Category")]
public Guid CategoryId { get; set; }
[ForeignKey("CategoryId")]
public virtual Category Category { get; set; }
public virtual IList<Product> Products { get; set; }
}

I give migrations the update-database command, I get the following error:

Error Number:1767,State:0,Class:16 "Foreign key 'FK_Products_Categories_CategoryId' references invalid table 'Categories'. Could not create constraint. See previous errors."

Thanks in advance for your interest.