System.Data.SqlClient.SqlException:无效的列名'；phone_types_pho

我正试图从我的一些模型中获取信息，这些模型与我的主要员工模型有外键关系。如果我单独绘制每个模型，我可以像正常情况一样访问它们，没有任何问题，但我必须访问多个不同的网页才能访问

我正试图将我的几个模型合并为一个基本上单一的控制器，并以这种方式使用它们。不幸的是，当我试图访问这些模型时，我遇到了一个奇怪的错误：

System.Data.SqlClient.SqlException：列名"phone_types_phone_type_id"无效。

在搜索了我的代码之后，显然phone_types_phone_type_id出现的唯一位置是在我的迁移代码中。我是C#和Asp.Net的新手，所以我们非常感谢您的帮助。

这是我的型号的代码：

[Table("employee.employees")]
public partial class employees1
{
    public employees1()
    {
        employee_email_manager = new List<email_manager>();
        employee_employment_history = new HashSet<employment_history>();
        employee_job_manager = new HashSet<job_manager>();
        employee_phone_manager = new HashSet<phone_manager>();
        this.salaries = new HashSet<salary>();
    }
    [Key]
    public int employee_id { get; set; }
    [Display(Name="Employee ID")]
    public int? assigned_id { get; set; }
    [Display(Name="Web User ID")]
    public int? all_id { get; set; }
    [Required]
    [StringLength(50)]
    [Display(Name="First Name")]
    public string first_name { get; set; }
    [StringLength(50)]
    [Display(Name="Last Name")]
    public string last_name { get; set; }
    [Column(TypeName = "date")]
    [Display(Name="Birthday")]
    [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:MM/dd/yyyy}")]
    public DateTime birth_day { get; set; }
    [Required]
    [StringLength(1)]
    [Display(Name="Gender")]
    public string gender { get; set; }
    [Required]
    [StringLength(128)]
    [Display(Name="Social")]
    public string social { get; set; }
    [Required]
    [StringLength(128)]
    [Display(Name="Address")]
    public string address_line_1 { get; set; }
    [StringLength(50)]
    [Display(Name="Suite/Apt#")]
    public string address_line_2 { get; set; }
    [Required]
    [StringLength(40)]
    [Display(Name="City")]
    public string city { get; set; }
    [Required]
    [StringLength(20)]
    [Display(Name="State")]
    public string state { get; set; }
    [Required]
    [StringLength(11)]
    [Display(Name="Zip")]
    public string zip { get; set; }
    [Column(TypeName = "date")]
    [Display(Name="Hire Date")]
    [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:MM/dd/yyyy}")]
    public DateTime hire_date { get; set; }
    [Column(TypeName = "date")]
    [Display(Name="Separation Date")]
    [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:MM/dd/yyyy}")]
    public DateTime? termination_date { get; set; }
    [StringLength(70)]
    [Display(Name="Emergency Contact Name")]
    public string emergency_contact_name { get; set; }
    [StringLength(15)]
    [Display(Name = "Emergency Contact Number")]
    public string emergency_contact_phone { get; set; }
    [Display(Name = "Notes")]
    public string notes { get; set; }
    public virtual ICollection<phone_manager> employee_phone_manager { get; set; }
    [Table("employee.phone_manager")]
    public partial class phone_manager
    {
        [Key]
        public int phone_id { get; set; }
        public int employee_id { get; set; }
        [Required]
        [StringLength(15)]
        public string phone_number { get; set; }
        [StringLength(5)]
        public string phone_extension { get; set; }
        public int phone_type { get; set; }
        [Column(TypeName = "date")]
        public DateTime date_added { get; set; }
        public bool deleted { get; set; }
        public virtual employees1 employees1 { get; set; }
        public virtual phone_types phone_types { get; set; }
    }
    [Table("employee.phone_types")]
    public partial class phone_types
    {
        public phone_types()
        {
            phone_manager = new HashSet<phone_manager>();
        }
        [Key]
        public int phone_type_id { get; set; }
        [Required]
        [StringLength(50)]
        public string phone_type_name { get; set; }
        public virtual ICollection<phone_manager> phone_manager { get; set; }
    }
}

在我看来，相关的代码是：

        @foreach (var item in Model.employee_phone_manager)
        {
            @Html.DisplayFor(modelItem => item.phone_number); 
            @: - 
            @Html.DisplayFor(modelItem => item.phone_type);
            <br />
        }

编辑我可能已经发现了这个问题，但如果有其他选择，我肯定会接受更多的意见。我的解决方案是在这行的正上方添加以下内容：[ForeignKey("phone_type")]：phone_manager类中的public virtual phone_types phone_types { get; set; }。

    [Table("employee.email_manager")]
    public partial class email_manager
    {
        [Key]
        public int email_id { get; set; }
        public int employee_id { get; set; }
        [Required]
        [StringLength(255)]
        public string email { get; set; }
        public int email_type { get; set; }
        [Column(TypeName = "date")]
        public DateTime date_added { get; set; }
        public bool deleted { get; set; }
        [ForeignKey("email_type")]
        public virtual email_types email_types { get; set; }
        public virtual employees1 employees1 { get; set; }
    }
    [Table("employee.email_types")]
    public partial class email_types
    {
        public email_types()
        {
            email_manager = new HashSet<email_manager>();
        }
        [Key]
        public int email_type_id { get; set; }
        [Required]
        [StringLength(50)]
        public string email_type_name { get; set; }
        public virtual ICollection<email_manager> email_manager { get; set; }
    }

Ignore(p => p.CategoryAttachmentType);

/// <summary>
    /// Gets or sets the category attachment type
    /// </summary>
    public CategoryAttachmentType CategoryAttachmentType
    {
        get
        {
            return (CategoryAttachmentType)this.CategoryAttachmentTypeId;
        }
        set
        {
            this.CategoryAttachmentTypeId = (int)value;
        }
    }

   [ForeignKey("StatesTbl")]
   public int? State { get; set; }
   public StatesTbl StateTbl { get; set; }

   [ForeignKey("StatesTbl")] <== 'StatesTbl' is my original States table
   public int? State { get; set; }
   public StatesTbl StatesTbl { get; set; }