Order by Name

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();

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();

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();

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. 
 

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();

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();