Combining Models for view in an MVC3 Web Application
I have an MVC3 web application that is Code first and I have the database, and controllers for each table set up.

Everything is working fine, but now I want to take it to the next step - I want to be able to combine information from these models into one view and filter out information to display.

Example : 

PersonID; PersonName; ManagerDepartment; HireDate;

ManagerID; ManagerName; ManagerDepartment

I can easily set up a Model, Controller, and View here to display and edit, etc...  But I want to create a view that displays Employees in his department whose hire date is after a given date or something.

I am coming from Silverlight and have a good idea of the MVVM pattern, but not how it fits into MVC3.

I would assume that I need to create a view model with linq queries and perform some sort of filtering but every question that I see asked has a different way of doing this.

Thanks in advance,

Patrick
Combining Models for view in an MVC3 Web Application
===

I have an MVC3 web application that is Code first and I have the database, and controllers for each table set up.

Everything is working fine, but now I want to take it to the next step - I want to be able to combine information from these models into one view and filter out information to display.

Example : 

PersonID; PersonName; ManagerDepartment; HireDate;

ManagerID; ManagerName; ManagerDepartment

I can easily set up a Model, Controller, and View here to display and edit, etc...  But I want to create a view that displays Employees in his department whose hire date is after a given date or something.

I am coming from Silverlight and have a good idea of the MVVM pattern, but not how it fits into MVC3.

I would assume that I need to create a view model with linq queries and perform some sort of filtering but every question that I see asked has a different way of doing this.

Thanks in advance,

Patrick