title: How do I concatenate strings in Entity Framework Query?
body: <p>How do I concatenate strings in Entity Framework 4 I have a data from a column and I want to save as a string a comma separated string like "value1, value2, value3"
  Is there a method or an operator do do this in EF4?
  Example: lets say that I have two columns <code>Fruit</code> and <code>Farms</code> with the following values:</p>
  
  <ul>
  <li>Apples</li>
  <li>Bananas </li>
  <li>Strawberries</li>
  </ul>
  
  <p>If I do like this</p>
  
  <pre>
  var dataSource = this.context
      .Farms
      .Select(f => new
          {
              f.Id, 
              Fruits = string.Join(", ", f.Fruits)
          });
  </pre>
  
  <p>Sure I will get this error</p>
  
  <blockquote>
  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.
  </blockquote>
  
  <p>Is there any solution to this?</p>