Question

我对被审计物体有一个基级:

http://www.ohchr.org。

public class AuditableObject : DomainObject, IAuditable
{
    ... some fields

   public AuditInfo AuditInfo
   {
        get;
        set;
   }
}

<>AuditInfo

public class AuditInfo : IAuditable
{

    public int CreatedByDbId
    {
        get;
        set;
    }

    public DateTime CreatedDate
    {
        get;
        set;
    }

    public int? AmendedByDbId
    {
        get;
        set;
    }

    public DateTime? AmendedDate
    {
        get;
        set;
    }
}

The CreatedByDbId and A amendedByDb Id与系统User物体有关:

<>SystemUser

public class SystemUser
{
    public int SystemUserDbId
    {
        get;
        set;
    }

    public string Username
    {
        get;
        set;
    }
}

我有一个等级:<>Call,继承来自可审计物体的遗产,该系统还拥有其他特性:

public class Call : AuditableObject
{
    ... some fields

    public SystemUser TakenBy { get; set;}
    public SystemUser CreatedBy { get; set; }
    public SystemUser CancelledBy { get; set;}
    public int CancelledByDbId {get; set;}
    public int TakenByDbId { get; set;}
}

www.un.org/Depts/DGACM/index_spanish.htm 电话数据库表

CREATE TABLE [dbo].[Call](
[CallDbId] [int] IDENTITY(1,1) NOT NULL,
[CancelledBy] [int] NULL,
[CreatedByDbId] [int] NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[AmendedByDbId] [int] NULL,
[AmendedDate] [datetime] NULL,
[TakenBy] [int] NOT NULL)

我似乎无法正确绘制地图,例如。

modelBuilder.ComplexType<AuditInfo>();
...// configuration for Call
this.Property(x => x.AuditInfo.AmendedByDbId).HasColumnName("AmendedByDbId");
this.Property(x => x.AuditInfo.AmendedDate).HasColumnName("AmendedDate");
this.Property(x => x.AuditInfo.CreatedByDbId).HasColumnName("CreatedByDbId");
this.Property(x => x.AuditInfo.CreatedDate).HasColumnName("CreatedDate");

this.Property(t => t.CancelledByDbId).HasColumnName("CancelledBy");
this.Property(t => t.TakenByDbId).HasColumnName("TakenBy");

this.HasRequired(t => t.TakenBy).WithMany().HasForeignKey(x => x.TakenByDbId);
this.HasRequired(t => t.CancelledBy).WithMany().HasForeignKey(x => x.CancelledByDbId);

并且我总是在运行时出现错误,例如:

Invalid column name  SystemUser_SystemUserDbId .
Invalid column name  SystemUser_SystemUserDbId1 .
Invalid column name  SystemUser_SystemUserDbId2 .
Invalid column name  CreatedBy_SystemUserDbId .

我可以 figure一 figure一 figure:

Answer 1

最后一个错误 页: 1 创建By_SystemUserDbId“是因为没有绘制地图。 CreatedBy Navigation property to 数据库中外国关键栏目。它希望:



this.HasRequired(t => t.CreatedBy)
    .WithMany()
    .Map(c => c.MapKey("CreatedByDbId"));


我不知道目前其他三个错误的原因。

<><>Edit>/strong>

我感到,这一模式确实是困难的,或者也许不可能绘制地图。


You have a navigation property CreatedBy on the class Call but the foreign key property CreatedByDbId on a complex type AuditInfo of the base class AuditableObject. I have doubt that you can define in the mapping that these properties belong together in the same relationship to SystemUser.

因此,导航财产<代码>CreatedBy 外国钥匙<代码> 创建ByDbId。但是,这是不可能的,因为你不能将航行财产置于一种复杂的类型之中。

是否需要为<代码>AuditInfo使用一种复杂的类型? 页: 1 缩略语

public class AuditableObject : DomainObject, IAuditable
{
    ... some fields

    public int CreatedByDbId { get; set; }
    public DateTime CreatedDate { get; set; }
    public int? AmendedByDbId { get; set; }
    public DateTime? AmendedDate { get; set; }
}

如果你能够这样做,你就能够移动<代码>。 CreatedBy Navigation property from the Call entities to the Auditable 反对: “FKCreatedByDbId的基类,然后就另外两种导航特性绘制了你已经做的同样的地图,但基类的这一次是:
modelBuilder.Entity<AuditableObject>() .HasRequired(a => a.CreatedBy) .WithMany() .HasForeignKey(a => a.CreatedById);

友情链接