Not sorting By Date

Question

Hi I have below code but it is not sorting by Date List Result = (from t in context.Sessions where t.GroupID == GroupID orderby t.SessionDate select t).ToList(); Thanks

Tuhin Paul · Answer

If you only need to access the SessionDate property and not the entire Session object, use Select to project the results to a new collection of DateTime objects var Result = context.Sessions .Where(t => t.GroupID == GroupID) .OrderBy(t => t.SessionDate) .Select(t => t.SessionDate) .ToList();

Tuhin Paul · Answer

Use implicit typing (var) to improve readability var Result = context.Sessions .Where(t => t.GroupID == GroupID) .OrderBy(t => t.SessionDate) .ToList();

Rajkiran Swain · Answer

Ensure that the SessionDate property of the Session class is of type DateTime or a compatible type. Sorting may not work correctly if the property is not of a compatible type. Verify that the values of the SessionDate property are not null or uninitialized. If they are, you may need to filter out those sessions before sorting the list. Try adding the ascending keyword to the orderby clause to explicitly specify the sorting order: List Result = (from t in context.Sessions where t.GroupID == GroupID orderby t.SessionDate ascending select t).ToList(); You can also try using the OrderBy extension method instead of the orderby clause: List Result = context.Sessions .Where(t => t.GroupID == GroupID) .OrderBy(t => t.SessionDate) .ToList(); If none of these suggestions work, you may need to provide more information about the problem, such as the data types and values of the relevant properties, any error messages or exceptions, and the version of .NET you are using.