'EF Core Exception Details
How do I load the the nested property collection within the datamodel.
EF Core SQL Data Exception : "Invalid Column Name SipKpiID" when I try to run the code below:
public List<SipKpi> GetSpiKpiMaster()
{
return _db.SipKpi.Include(x => x.SipKpiCriteria).Include(x =>
x.SIPPointSlabDetails).ToList();
}
Below is the code for dataModel class
public class SipKpi
{
[Key]
public int SipKpiID { get; set; }
public int CountryId { get; set; }
public string CountryCode { get; set; }
public int BusinessId { get; set; }
public string BusinessGroupCode { get; set; }
public string SipKpiName { get; set; }
public string EvaluationMethod { get; set; }
public int MinimumPointsEligibility { get; set; }
public int MinimumKPICriteriaEligibility { get; set; }
public string KPIPayoutType { get; set; }
public string KPIPayoutFrequency { get; set; }
public bool BusinessTargetFlag { get; set; }
public bool BusinessProductTargetFlag { get; set; }
public bool SalesBusinessTargetFlag { get; set; }
public bool SalesBusinessProductTargetFlag { get; set; }
public virtual ICollection<SipKpiCriteria> SipKpiCriteria { get; set; }
public virtual ICollection<SIPPointSlabDetails> SIPPointSlabDetails { get; set; }
}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
