var z = from x in eb.trainings
where x.IDNo.Distinct().Count() <= 1
join y in eb.members on
x.IDNo equals y.IDNo
where y.Nationality == "Singaporean Citizen"
select y.IDNo.Count();
This code is in error.. So that can anyone help me to solve my problem with only LINQ.
Thanks in advanced.