Combine 2 fields in Linq

Ramco Ramco

I have below data and i want to get StudentId, Name+MobileNo

var Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students
                               where t2.MentorID == Convert.ToInt32(ddlMentor.SelectedItem.Value)
                               select new { t2.StudentID,t2.Name,t2.MobileNo}).Distinct().ToList();

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajkiran Swain3y ago
Accepted answer
var Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students
where t2.MentorID == Convert.ToInt32(ddlMentor.SelectedItem.Value)
select new { t2.StudentID, FullName = $"{t2.Name} {t2.MobileNo}" })
.Distinct()
.ToList();