Ordering with Linq to SQL c#.NET WCF

Question

I have a model called ProjectVersion which has the following properties:

    int Major
    int Minor
    int Patch
    int? Revision
    string PreRelease
    string MetaData

Now I am trying to order the versions in decreasing order according to the Semantic Versioning 2.0.0 specification where precedence is Major > Minor > Patch > PreRelease

I'm also using Entity framework and Linq to get my data, here is the code I'm currently using:

Note: all less than'<' and greater than '>' signs in the code below are replaced with pipes '|' due to my inexperience with stackoverblow.

 public List|ProjectVersionDataContract| GetProjectVersions(int projectId)
        {
            // TODO: Evaluate Versioning system and order list according to it's specification.
            var versions = new List|ProjectVersionDataContract|();
            using (var context = new Entities())
            {
                var vers = context.ProjectVersions.Where(v => v.ProjectId == projectId)
                    .OrderBy(v => v.MajorVersion)
                    .ThenBy(v => v.MinorVersion)
                    .ThenBy(v => v.PatchVersion)
                    .ThenBy(v => v.RevisionVersion)
                    .ThenBy(v => v.PreReleaseVersion).ToList();

                // This uses the AutoMapper package to map the Data Object to the Data Contract
                versions.AddRange(vers.Select(Mapper.Map|ProjectVersion, ProjectVersionDataContract|));
            }

            return versions;
        }

Now this get's my data but it returns it with the lowest (oldest) version first, which is opposite of what I want. I've even tried changing the .OrderBy() to OrderByDescending() with no difference. This is a WCF service if that makes any difference.

didn't realize that was a function, I'll try it and let you know. — Oxymoron
– Oxymoron, Commented Aug 7, 2013 at 4:07
updated the query to var vers = context.ProjectVersions.Where(v => v.ProjectId == projectId) .OrderBy(v => v.MajorVersion) .ThenBy(v => v.MinorVersion) .ThenBy(v => v.PatchVersion) .ThenBy(v => v.RevisionVersion) .ThenBy(v => v.PreReleaseVersion).Reverse().ToList(); got the following: — Oxymoron
– Oxymoron, Commented Aug 7, 2013 at 4:09
LINQ to Entities does not recognize the method 'System.Linq.IQueryable'1[Data.Model.ProjectVersion] Reverse[ProjectVersion](System.Linq.IQueryable'1[Data.Model.ProjectVersion])' method, and this method cannot be translated into a store expression. — Oxymoron
– Oxymoron, Commented Aug 7, 2013 at 4:09

Damith · Accepted Answer · 2013-08-07 04:14:48Z

0

try

var vers = context.ProjectVersions.Where(v => v.ProjectId == projectId)
                    .OrderByDescending(v => v.MajorVersion)
                    .ThenByDescending(v => v.MinorVersion)
                    .ThenByDescending(v => v.PatchVersion)
                    .ThenByDescending(v => v.RevisionVersion)
                    .ThenByDescending(v => v.PreReleaseVersion).ToList();

Or you can do as below

var normal = GetProjectVersions(idval);
var finalResult =normal.Reverse();

answered Aug 7, 2013 at 4:14

Damith

63.2k13 gold badges105 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Oxymoron Over a year ago

I did the last one. worked great. Thank you for the response.

Collectives™ on Stack Overflow

Ordering with Linq to SQL c#.NET WCF

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related