ihave 3 models user,ArticleComments and UserSubsription .. im trying to make 3 prop as composite key and two of them are foreign key references to two different tables but i got error while trying to enable-migrations

User.CS

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Web;
using WebAppInternetApp.Models;

namespace WebAppInternetApp.Models
{
    public class User
    {

        public User()
        {
            this.WriterIDs = new HashSet<JobArticle>();
            this.AdminIDs = new HashSet<JobArticle>();
            this.UserIDs = new HashSet<ArticleComments>();
            this.UserIDss = new HashSet<UserQuestion>();
            this.UseerIDsss = new HashSet<UserSubscription>();
        }

        [Key]
        public int UID { get; set; }

        [Required]
        [StringLength(20, MinimumLength = 2)]
        public string FName { set; get; }

        [Required]
        [StringLength(20, MinimumLength = 2)]
        public string LName { set; get; }

        [Required]
        [DataType(DataType.EmailAddress)]
        public string Email { set; get; }

        [Required]
        [StringLength(25, MinimumLength = 8)]
        public string Password { set; get; }

        [Required]
        public bool Status { set; get; }

        [Required]
        [Phone]
        public string PhoneNo { set; get; }

        [Column(TypeName = "image")]
        public byte[] UserImg { set; get; }

        public virtual ICollection<JobArticle> WriterIDs { set; get; }
        public virtual ICollection<JobArticle> AdminIDs { set; get; }
        public virtual ICollection<ArticleComments> UserIDs { set; get; }
        public virtual ICollection<UserQuestion> UserIDss { set; get; }
        public virtual ICollection<UserSubscription> UseerIDsss { set; get; }

        public virtual UserType usertypeIDs { set; get; }



    }
}

Article Comments.CS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace WebAppInternetApp.Models
{
    public class ArticleComments
    {
        [Required]
        public string Comment { set; get; }
        [Key]
        [Column(Order = 0)]
        public DateTime CommentTime { set; get; }
        [Key]
        [Column(Order = 1)]
        [ForeignKey("User")]
        public virtual User UserID { set; get; }
        [Key]
        [Column(Order = 2)]
        [ForeignKey("JobArticle")]
        public virtual JobArticle ArticleID { set; get; }
    }
}

UserSubsription.CS

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Web;
using WebAppInternetApp.Models;

namespace WebAppInternetApp.Models
{
    public class UserSubscription
    {
        [Key]
        [Column(Order = 0)]
        [ForeignKey("User")]
        public virtual User UserIDs { set; get; }

        [Key]
        [Column(Order = 1)]
        [ForeignKey("JobCategory")]
        public virtual JobCategory SubscriptID { set; get; }
    }
}

Related posts

Recent Viewed