Use LINQ to concatenate multiple rows into single row (CSV property)

by

That’s the GroupBy operator. Are you using LINQ to Objects?

Here’s an example:

using System;
using System.Collections.Generic;
using System.Linq;

public class Test
{
    static void Main()
    {
        var users = new[]
        {
            new { User="Bob", Hobby="Football" },
            new { User="Bob", Hobby="Golf" },
            new { User="Bob", Hobby="Tennis" },
            new { User="Sue", Hobby="Sleeping" },
            new { User="Sue", Hobby="Drinking" },
        };

        var groupedUsers = users.GroupBy(user => user.User);

        foreach (var group in groupedUsers)
        {
            Console.WriteLine("{0}: ", group.Key);
            foreach (var entry in group)
            {
                Console.WriteLine("  {0}", entry.Hobby);
            }
        }
    }
}

That does the grouping – can you manage the rest yourself?

More Related Contents:

  1. Read a CSV to a C# object to be able to do LINQ query on it [closed]
  2. Convert this sql command to c# linq
  3. LINQ equivalent of foreach for IEnumerable
  4. Is it possible to Pivot data using LINQ?
  5. What are the benefits of a Deferred Execution in LINQ?
  6. What is the opposite of GROUP_CONCAT in MySQL?
  7. Entity framework linq query Include() multiple children entities
  8. How can I do an OrderBy with a dynamic string parameter?
  9. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  10. Convert String to Int in EF 4.0
  11. System.LINQ.Dynamic: Select(” new (…)”) into a List (or any other enumerable collection of )
  12. LINQ: Dot Notation vs Query Expression
  13. LINQ Join with Multiple Conditions in On Clause
  14. Standard Deviation in LINQ
  15. How To Project a Line Number Into Linq Query Results
  16. Calculate difference from previous item with LINQ
  17. LINQ with SQLite (linqtosql)
  18. How to create a dynamic LINQ join extension method
  19. Instantiating a context in LINQ to Entities
  20. Linq To Entities – how to filter on child entities
  21. Is there a pattern using Linq to dynamically create a filter?
  22. Linq to SQL how to do “where [column] in (list of values)”
  23. CSV to object model mapping
  24. LINQ Include vs Join. Are they equivalent?
  25. Tradeoffs using NHibernate 3.0 QueryOver or LINQ provider
  26. If condition in LINQ Where clause
  27. Point connectionstring in dbml to app.config
  28. How to implement Unit of Work that works with EF and NHibernate
  29. Building Dynamic LINQ Queries based on Combobox Value
  30. NHibernate vs LINQ to SQL

Leave a Comment