title: How do I write a SQL Concat in Linq?
body: <p>What is the best approach to take to write a concat in Linq? I know that the official word is that you can't but I've heard that there are ways you can accomplish it and I need help to do this. I have a SQL Statement that reads as follows:</p>
  
  <pre><code>CONCAT(
     [event_organiser] ,
     ' ', DATEPART(dd,[event_start]),
     '/', DATEPART(mm, [event_start])) 
     AS organiser_info
  </code></pre>
  
  <p>I need to create this in Linq but I'm not sure how to based on my current setup.  Here is my current select statement.</p>
  
  <pre><code>var datacontext = db.tbl_events.AsQueryable();
  
  IQueryable&lt;EventsViewModel&gt; theevent = (
  
               from v in datacontext
               where v.event_start == null
               select new EventsViewModel
               {
                   event_idx = v.event_idx,
                   event_name = v.event_name
                   ...concat goes here..
               });
  </code></pre>