pass query with parameter to view

Question

Controller:

 public ActionResult Univ(short id) {

        var db = new DbEntities();

        var query = from u in db.Universitates
                     join f in db.Facultates on u.IDUniv equals f.IDUniv
                     join s in db.Specializares on f.IDFac equals s.IDFac
                     where u.IDUniv == id
                     select new SearchViewModel
                     {
                         NumeUniv = u.NumeUniv,
                         OrasUniv = u.OrasUniv,
                         IDUniv = u.IDUniv,
                         NumeFac = f.NumeFac,
                         NumeSpec = s.NumeSpec
                     };

        return View(query);
    }

View:

@model Proj.Models.SearchViewModel

<h3>@Model.NumeUniv</h3>

I have the following error:

The model item passed into the dictionary is of type
'System.Data.Entity.Infrastructure.DbQuery`1[Proj.Models.SearchViewModel]',
but this dictionary requires a model item of type 'Proj.Models.SearchViewModel'.

Why is this?

Chintana Meegamarachchi · Accepted Answer · 2014-03-23 23:34:16Z

1

The query is returning a enumerable list of SearchViewModel while your view is only looking for a single SearchViewModel.

Please try return View(query.First());

answered Mar 23, 2014 at 23:34

Chintana Meegamarachchi

1,8201 gold badge12 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

pass query with parameter to view

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related