C#•3y ago

EFCore 8 - Owned type with navigation property not being included

Hello, i have an issue with EFCore (or maybe it's just me being pepega), but i have a class Score that have a Tracker field as an owned type:

class Score {
    [Key]
    public uint ID {get; set;}
    public bool HasTrackers { get; set; }

    public Trackers Trackers { get; set; } = new Trackers() ;
}

class Score {
    [Key]
    public uint ID {get; set;}
    public bool HasTrackers { get; set; }

    public Trackers Trackers { get; set; } = new Trackers() ;
}

class Score {
    [Key]
    public uint ID {get; set;}
    public bool HasTrackers { get; set; }

    public Trackers Trackers { get; set; } = new Trackers() ;
}

class Score {
    [Key]
    public uint ID {get; set;}
    public bool HasTrackers { get; set; }

    public Trackers Trackers { get; set; } = new Trackers() ;
}

And here is the tracker class:

[Owned]
[SuppressMessage("ReSharper", "InconsistentNaming")]
public class Trackers
{
    public HitTracker?        HitTracker      { get; set; } = null;
    public WinTracker?        WinTracker      { get; set; } = null;
    public AccuracyTracker?   AccuracyTracker { get; set; } = null;
    public ScoreGraphTracker? GraphTracker    { get; set; } = null;
}

[Owned]
[SuppressMessage("ReSharper", "InconsistentNaming")]
public class Trackers
{
    public HitTracker?        HitTracker      { get; set; } = null;
    public WinTracker?        WinTracker      { get; set; } = null;
    public AccuracyTracker?   AccuracyTracker { get; set; } = null;
    public ScoreGraphTracker? GraphTracker    { get; set; } = null;
}

[Owned]
[SuppressMessage("ReSharper", "InconsistentNaming")]
public class Trackers
{
    public HitTracker?        HitTracker      { get; set; } = null;
    public WinTracker?        WinTracker      { get; set; } = null;
    public AccuracyTracker?   AccuracyTracker { get; set; } = null;
    public ScoreGraphTracker? GraphTracker    { get; set; } = null;
}

[Owned]
[SuppressMessage("ReSharper", "InconsistentNaming")]
public class Trackers
{
    public HitTracker?        HitTracker      { get; set; } = null;
    public WinTracker?        WinTracker      { get; set; } = null;
    public AccuracyTracker?   AccuracyTracker { get; set; } = null;
    public ScoreGraphTracker? GraphTracker    { get; set; } = null;
}

and lastly the HitTracker class:

[SuppressMessage("ReSharper", "InconsistentNaming")]
public class HitTracker
{
    [Required]
    [Key]
    [ForeignKey(nameof(Score))]
    public uint ScoreID { get; set; }

    public int   MaxCombo     { get; set; }
}

[SuppressMessage("ReSharper", "InconsistentNaming")]
public class HitTracker
{
    [Required]
    [Key]
    [ForeignKey(nameof(Score))]
    public uint ScoreID { get; set; }

    public int   MaxCombo     { get; set; }
}

[SuppressMessage("ReSharper", "InconsistentNaming")]
public class HitTracker
{
    [Required]
    [Key]
    [ForeignKey(nameof(Score))]
    public uint ScoreID { get; set; }

    public int   MaxCombo     { get; set; }
}

[SuppressMessage("ReSharper", "InconsistentNaming")]
public class HitTracker
{
    [Required]
    [Key]
    [ForeignKey(nameof(Score))]
    public uint ScoreID { get; set; }

    public int   MaxCombo     { get; set; }
}

(obvisouly i'm only sending what's usefull here, it's not the whole classes but it doesn't matter)

My issue that that, when querying Context.RankedScore, including RankedScore.Score, then
Score.Trackers.HitTracker, i'm not getting any trackers. nor if i include them all the way like this:

m_Context.RankedScores.Where(p_X => p_X.ID == id)
            .AsNoTracking().Include(p_X => p_X.Score).ThenInclude(p_Y => p_Y.Trackers).ThenInclude(p_Tracker => p_Tracker.HitTracker);

m_Context.RankedScores.Where(p_X => p_X.ID == id)
            .AsNoTracking().Include(p_X => p_X.Score).ThenInclude(p_Y => p_Y.Trackers).ThenInclude(p_Tracker => p_Tracker.HitTracker);

m_Context.RankedScores.Where(p_X => p_X.ID == id)
            .AsNoTracking().Include(p_X => p_X.Score).ThenInclude(p_Y => p_Y.Trackers).ThenInclude(p_Tracker => p_Tracker.HitTracker);

m_Context.RankedScores.Where(p_X => p_X.ID == id)
            .AsNoTracking().Include(p_X => p_X.Score).ThenInclude(p_Y => p_Y.Trackers).ThenInclude(p_Tracker => p_Tracker.HitTracker);

I don't know if i should use a Owned class to achieve this behavior, but i simply wanted to have the child perperties wrapped into an object called Trackers so it makes more sence in the backend and in the front end, instead of doing Score.HitTracker, Score.Trackers.HitTracker seems better to me.

Does anyone know how to resolve my issue?

I'm getting this (it should include the HitTracker, not null, it doesn't include any of them actually)

"hasTrackers": true,
      "trackers": {
        "hitTracker": null,
        "winTracker": null,
        "accuracyTracker": null,
        "graphTracker": null
      }

"hasTrackers": true,
      "trackers": {
        "hitTracker": null,
        "winTracker": null,
        "accuracyTracker": null,
        "graphTracker": null
      }

"hasTrackers": true,
      "trackers": {
        "hitTracker": null,
        "winTracker": null,
        "accuracyTracker": null,
        "graphTracker": null
      }

"hasTrackers": true,
      "trackers": {
        "hitTracker": null,
        "winTracker": null,
        "accuracyTracker": null,
        "graphTracker": null
      }

Here is the output as sql (just the interesting part):

 FROM `RankedScores` AS `r`
      INNER JOIN `Scores` AS `s` ON `r`.`ScoreID` = `s`.`ID`
      LEFT JOIN `AccuracyTracker` AS `a` ON `s`.`Trackers_AccuracyTrackerScoreID` = `a`.`ScoreID`
      WHERE `r`.`ID` = @__id_0

 FROM `RankedScores` AS `r`
      INNER JOIN `Scores` AS `s` ON `r`.`ScoreID` = `s`.`ID`
      LEFT JOIN `AccuracyTracker` AS `a` ON `s`.`Trackers_AccuracyTrackerScoreID` = `a`.`ScoreID`
      WHERE `r`.`ID` = @__id_0

 FROM `RankedScores` AS `r`
      INNER JOIN `Scores` AS `s` ON `r`.`ScoreID` = `s`.`ID`
      LEFT JOIN `AccuracyTracker` AS `a` ON `s`.`Trackers_AccuracyTrackerScoreID` = `a`.`ScoreID`
      WHERE `r`.`ID` = @__id_0

 FROM `RankedScores` AS `r`
      INNER JOIN `Scores` AS `s` ON `r`.`ScoreID` = `s`.`ID`
      LEFT JOIN `AccuracyTracker` AS `a` ON `s`.`Trackers_AccuracyTrackerScoreID` = `a`.`ScoreID`
      WHERE `r`.`ID` = @__id_0

EFCore 8 - Owned type with navigation property not being included

Similar Threads

Similar Threads

Similar Threads