How To Project a Line Number Into Linq Query Results

by

Well, the easiest way would be to do it at the client side rather than the database side, and use the overload of Select which provides an index as well:

public List<ScoreWithRank> GetHighScoresWithRank(string gameId, int count)
{
    Guid guid = new Guid(gameId);
    using (PPGEntities entities = new PPGEntities())
    {
        var query = from s in entities.Scores
                    where s.Game.Id == guid
                    orderby s.PlayerScore descending
                    select new
                    {
                        PlayerName = s.PlayerName,
                        PlayerScore = s.PlayerScore
                    };

        return query.AsEnumerable() // Client-side from here on
                    .Select((player, index) => new ScoreWithRank()
                            {
                                PlayerName = player.PlayerName,
                                PlayerScore = player.PlayerScore,
                                Rank = index + 1;
                            })
                    .ToList();

    }
}

More Related Contents:

  1. Convert this sql command to c# linq
  2. LINQ equivalent of foreach for IEnumerable
  3. Is it possible to Pivot data using LINQ?
  4. C# LINQ find duplicates in List
  5. What are the benefits of a Deferred Execution in LINQ?
  6. Entity framework linq query Include() multiple children entities
  7. How can I do an OrderBy with a dynamic string parameter?
  8. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  9. LINQ Partition List into Lists of 8 members [duplicate]
  10. LINQ recursion function?
  11. Convert String to Int in EF 4.0
  12. System.LINQ.Dynamic: Select(” new (…)”) into a List (or any other enumerable collection of )
  13. LINQ: Dot Notation vs Query Expression
  14. Learning about LINQ [closed]
  15. LINQ Join with Multiple Conditions in On Clause
  16. Standard Deviation in LINQ
  17. Calculate difference from previous item with LINQ
  18. Use LINQ to concatenate multiple rows into single row (CSV property)
  19. LINQ with SQLite (linqtosql)
  20. How to create a dynamic LINQ join extension method
  21. PowerShell equivalent of LINQ Any()?
  22. Instantiating a context in LINQ to Entities
  23. conditional include in linq to entities?
  24. LINQ not updating on .SubmitChanges()
  25. Linq To Entities – how to filter on child entities
  26. Is there a pattern using Linq to dynamically create a filter?
  27. Entity Framework, Code First and Full Text Search
  28. Simple Linq query has duplicated join against same table?
  29. Linq to SQL how to do “where [column] in (list of values)”
  30. How to implement Unit of Work that works with EF and NHibernate

Leave a Comment