linq to entity query returns list as continuous string

Question

I have a query that looks like this:

var ChangesOthersResult = surveyResponseRepository.Query.Select(r => r.ChangesOthers);

That returns all of the entries in "ChangesOthers" column from my table.

When I return the data inside my view:

@Html.DisplayFor(modelItem => modelItem.ChangesOthersResult)

It is returning all of the data as a single continous string of text. How can I add a line break in between the columns of data that it is returning?

  var data = new ResultsViewModel() 
                        {
                            PatientFollowUpResult = PatientFollowUpResult,
                            PatientFollowUpResultPct = PatientFollowUpResultPct,

                            TotalResponsesResult = TotalResponsesResult,

                            ChangesOthersResult = ChangesOthersResult,

                        };

View Model Type

@model CMESurvey.ViewModels.ResultsViewModel

score 1 · Answer 1 · answered Jun 28 '12 at 21:26

1

<table>
    <tr>
        <th>
            HeaderName1
        </th>
    </tr>

    @foreach (var item in Model)
    {
        <tr>
            <td>
            @Html.DisplayFor(modelItem => modeItem.FieldName)
            </td>
        </tr>
    }
</table>

answered Jun 28 '12 at 21:26

Kittoes0124

4,930
3
26
47

I get an error saying "does not contain a definition for GetEnumerator" if I use a ForEach loop. – user547794 Jun 28 '12 at 21:29
@user547794 Then you're not pasting the model to the view AsEnumerable. Can you post the code that passes this to your view? – Kittoes0124 Jun 28 '12 at 21:33

score 1 · Accepted Answer · answered Jun 28 '12 at 21:37

1

Perhaps something like:

@foreach (var x in Model.ChangesOthersResult)
{
   @x<br>
}

answered Jun 28 '12 at 21:37

orip

73,323
21
116
148

Use
instead of
:) – JK. Jun 28 '12 at 21:58
@JK. not in HTML5 :) http://stackoverflow.com/questions/1946426/html-5-is-it-br-br-or-br – orip Jun 29 '12 at 14:56

score 0 · Answer 3 · answered Jun 28 '12 at 21:36

0

Razor doesn't know that you want line breaks in between each item when you use

@Html.DisplayFor(modelItem => modelItem.ChangesOthersResult)

You can literally add the line break in the select by adding the string "<br/>" to each item before selecting it:

var ChangesOthersResult = surveyResponseRepository
                             .Query
                             .Select(r => r.ChangesOthers + "<br />");

answered Jun 28 '12 at 21:36

JK.

21,477
35
135
214

I tried this but it's sending the literal text "
" (<br />) – user547794 Jun 28 '12 at 21:38

linq to entity query returns list as continuous string

3 Answers3