How to convert string array to string in Linq to entities?

Question

I have the linq query below

var dd = (from dt in d
          select new
          {
              dt.id,
              dt.date,
              dt.customerid,
              dt.customer,
              dt.Description,
              dt.defect,
              dt.address,
              products = string.Join(",", dt.products)
          }).ToList();

string.Join didn't work, the error is

LINQ to Entities does not recognize the method 'System.String Format(System.String, System.Object, System.Object)'

I Googled a lot and couldn't find any other solution. What I want to do is, dt.Products is an array and I want to join it all together in a string. Is it possible in Linq to Entities?

p.s.w.g · Accepted Answer · 2013-11-15 15:53:48Z

6

You won't be able to do that within the query, but you can do it in memory by calling .AsEnumerable() first. Try this:

var dd = 
    (from dt in d
     select new
     {
         dt.id,
         dt.date,
         dt.customerid,
         dt.customer,
         dt.Description,
         dt.defect,
         dt.address,
         dt.products
     })
    .AsEnumerable()
    .Select(dt => new {
         dt.id,
         dt.date,
         dt.customerid,
         dt.customer,
         dt.Description,
         dt.defect,
         dt.address,
         products = string.Join(",", dt.products)
    }).ToList();

Note, however, if your data set is particularly large, this could cause a noticeable performance impact.

edited Nov 15, 2013 at 15:53

answered Nov 15, 2013 at 15:25

p.s.w.g

150k31 gold badges307 silver badges339 bronze badges

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

Collectives™ on Stack Overflow

How to convert string array to string in Linq to entities?

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