How to String Array convert String Value, in linq line?

Question

I used string.join but not working.

 IQueryable<CandidateVModel> list = cRepository.Table.Where(x=> !x.CFDemand.Any(y => y.AStatusId == (int) TStatus.SWork)).Select(x => new CandidateVModel
        {
            ...
            Email = x.Email,
            Tags = x.Tags,
            Comments= string.Join(", ",x.CFDemand.SelectMany(y=>y.JInterview.SelectMany(z=>z.JInterviewer.SelectMany(t=>t.JInterviewerFeedback.Select(a=>a.Comments))))),
            Ref= x.Ref
        }).AsExpandable().Where(p);

Error:Message = "LINQ to Entities does not recognize the method 'System.String Join(System.String, System.Collections.Generic.IEnumerable`1[System.String])' method, and this method cannot be translated into a store expression."

That needs to be seriously re-thought.... I got lost after the first select many let alone the next 3. This is a code smell to me... — Callum Linington
– Callum Linington, Commented Dec 17, 2015 at 16:54
There's no SQL equivalent to String.Joinso EF cannot translate that to SQL. If you can provide more detail as to your data model you may get some help pulling both sets and joining them in Linq-to-Objects. — D Stanley
– D Stanley, Commented Dec 17, 2015 at 16:57

John · Accepted Answer · 2015-12-17 16:59:48Z

0

Without digging too much into this, one way to resolve LINQ to Entities does not recognize the method issues is to simplify what you're getting from the database, and create a helper property on your viewmodel like so:

    [IgnoreDataMember]
    public IEnumerable<string> CommentsFromDb
    {
        set
        {
            Comments = string.Join(", ", value);
        }
    }

[IgnoreDataMember] will keep this helper property from getting serialized.

And update your code snippit to be this:

...
CommentsFromDb = x.CFDemand.SelectMany(y=>y.JInterview.SelectMany(z=>z.JInterviewer.SelectMany(t=>t.JInterviewerFeedback.Select(a=>a.Comments))))

answered Dec 17, 2015 at 16:59

John

17.6k17 gold badges69 silver badges87 bronze badges

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

Collectives™ on Stack Overflow

How to String Array convert String Value, in linq line?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related