类对象-层次结构和继承(不起作用)

Question

我有一个(People(或Users对象，我使用类继承来创建各种对象。

然而，我得到了错误INVALID COLUMN，当我添加数据库中存在的对象Users_Accounts及其各自的列时，我得到错误

我做错了什么？

错误消息处理请求时发生未处理的异常。SqlException：列名"Users_AccountsAccountID"无效。列名"Users_AccountsAccountID"无效。列名"Users_PhonePhoneID"无效。

namespace Accounts.i_EF.Accounts
{
public class Users
{
[Key]
public int UserID { get; set; }
public string Email { get; set; }
public Guid UniqueID { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }

public Users_Accounts Users_Accounts { get; set; }

}
public class Users_Accounts
{
[Key]
public int AccountID { get; set; }
public string UniqueID { get; set; }
public Title Title { get; set; }
public string First_Name { get; set; }
public string Last_Name { get; set; }
public Gender Gender { get; set; }
public Users_Phone Users_Phone { get; set; }
public string Email { get; set; }
public DateTime  Dates { get; set; }
public bool IsSuspended { get; set; }
}
public enum Gender
{
male,female
}

和我的控制器代码

var user = HttpContext.User.Identity.Name.ToString();
var DataContext = _context.Users.Include(c => c.Users_Accounts);

return View(await DataContext.SingleOrDefaultAsync(c => c.Email == user && !c.IsSuspended));

Answer 1

试试这个代码：

namespace Accounts.i_EF.Accounts
{
public class Users
{
[Key]
public int UserID { get; set; }
public string Email { get; set; }
public Guid UniqueID { get; set; }
public DateTime Dates { get; set; }
public bool IsSuspended { get; set; }
public int UserAccountID { get; set; }
[ForeignKey(nameof(UserAccountID))]
public Users_Accounts Users_Accounts { get; set; }

}
public class Users_Accounts
{
[Key]
public int AccountID { get; set; }
public string UniqueID { get; set; }
public Title Title { get; set; }
public string First_Name { get; set; }
public string Last_Name { get; set; }
public Gender Gender { get; set; }
public int UserPhoneID { get; set; }
[ForeignKey(nameof(UserPhoneID))]
public Users_Phone Users_Phone { get; set; }
public string Email { get; set; }
public DateTime  Dates { get; set; }
public bool IsSuspended { get; set; }
public int UserID { get; set; }
[ForeignKey(nameof(UserID ))]
public Users Users { get; set; }
}
public enum Gender
{
male,female
}