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.
Asp.Net HeinPosted Jun 22, 2015, 11:01 PM
Upendra Pratap ShahiPosted Jun 22, 2015, 8:31 AM