Alternative to using string.Join in a LINQ query?

Question

Any time I use the code below it throws the error:

Method 'System.String Join(System.String, System.Collections.Generic.IEnumerable`1[System.String])' has no supported translation to SQL.

        var items = from t in fc.table
                    where t.id== objId
                    select new
                    {
                        t.id,
                        t.name,
                        string.Join(...)
                    };

I tried using the LINQ Aggregate method but got a similar error. Any suggestions on ways to get the string.Join functionality without the error?

Also, this code compiles fine. It's when I try to do something with items that it throws the error.

I don't know much about databases but could you use a stored procedure that does the same thing as Join? — Qwertie
– Qwertie, Commented Jun 28, 2010 at 17:13
Most likely. Don't confuse the join I am talking about here with a table join though. For my situation i'd like to figure out how to do it using LINQ. — Abe Miessler
– Abe Miessler, Commented Jun 28, 2010 at 17:24
It's not possible to do everything through LINQ - only a subset of .NET functions are supported. string.Join is on the list of unsupported methods. — Tim Robinson
– Tim Robinson, Commented Jun 28, 2010 at 17:26

Tim Robinson · Accepted Answer · 2010-06-28 17:15:35Z

2

Force the query to run on the client first, to extract the raw data, then join the strings in memory:

    var items = from a in (from t in fc.table
                           where t.id== objId
                           select new
                           {
                               t.id,
                               t.name,
                               t.a, t.b, t.c
                           }).AsEnumerable()
                select new
                {
                    a.id, 
                    a.name, 
                    string.Join(",", new[] { a.a, a.b. a.c })
                };

answered Jun 28, 2010 at 17:15

Tim Robinson

54.9k12 gold badges127 silver badges141 bronze badges

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

Collectives™ on Stack Overflow

Alternative to using string.Join in a LINQ query?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related