实体类型“客户”不能映射到表，因为它是从“ ApplicationUser”派生的

debugcn 发表于 Dev

robert_rg

我正在尝试使用从继承的单独的标识类ApplicationUser，并在它们之间创建关系。企业和客户，企业可以拥有许多客户。添加关系时出现错误。在具有关系的类之间实现添加标识的正确方法是什么？

ApplicationUser.cs

public class ApplicationUser : IdentityUser
{
    public virtual Business Business { get; set; }
    public virtual Customer Customer { get; set; }
    [Required]
    [Display(Name = "First Name")]
    public string FirstName { get; set; }
    [Required]
    [Display(Name = "Last Name")]
    public string LastName { get; set; }
}

Business.cs

public class Business : ApplicationUser
{
    public string BusinessUserId { get; set; }
    [Required]
    public string BusinessName { get; set; }
    [Required]
    [Display(Name = "Address")]
    public string Address { get; set; }

    public ICollection<Customer> Customers { get; set; }

    ....
}

客户.cs

    public class Customer : ApplicationUser
    {
       public string CustomerUserId { get; set; }
       public override Business Business { get; set; }
    }

瑞安

您正在使用TPH，它将与上述实体进入同一表（AspNetUser）。

要使用TPT，您可以配置以下模型

public class ApplicationUser : IdentityUser
{

    public string BusinessId { get; set; }
    [ForeignKey("BusinessId")]
    public virtual Business Business { get; set; }

    public string CustomerId { get; set; }
    [ForeignKey("CustomerId")]
    public virtual Customer Customer { get; set; }

    [Required]
    [Display(Name = "First Name")]
    public string FirstName { get; set; }
    [Required]
    [Display(Name = "Last Name")]
    public string LastName { get; set; }
}

public class Business
{
    [Key]
    public string BusinessUserId { get; set; }
    [Required]
    public string BusinessName { get; set; }
    [Required]
    [Display(Name = "Address")]
    public string Address { get; set; }

    public virtual ApplicationUser User { get; set; }
    public ICollection<Customer> Customers { get; set; }

}

public class Customer 
{
    [Key]
    public string CustomerUserId { get; set; }

    public string BusinessId { get; set; }
    [ForeignKey("BusinessId")]
    public  Business Business { get; set; }

    public virtual ApplicationUser User { get; set; }
}

DbContext：

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
        : base(options)
    {

    }


    public DbSet<Customer> Customers { get; set; }
    public DbSet<Business> Businesses { get; set; }

}

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。