How to Display Rows in Ascending Order Using SelectMany Method

Question

Hi,

I have one method, which is returning few records using SelectMany method, but it is not returning in Ascending order.

Can someone help me in this regard, I have explained complete scenario in pdf file, code of the method is pasted below. Many Thanks in advance.

 private IEnumerable<string> FetchValues(string perforationType, bool? bdhFastInUse, Func<ValveLiftDto, string> selectParameter) =>         valveLiftsLegLengths             .Where(v => v.PerforationType == perforationType                         && (v.PerforationType != PerforationType.BDH.ToString() || v.BdhFastInUse == bdhFastInUse))             .Select(selectParameter)             .Where(value => !string.IsNullOrEmpty(value))             .SelectMany(value => value.GetCommaSeparatedList())             .Distinct();

If I select up to "Where" while debugging, I can see the rows in Ascending order, in horizontal manner.

 valveLiftsLegLengths
            .Where(v => v.PerforationType == perforationType
                        && (v.PerforationType != PerforationType.BDH.ToString() || v.BdhFastInUse == bdhFastInUse))
            .Select(selectParameter)
            .Where(value => !string.IsNullOrEmpty(value))

But if I select up to "SelectMany", I am getting rows not as Ascending, but in some different order in vertical like..

11.1 mm

12.7 mm

7.9 mm

9.5 mm

 valveLiftsLegLengths
            .Where(v => v.PerforationType == perforationType
                        && (v.PerforationType != PerforationType.BDH.ToString() || v.BdhFastInUse == bdhFastInUse))
            .Select(selectParameter)
            .Where(value => !string.IsNullOrEmpty(value))
            .SelectMany(value => value.GetCommaSeparatedList())

Answer 1

The result order should be each comma separated list, appended in the original order.

Answer 2

I have just removed .Order in below method and it worked.

public static IEnumerable<string> GetCommaSeparatedList(this string values)
        => values
            .Split(",")
            .Select(value => value.Trim())
            .DistinctValues()
            .Order();

Answer 3

I have just removed .Order in below method and it worked.

public static IEnumerable<string> GetCommaSeparatedList(this string values)
        => values
            .Split(",")
            .Select(value => value.Trim())
            .DistinctValues()
            .Order();