title: How can I concatenate multiple fields into 1 result?
body: <p>We've got a table in SQL Server that has values that are to appear in a couple of textboxes, if those textboxes are initially empty. Then the user can either add more details to the pre-loaded text, or remove it, whatever. It's to get the user started. Here's the table's schema:</p>
  
  <pre><code>CREATE TABLE [dbo].[PreloadTextbox](
  [PreLoadNumber] [smallint] NOT NULL,
  [DisplayOrder] [smallint] NOT NULL,
  [LineToDisplay] [varchar](100) NULL,
  CONSTRAINT [PK_PreloadTextbox] PRIMARY KEY CLUSTERED 
  (
  [PreLoadNumber] ASC,
  [DisplayOrder] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
  ) ON [PRIMARY]
  </code></pre>
  
  <p>This table was initially used for a VB6 app written many years ago. We're re-writing it in WPF using C#. The field PreLoadNumber is associated with the textbox it's associated with, and of course the DisplayOrder is what order the records should appear in. What we should do is combine all of the records in the table into 1 large record, change the LineToDisplay from a VARCHAR(100) to VARCHAR(MAX), but that will have to wait until another day, as this table is still being used by the old VB6 app.</p>
  
  <p>So what I'm hoping to find out is this; is it possible to combine all LineToDisplay for say PreLoadNumber == 1 (in the order specified by DisplayOrder) using LINQ? And if so, how is that done?</p>