- 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'm getting this error while updating the db
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.
Ronika JencyPosted Aug 25, 2020, 12:09 AM