Order by Name

Question

Hi

In below code i want to order by name

var Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students
                                  select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo }).Distinct().ToList();

Thanks

Amit Mohanty · Answer

var Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo }) .Distinct() .OrderBy(x => x.Name) // Order by Name .ToList();

Tuhin Paul · Answer

Instead of using the + operator to concatenate strings, you can use string interpolation to make the code more concise and easier to read var Result = (from student in context.View_SessionDeliveryCalendarDetails_Students select new { student.StudentID, Name = $"{student.Name} - {student.MobileNo}" }) .Distinct() .OrderBy(x => x.Name) // Order by Name .ToList();

Naimish Makwana · Answer

Try below: var Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo }) .Distinct() .OrderBy(x => x.Name) .ToList();

Raj Bhatt · Answer

Hi You can Try Below Code For Ascending order var Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo }) .Distinct() .OrderBy(x => x.Name) .ToList(); For Descending order var Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo }) .Distinct() .OrderByDescending(x => x.Name) .ToList();

Tuhin Paul · Answer

Instead of using generic names like t2, consider using names that more accurately describe the purpose of the variables. In this case, you could use names like student or calendarDetail.

Jignesh Kumar · Answer

Hello Ramco, use below one, var Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students orderby t2.Name select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo }).Distinct().ToList();

Tuhin Paul · Answer

Although query syntax is useful for writing more declarative and readable queries, method syntax can sometimes be more concise and easier to read. var Result = context.View_SessionDeliveryCalendarDetails_Students .Select(student => new { student.StudentID, Name = $"{student.Name} - {student.MobileNo}" }) .Distinct() .OrderBy(x => x.Name) // Order by Name .ToList();