将多个导航属性配置到同一表时出错

问题描述

我在同一个表格上有多个导航属性，这很奇怪.

我的FuelBunkerType POCO类的配置如下:

 公共类FuelBunkerType:IEventReportElement{公开长号{放;}公共字符串TypeKey {get;放;}公共字符串TypeValue {get;放;}公有小数?硫{放;}公有小数?水{得到;放;}公有小数?粘度{放;}公有小数?密度{放;}公共字符串BdnNumber {get;放;}公共长?IdEventReport {get;放;}公共长?DeactivatedByIdEventReport {get;放;}公共IList< FuelBunkerQuantity>FuelBunkerQuantitys {get;放;}public EventReport EventReport {get;放;}公共EventReport DeactivatedByEventReport {get;放;}} 

在DbContext中，我的类的配置如下:

  modelBuilder.Entity< FuelBunkerType>().HasKey(x => x.Id);if(_writeversion)modelBuilder.Entity< FuelBunkerType>().Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);else modelBuilder.Entity< FuelBunkerType>().Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);modelBuilder.Entity< FuelBunkerType>().HasRequired(x => x.EventReport).WithMany().HasForeignKey(x => x.IdEventReport);modelBuilder.Entity< FuelBunkerType>().HasOptional(x => x.DeactivatedByEventReport).WithMany().HasForeignKey(x => x.DeactivatedByIdEventReport); 

到目前为止，太好了.直到星期五，它实际上都是这样工作的.但是，当我尝试现在从表中获取数据时，结果查询看起来像

  {SELECT1 AS [C1]，[Extent1].[Id] AS [Id]，[Extent1].[TypeKey] AS [TypeKey]，[Extent1].[TypeValue] AS [TypeValue]，[Extent1].[Sulphur] AS [Sulphur]，[Extent1].[Water] AS [Water]，[Extent1].[Viscosity] AS [Viscosity]，[Extent1].[Density] AS [Density]，[Extent1].[BdnNumber] AS [BdnNumber]，[Extent1].[IdEventReport] AS [IdEventReport]，[Extent1].[DeactivatedByIdEventReport] AS [DeactivatedByIdEventReport]，[Extent1].[EventReport_Id] AS [EventReport_Id]从[FuelBunkerType] AS [Extent1]} 

这显然会导致列名无效"错误，因此忽略了我的第一条配置行(Entity().HasRequired(x => x.EventReport)...).我尝试注释掉DeactivatedByEventReport的配置，它导致除DeactivatedByEventReport_Id之外的其他查询(与预期的一样)，它仅在同一表的多个导航属性中发生.但是，当我在EventReport中添加更多导航属性时，它只会错误地查询EventReport_Id，因此，在存在多个导航属性时，似乎只有第一个会被忽略.

任何想法为什么会发生这种情况，以及如何解决此问题?问候

对于与此对应的其他类，有以下Fluent API配置:

  if(_writeversion)modelBuilder.Entity< EventReport>().Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);else modelBuilder.Entity< EventReport>().Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);modelBuilder.Entity< EventReport>().HasKey(x => x.Id);modelBuilder.Entity< EventReport>().Property(x => x.Id).HasColumnName("Id");modelBuilder.Entity< EventReport>().Ignore(x => x.MaxEventTimeLt);modelBuilder.Entity< EventReport>().Ignore(x => x.MaxEventTimeUtc);modelBuilder.Entity< EventReport>().Ignore(x => x.MinEventTimeLt);modelBuilder.Entity< EventReport>().Ignore(x => x.MinEventTimeUtc);modelBuilder.Entity< EventReport>().Ignore(x => x.EventReportElementTyps);modelBuilder.Entity< EventReport>().Ignore(x => x.EventsWithUpdatedSortNumber);modelBuilder.Entity< EventReport>().Ignore(x => x.EventTimeUtcLoaded);modelBuilder.Entity< EventReport>().Ignore(x => x.HasChanged);modelBuilder.Entity< FuelBunkerQuantity>().HasKey(x => x.Id);if(_writeversion)modelBuilder.Entity< FuelBunkerQuantity>().Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);else modelBuilder.Entity< FuelBunkerQuantity>().Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);modelBuilder.Entity< FuelBunkerQuantity>().HasOptional(x => x.FuelBunkerType).WithMany().HasForeignKey(x => x.IdFuelBunkerType);//modelBuilder.Entity<FuelBunkerQuantity>().HasOptional(x => x.EventReport).WithMany().HasForeignKey(x => x.IdEventReport);modelBuilder.Entity< FuelBunkerQuantity>().忽略(x => x.EventReport); 

EventReport上的Config不会起作用，因为您可以看到我禁用了FuelBunkerQuantity的导航属性，以尝试是否引起错误，但是丝毫没有改变Error或产生的查询./p>

类EventReport:

 公共类EventReport{公开长号{放;}公共长?SortNumber {get;放;}公共字符串ReportType {放;}公开DateTime?CreationTimeUtc {get;放;}公开DateTime?EventTimeUtc {get;放;}公开DateTime?EventTimeUtcLoaded {get;放;}公开DateTime?EventTimeLt {get;放;}公共长?EventDuration {get;放;}公开DateTime?LastSendAtUtc {get;放;}公开DateTime?LastSendAtLt {get;放;}公开DateTime?FirstSendAtUtc {get;放;}公开DateTime?FirstSendAtLt {get;放;}公共字符串EventQualityState {get;放;}公共布尔IsDraft {get;放;}[IgnoreOnEqualCheck]公共IEnumerable< FuelBunkerRob>FuelRoB {获取；放;}[IgnoreOnEqualCheck]公共IEnumerable< OilBunkerRob>OilRoB {get;放;}[IgnoreOnEqualCheck]公共列表< FuelBunkerType>ActiveFuelTypes {get;放;}[IgnoreOnEqualCheck]公开DateTime?MaxEventTimeUtc {get;放;}[IgnoreOnEqualCheck]公开DateTime?MaxEventTimeLt {get;放;}[IgnoreOnEqualCheck]公开DateTime?MinEventTimeUtc {get;放;}[IgnoreOnEqualCheck]公开DateTime?MinEventTimeLt {get;放;}公共列表< EventReport>EventsWithUpdatedSortNumber {get;放;}公共长?ConfigurationId {get;放;}公共布尔HasChanged {放;}公共列表< IEventReportElement>EventReportElements {get;放;}} 

我只是跳过了导致错误的语句.原来FuelBunkerQuantity的翻译也有错误(请参见编辑"中的配置):

  {SELECT1 AS [C1]，[Extent1].[Id] AS [Id]，[Extent1].[IdFuelBunkerType] AS [IdFuelBunkerType]，[Extent1].[MassDelta] AS [MassDelta]，[Extent1].[MassAbsolut] AS [MassAbsolut]，[Extent1].[IdEventReport] AS [IdEventReport]，[Extent1].[FuelBunkerType_Id] AS [FuelBunkerType_Id]来自[FuelBunkerQuantity] AS [Extent1]} 

似乎有些东西坏了，但我不知道是什么.

解决方案

在您配置 EventReport 和 FuelBunkerType 之间的两个一对一关系时，EF多方面的一个集合无法匹配这些关系.取决于集合属性 ActiveFuelTypes 所属的关系，您可以像这样明确地映射它:

  modelBuilder.Entity< FuelBunkerQuantity>().HasOptional(x => x.FuelBunkerType).WithMany(e => e.ActiveFuelTypes).HasForeignKey(x => x.IdFuelBunkerType); 

I am having a weird issue with multiple navigation Properties to the same table.

My FuelBunkerType POCO class is configured like the following:

    public class FuelBunkerType : IEventReportElement
{

    public long Id { get; set; }
    public string TypeKey { get; set; }
    public string TypeValue { get; set; }
    public decimal? Sulphur { get; set; }
    public decimal? Water { get; set; }
    public decimal? Viscosity { get; set; }
    public decimal? Density { get; set; }
    public string BdnNumber { get; set; }
    public long? IdEventReport { get; set; }
    public long? DeactivatedByIdEventReport { get; set; }

    public IList<FuelBunkerQuantity> FuelBunkerQuantitys { get; set; }
    public EventReport EventReport { get; set; }
    public EventReport DeactivatedByEventReport { get; set; }
}

In the DbContext, my class is configured like:

    modelBuilder.Entity<FuelBunkerType>().HasKey(x => x.Id);
        if (_writeversion) modelBuilder.Entity<FuelBunkerType>().Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);
        else modelBuilder.Entity<FuelBunkerType>().Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
        modelBuilder.Entity<FuelBunkerType>().HasRequired(x => x.EventReport).WithMany().HasForeignKey(x => x.IdEventReport);
        modelBuilder.Entity<FuelBunkerType>().HasOptional(x => x.DeactivatedByEventReport).WithMany().HasForeignKey(x => x.DeactivatedByIdEventReport);

So far, so good. It actually worked like this until friday. However, when I try to fetch data from the table now, the resulting Query looks like

{SELECT
1 AS [C1],
[Extent1].[Id] AS [Id],
[Extent1].[TypeKey] AS [TypeKey],
[Extent1].[TypeValue] AS [TypeValue],
[Extent1].[Sulphur] AS [Sulphur],
[Extent1].[Water] AS [Water],
[Extent1].[Viscosity] AS [Viscosity],
[Extent1].[Density] AS [Density],
[Extent1].[BdnNumber] AS [BdnNumber],
[Extent1].[IdEventReport] AS [IdEventReport],
[Extent1].[DeactivatedByIdEventReport] AS [DeactivatedByIdEventReport],
[Extent1].[EventReport_Id] AS [EventReport_Id]
FROM [FuelBunkerType] AS [Extent1]}

which obviously results in a "column name is not valid" error, so my first Configuration line (Entity().HasRequired(x=>x.EventReport)...) is ignored.I tried out commenting out the Configuration for DeactivatedByEventReport, it resulted in the same query except for DeactivatedByEventReport_Id (like expected), it only happens with multiple Navigation Properties to the same table.However, when I add more navigation properties to EventReport, it only mistakenly queries for EventReport_Id, so only the first one seems to be ignored when there are multiple navigation properties.

Any ideas why this happens, and what to do to solve this? Greetings

EDIT: For the other classes corresponding to this, there are the following Fluent API configs:

if (_writeversion) modelBuilder.Entity<EventReport>().Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);
        else modelBuilder.Entity<EventReport>().Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
        modelBuilder.Entity<EventReport>().HasKey(x => x.Id);
        modelBuilder.Entity<EventReport>().Property(x => x.Id).HasColumnName("Id");
        modelBuilder.Entity<EventReport>().Ignore(x => x.MaxEventTimeLt);
        modelBuilder.Entity<EventReport>().Ignore(x => x.MaxEventTimeUtc);
        modelBuilder.Entity<EventReport>().Ignore(x => x.MinEventTimeLt);
        modelBuilder.Entity<EventReport>().Ignore(x => x.MinEventTimeUtc);
        modelBuilder.Entity<EventReport>().Ignore(x => x.EventReportElementTyps);
        modelBuilder.Entity<EventReport>().Ignore(x => x.EventsWithUpdatedSortNumber);
        modelBuilder.Entity<EventReport>().Ignore(x => x.EventTimeUtcLoaded);
        modelBuilder.Entity<EventReport>().Ignore(x => x.HasChanged);

      modelBuilder.Entity<FuelBunkerQuantity>().HasKey(x => x.Id);
        if (_writeversion) modelBuilder.Entity<FuelBunkerQuantity>().Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);
        else modelBuilder.Entity<FuelBunkerQuantity>().Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
        modelBuilder.Entity<FuelBunkerQuantity>().HasOptional(x => x.FuelBunkerType).WithMany().HasForeignKey(x => x.IdFuelBunkerType);
        //modelBuilder.Entity<FuelBunkerQuantity>().HasOptional(x => x.EventReport).WithMany().HasForeignKey(x => x.IdEventReport);
        modelBuilder.Entity<FuelBunkerQuantity>().Ignore(x => x.EventReport);

The Configs on EventReport shouldn't effect anything, as you can see I disabled the navigation property on FuelBunkerQuantity to try if this was causing the error, but it didn't change the Error or the resulting Query in the slightest.

EDIT2: The class EventReport:

public class EventReport
{
    public long Id { get; set; }


    public long? SortNumber { get; set; }
    public string ReportType { get; set; }
    public DateTime? CreationTimeUtc { get; set; }


    public DateTime? EventTimeUtc { get; set; }

    public DateTime? EventTimeUtcLoaded { get; set; }
    public DateTime? EventTimeLt { get; set; }
    public long? EventDuration { get; set; }
    public DateTime? LastSendAtUtc { get; set; }
    public DateTime? LastSendAtLt { get; set; }
    public DateTime? FirstSendAtUtc { get; set; }
    public DateTime? FirstSendAtLt { get; set; }
    public string EventQualityState { get; set; }
    public bool IsDraft { get; set; }

    [IgnoreOnEqualCheck]
    public IEnumerable<FuelBunkerRob> FuelRoB { get; set; }
    [IgnoreOnEqualCheck]
    public IEnumerable<OilBunkerRob> OilRoB { get; set; }
    [IgnoreOnEqualCheck]
    public List<FuelBunkerType> ActiveFuelTypes { get; set; }
    [IgnoreOnEqualCheck]
    public DateTime? MaxEventTimeUtc { get; set; }
    [IgnoreOnEqualCheck]
    public DateTime? MaxEventTimeLt { get; set; }
    [IgnoreOnEqualCheck]
    public DateTime? MinEventTimeUtc { get; set; }
    [IgnoreOnEqualCheck]
    public DateTime? MinEventTimeLt { get; set; }


    public List<EventReport> EventsWithUpdatedSortNumber {get; set;}


    public long? ConfigurationId { get; set; }


    public bool HasChanged { get; set; }
    public List<IEventReportElement> EventReportElements { get; set; }
}

EDIT3: I just skipped the Statement which was causing the error. Turns out FuelBunkerQuantity has wrong Translation as well (see configuration in Edit):

{SELECT
1 AS [C1],
[Extent1].[Id] AS [Id],
[Extent1].[IdFuelBunkerType] AS [IdFuelBunkerType],
[Extent1].[MassDelta] AS [MassDelta],
[Extent1].[MassAbsolut] AS [MassAbsolut],
[Extent1].[IdEventReport] AS [IdEventReport],
[Extent1].[FuelBunkerType_Id] AS [FuelBunkerType_Id]
FROM [FuelBunkerQuantity] AS [Extent1]}

Seems like something is broken, but I have no idea what.

解决方案

As you are configuring two one-to-may relationships between EventReport and FuelBunkerType and there is only one collection on the many side EF can't match the relationships. Depending on which relationship the collection property ActiveFuelTypes belongs to you can explicitly map it like this:

modelBuilder.Entity<FuelBunkerQuantity>().
             HasOptional(x => x.FuelBunkerType).
             WithMany(e => e.ActiveFuelTypes).
             HasForeignKey(x => x.IdFuelBunkerType);

这篇关于将多个导航属性配置到同一表时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！