Aqib Mehrban Aqib Mehrban - 1 year ago 100
C# Question

Placing Inner Join Linq Query Into View Model

Viewmodel:

public IEnumerable<Telephone_Search.Models.tbl_users> users;
public IEnumerable<Telephone__Search.Models.tbl_pics> images;
public IEnumerable<Telephone__Search.Models.tbl_locations> branches;


Controller:

public ActionResult Index()
{
var users = from a in db.tbl_users
where a.userid == 6
select a;

var branchjoin = (from e in db.users
join c in db.tbl_locations on e.address equals c.location
where e.userid == 6 && e.emp_address == c.location
select c).ToArray();

return this.View(new ViewModel
{
branches = branchjoin // Error here
users = users,
});
}


How do I out
c.location
into razor view within MVC ? The most common error I get is can't do conversion from IQuerable to Systems.Generic.Collection. The error is stated within the code.

Answer Source

Replace .ToArray(), with .ToList().AsQueryable(), does this do the trick?

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download