Loading

Not sorting By Date

Not sorting By Date

Ramco Ramco

3y753.NET

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

3 Replies

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

Tuhin Paul3y ago
Accepted 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();
```
0

Tuhin Paul

Tuhin Paul3y ago

Use implicit typing (var) to improve readability

    var Result = context.Sessions
    .Where(t => t.GroupID == GroupID)
    .OrderBy(t => t.SessionDate)
    .ToList();

0

Rajkiran Swain3y ago
1. 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.
2. 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.
3. Try adding the ascending keyword to the orderby clause to explicitly specify the sorting order:
4. List Result = (from t in context.Sessions where t.GroupID == GroupID orderby t.SessionDate ascending select t).ToList();
5. You can also try using the OrderBy extension method instead of the orderby clause:
6. 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.
+1