c# Lambda Query fetching one of the property weirdly null

asp.net c# entity-framework entity-framework-6 model-view-controller


    public ActionResult SecondMission(string Id)
        CATSDDEntities db = new CATSDDEntities();
        db.Configuration.ProxyCreationEnabled = false;
        var setAlet= db.Setalets.Where(x => x.Aletler.Barkod == Id && x.Bolum == 1).Include(x => x.Aletler.AletAD).Include(x => x.Setler).FirstOrDefault();
        if (setAlet == null)
            return Json("Error, Alet Not Found!", JsonRequestBehavior.AllowGet);
            setAlet.Bolum = 2;
            var MissionTwoSets = db.Setalets.Where(x => x.Bolum == 2 && x.SetId==setAlet.SetId).Include(x => x.Aletler.AletAD).Include(x => x.Setler).GroupBy(x => x.SetId).ToList();
            return PartialView("~/Views/Shared/_SecondMissionSetPartial.cshtml", MissionTwoSets);

I am calling this method by ajax

When i call this method first time.. Aletler property of MissionTwoSets have data.. but when i call this method second time and fetch multiple data.. one of the item get null in Aletler(LOOK) .. its quite weird.. im using the same code somewhere else using same data and working fine..

7/26/2018 6:11:40 PM

Accepted Answer

Includes are ignored (have no effect) in GroupBy queries, so normally the navigation properties would be null.

However what you see is a result of the context tracking. Since you first load a single entity, it's eager loaded properties are not null. Then when you execute the GroupBy which result includes the already loaded (tracked) entity, then EF reuses that instance and hence it would still have navigation properties populated. All other entities would have null navigation properties due to the aforementioned "ignored includes".

Since the GroupBy query like this makes no sense to be executed server side (has no SQL equivalent), the solution is to execute the GroupBy part client side (by inserting the typical AsEnumerable() before it), thus keeping the includes in effect:

var MissionTwoSets = db.Setalets
    .Where(x => x.Bolum == 2 && x.SetId==setAlet.SetId)
    .Include(x => x.Aletler.AletAD)
    .Include(x => x.Setler)
    .AsEnumerable() // <-- switch to LINQ to Objects
    .GroupBy(x => x.SetId)
7/26/2018 6:25:16 PM

Related Questions


Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow