var query = (from Enquiry in context.tbl_Enquiry
join Course in context.tbl_Course on Enquiry.CourseID equals
Course.CourseID
where Enquiry.SEnquiryID == SEnquiryID && Course.status.Equals("A")
select new
{
Enquiry,Course
}).ToList()
.Select(x=>new{x.Enquiry.EnquiryID,x.Course.CourseID, cname=x.Course.Name,x.Enquiry.EnquiryDate,x.Enquiry.Status,
Followupdate = (from Follow in context.tbl_FollowupAdmission
where Follow.EnquiryID == x.Enquiry.EnquiryID
orderby Follow.Followupdate descending
select Follow.Followupdate).FirstOrDefault()
});