Why Can I not do a subrequest for a Partial View for each request?

Question

In _Layout.cshtml, I have this part of code

<div>
      @Html.Action("BestStudent", "Student")
</div>

In Student Controller I have created BestStudent method as below

public class StudentController : Controller
{
    private UniversityInitial dbAllStudents  = new UniversityInitial();

    [ChildActionOnly]
    public ActionResult BestStudent()
    {
        var best = dbAllStudents.Students
            .Where(s => s.LastName.StartsWith("M")&s.FirstName.StartsWith("E") & s.City.StartsWith("T"));
        return PartialView("_BestStudent", best);
    }
}

In Views/Shared folder I have created the Partial View named _BestStudent.cshtml strongly typed for Student model as below:

@model UniversityApp.Models.Student

<h3 class="text-danger">Student of the year</h3>
Name : @Model.FirstName
Last Name : @Model.LastName
City: @Model.City

Build succeed but when I run it I got one exception like:

"Error executing child request for handler 'System.Web.Mvc.HttpHandlerUtil...

and the breakpoint is to the line of code below:

<div>
    @Html.Action("BestStudent", "Student")
</div>

So I guess something wrong happens here, but I can not figure it out what

Because your query returns a collection of `Student`, not a single `Student` which is required by your view (hence an exception is thrown). Change the query to add `.FirstOrDefault()` — , Jan 10 '17 at 21:52
@StephenMuecke Your suggest worked perfectly and was exactly what I needed. — Dea, Jan 10 '17 at 22:00
read this carefully : http://stackoverflow.com/help/someone-answers — Masoud Andalibi, Jan 10 '17 at 22:21
@StephenMuecke please include the answer so he can accept it. — Masoud Andalibi, Jan 10 '17 at 22:26
@Valkyriee, You should just edit your answer (I was not even sure if OP wanted a single `Student` or collection - in which case the view would have need to be `@model IEnumerable` with a `foreach` loop) — , Jan 10 '17 at 22:36
@StephenMuecke i didn't ask mate =) i did answer. yeah me too actually i had no idea if its a list/object he wanted to return, he needs to edit his question. — Masoud Andalibi, Jan 10 '17 at 22:39
Oops, that comment was supposed to say 'answer', not 'question' :) — , Jan 10 '17 at 22:41

Masoud Andalibi · Answer 1 · 2017-01-11T09:26:47.510

1

Update

Fix this Query like below:

var best = dbAllStudents.Students
                        .Where(s => s.LastName.StartsWith("M")&s.FirstName.StartsWith("E") & s.City.StartsWith("T")).FirstOrDefault();
return PartialView("_BestStudent", best);

Credit Goes to @StephenMuecke

edited Jan 11 '17 at 09:26

answered Jan 10 '17 at 21:55

Masoud Andalibi

3,168
5
18
44

Why Can I not do a subrequest for a Partial View for each request?

1 Answers1