You don't need to add AsNoTracking with select they aren't tracked , asnotracking becomes redundant in this case.