How to split strings using C# and Linq

Question

I want to split a string like Members in table Set and select the result with other fields as a record.

For example, lets assume the Set has 2 fields (ID, Members) and 2 records: (1, "A, B") and (2, "C").

Now I need a Linq query to retrieve records as: (1, A), (1, B), (2,C).

I am using Visual Studio 2008.

Kirk Broadhurst · Accepted Answer · 2012-07-11 05:09:32Z

1

LINQ-to-SQL won't do this, but you can retrieve this data using LINQ-to-SQL and then run straight LINQ against it.

List<Set> sets;
using (var context = new MyDataContext())
{
    sets = context.Sets.ToList();
}

var result = sets.SelectMany(s => 
    s.Members.Split(',').Select(m => new { s.ID, m }));

answered Jul 11, 2012 at 5:09

Kirk Broadhurst

28.9k20 gold badges111 silver badges179 bronze badges

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

Collectives™ on Stack Overflow

How to split strings using C# and Linq

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related