Thank you so much
very Wonderful
I'm starting to get it
Now can I use it IN join LINQ sql same this
Exam_Entity _db = new Exam_Entity();
var task = ((from a in _db.AdminUsers
join g in _db.exams_GAT_SAT
on a.user_id equals g.sch_id.ToString()
where a.user_type == 3 && g.ayear == 1442
orderby g.SAT_av descending
select new
{
user_id = a.user_id,
user_name = a.user_name,
SAT_av = g.SAT_av,
GAT_S_av = g.GAT_S_av,
GAT_T_av = g.GAT_T_av,
SAT_or = g.SAT_or,
GAT_S_or = g.GAT_S_or,
GAT_T_or = g.GAT_T_or,
HSC_av = g.HSC_av,
}).AsEnumerable().Select(x => new Exams_Trans_GaT_SaS
{
user_id = x.user_id,
user_name = x.user_name,
SAT_av = x.SAT_av,
GAT_S_av = x.GAT_S_av,
GAT_T_av = x.GAT_T_av,
SAT_or = x.SAT_or,
GAT_S_or = x.GAT_S_or,
GAT_T_or = x.GAT_T_or,
HSC_av = x.HSC_av,
}).ToList());