I don't use Include()
Company and CompetencyLevel object but i can see data of Company and CompetencyLevel on frontend. Does the result variable contain data that i don't need. I don't want that. How can i fix it?
[HttpGet("CompetencyExamPlan")]
public ActionResult<BaseGridResponse<object>> CompetencyExamPlan()
{
var response = new BaseGridResponse<object>();
var result =
from staff in _context.Entity<Staff>()
join compReq in _context.Entity<CompetencyRequirementDetail>() on staff.Id equals compReq.StaffId into compReqs
from compReq in compReqs.DefaultIfEmpty()
select new object()
{
CompetencyDefinition = compReq != null && compReq.CompetencyLevel != null ? compReq.CompetencyLevel.Definition : "",
CompanyName = staff != null & staff.Company != null ? staff.Company.Name : "",
};
List<object> resultList = result.ToList<object>();
response.Data = resultList;
return response;
}
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…