Display results of two queries in view using asp.net MVC2

Answer 1

Create a special object that contains two items of the types returned by your queries. Then you can access them with Model.depot and Model.Address in your View.

Answer 2

You would need to create a ViewModel that has the following paramters:

public IQueryable<CSLA_DEPOT> depots {get; set;}
public IQueryable<CSLA_ADDRESS> addresses {get; set;}

You would then need to create an instance of this new View Model in your controller like so:

var model = new ViewModelName(){
    depots = db.CSLA_DEPOT.Where(c => c.DEPOT_ID == id.Value),
    addresses = db.CSLA_ADDRESS.Where(a => a.CSLA_DEPOT.DEPOT_ID == id.Value),
};

You would then need to pass this model to your view like so:

return View(model);

In your view you would access the two different collections like so:

Model.depots
Model.addresses

Hope this helps, leave me a comment if you have any questions.

Answer 3

DevDave, thanks for the help. I'll try your advice when I get back to the office on tuesday.I'm out for the next 5 days.