LINQ, can’t join to string

by

I would suggest doing the string.Join operation locally instead using AsEnumerable:

var q = from i in _dbContext.Users
        where i.UserId != null
        select new
        {
            FirstName = i.FirstName,
            LastName = i.LastName,
            Question4Parts = _dbContext.MultipleQuestions
                                       .Where(a => a.MultipleQuestionType.KEY == 
                                                   MultipleQuestionKeys.BENEFITS)
                                       .Select(a => a.Question)
        };

return q.AsEnumerable()
        .Select(x => new ITW2012Mobile.ViewModels.AdminSurveyReportModel
                     {
                         FirstName = x.FirstName,
                         LastName = x.LastName,
                         Question4 = string.Join(", ", x.Question4Parts)
                     })
        .ToList();

More Related Contents:

  1. Why is LINQ JOIN so much faster than linking with WHERE?
  2. Why use LINQ Join on a simple one-many relationship?
  3. LINQ to Entities does not recognize the method
  4. Which method performs better: .Any() vs .Count() > 0?
  5. What is the difference between IQueryable and IEnumerable?
  6. LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
  7. How to do SQL Like % in Linq?
  8. Linq to Entities – SQL “IN” clause
  9. Case insensitive string compare in LINQ-to-SQL
  10. “Or” equivalent in Linq Where() lambda expression
  11. How do I get the MAX row with a GROUP BY in LINQ query?
  12. LINQ Single vs First
  13. Read PDF using itextsharp where PDF language is non-English
  14. Linq int to string
  15. EF LINQ include multiple and nested entities
  16. C# Unicode string output
  17. .NET List Concat vs AddRange
  18. .NET LINQ query syntax vs method chain
  19. Ignore namespaces in LINQ to XML
  20. Does LINQ work with IEnumerable?
  21. How to use “contains” or “like” in a dynamic linq query?
  22. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  23. Why does IQueryable.All() return true on an empty collection?
  24. How to Convert LINQ Comprehension Query Syntax to Method Syntax using Lambda
  25. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  26. Why are some object properties UnaryExpression and others MemberExpression?
  27. Retrieving work items and their linked work items in a single query using the TFS APIs
  28. Linq: What is the difference between Select and Where
  29. How to Convert Row to Column in Linq and SQL
  30. How to return a page of results from SQL?

Leave a Comment