c# - LINQ result to view -

c# - LINQ result to view -

what's simple way homecoming result of linq query view?

i have linq query in controller gets result database kinda lost on how homecoming view.

controller:

public actionresult index() { if (session["userid"] == null) { homecoming redirecttoaction("index", "login"); } else { employeehomeviewmodel model = new employeehomeviewmodel(); var userid = x in db.employees x.employee_id == convert.toint32(session["userid"]) select x; //display result var project = x in db.projects x.employee_id == convert.toint32(session["userid"]) select x; foreach (project result in project) { model.project.project_id = result.project_id; model.project.project_name = result.project_name; model.project.project_detail = result.project_detail; } //display result } homecoming view(); }

view:

@model projectmanager.viewmodels.employeehomeviewmodel @{ viewbag.title = "index"; } <h2>index</h2> <div>hello, @html.displayfor(model => model.employee.employee_firstname)</div><br /> <div>current project: @html.displayfor(model => model.project.project_id)</div><br /> <div>project name: @html.displayfor(model => model.project.project_name)</div><br /> <div>details: @html.displayfor(model => model.project.project_detail)</div><br />

model:

public class employeehomeviewmodel { public employee employee { get; set; } public project project { get; set; } }

edit:

to clear, before beingness able homecoming linq query's result view, have prepare error occurs executing query in foreach loop:

linq entities not recognize method 'int32 toint32(system.object)' method, , method cannot translated store expression

you should replace return view(); return view(model);.

several overloads of controller.view method available back upwards specifying much need homecoming viewresult desire. in case, need controller.view(object) overload rather parameterless controller.view() overload; object parameter of former specify model on base of operations returned viewresult.

c# asp.net-mvc linq entity-framework razor