ASP .NET MVC SELF Join query for view

Question

0.00/5 (No votes)

See more:

Hi
Please Help

I am using LINQ Self Join Query to display data on the view .my sql query contains some employees details .i need to show employee details with their Manager Name .

but when i use my var type of resultant list of i get runtime exception

my code is in controller action

var emp = from m in t.Employees
join e1 in t.Employees on m.ManagerID equals e1.EmployeeID
select new { Id = m.EmployeeID , Name = m.Name, Manager = e1.Name , Designation = m.Designation,Phone =m.Phone ,address = m.Address };

return View(emp);

and in view
@model IEnumerable <mvc4application.models.employee>

and getting error

The model item passed into the dictionary is of type System.Data.Objects.ObjectQuery`1[<>f__AnonymousType1`6[System.Int32,System.String,
System.String,System.String,System.Nullable`1[System.Int32],System.String]]', but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable`1[Mvc4application.Models.Employee]'.]
System.Web.Mvc.ViewDataDictionary`1.SetModel(Object value) +405487

Off Course i am understanding this because my view is using Mvc4application.Models.Employee type .

any solution is appreciated .as i am not able to convert it to model type .

Posted 11-Jul-13 3:30am

gauravupadhyay

Updated 11-Jul-13 3:31am

v2

Add a Solution

Comments

Mukesh Ghosh 11-Jul-13 9:32am

What you have added in your aspx page header?

gauravupadhyay 11-Jul-13 9:36am

I am creating a MVC app and using RAZOR View engine .i am not using aspx.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Yuriy Loginov · Answer 1 · 2013-07-11T04:38:00

Solution 1

you need to materialize the query,

C#

return View(emp.ToList());

Posted 11-Jul-13 4:38am

Yuriy Loginov

Comments

gauravupadhyay 12-Jul-13 0:45am

I got this after using ---return View(emp.ToList());

[InvalidOperationException: The model item passed into the dictionary is of type 'System.Collections.Generic.List`1[<>f__AnonymousType1`6[System.Int32,System.String,System.String,System.String,System.Nullable`1[System.Int32],System.String]]', but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable`1[Mvc4application.Models.Employee]'.]

return View(emp.ToList());

Is there any way to use return list to use as model in ASP.NET MVC View

Yuriy Loginov 12-Jul-13 8:09am

I think the problem may be that new { Id = m.EmployeeID , Name = m.Name, Manager = e1.Name , Designation = m.Designation,Phone =m.Phone ,address = m.Address }; does not match the Mvc4application.Models.Employee definition. One way to check is to do this return View(emp.ToList<<mvc4application.models.employee>>());
If you get an exception when you run that it means you should check to make sure that the fields you have in your model are the same fields that you are declaring inside the anonymous type that your are using. This means that the names and the types of fields should match up exactly to your model