title: Concatenating String in LINQ-to-Entities
body: <p>This code works if I take out</p>
  
  <blockquote>
    <ul>
    <li>" " + p.MIDDLE_NAME</li>
    </ul>
  </blockquote>
  
  <p>Thus the remaining code looks like:</p>
  
  <blockquote>
    <p>p.FIRST_NAME + " " + p.LAST_NAME</p>
  </blockquote>
  
  <p>Maybe LINQ-to-Entities just doesn't support concatenating more than two strings at a time?</p>
  
  <pre><code>    Protected Sub btnFilter_Click(sender As Object, e As EventArgs) Handles btnFilter.Click
      Dim dbContext As Campus6Entities = New Campus6Entities
      Using dbContext
          Dim find_students = From p In dbContext.PEOPLE _
                              Let Full_Name = p.FIRST_NAME + " " + p.MIDDLE_NAME + " " + p.LAST_NAME _
                              Where Full_Name = txtFilterText.Text _
                              Select p.FIRST_NAME, p.MIDDLE_NAME, p.LAST_NAME, p.PEOPLE_CODE_ID
  
          rptrFilteredStudents.DataSource = find_students
          rptrFilteredStudents.DataBind()
      End Using
  End Sub
  </code></pre>