Adding the results of two queries to ViewData.Model

Question

I have the following code in my controller:

    public ActionResult Details(int id)
    {
        var dataContext = new BuffetSuppliersDBDataContext();
        var supplier = (from m in dataContext.BO_Suppliers 
                        where m.SupplierID == id
                        select m).FirstOrDefault();

        ViewData.Model = supplier;

        return View();
    }

This renders a view which contains the properties returned from the linq to sql query. What I need to do now is add another query which will return x amount of ratings for each supplier, i will then loop through the records in the view and display the ratings.

How can I push the results of my ratings query into the view along with what is already there?

Chad Moran · Accepted Answer · 2009-01-19 05:15:45Z

1

Your best option would to be create a class that you can pass into your view.

public class SupplierDetail
{
    public Supplier { get; set; }
    public SupplierRating { get; set; }
}

public class SupplierDetailViewData
{
    public IEnumerable<SupplierDetail> SupplierDetails { get; set; }
}

Then in your controller action use a join and select a new SupplierDetail class in the LINQ query. After that you can create a strongly-typed view by using the code-behind and changing it to this...

public partial class Details : ViewPage<SupplierDetailViewData>
{
}

After that, in your view -- ViewData.Model will be SupplierDetailViewData. Of course the second part is optional but it does make for better compile-time validation.

answered Jan 19, 2009 at 5:15

Chad Moran

12.9k2 gold badges53 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

awharrier Over a year ago

Thanks for your help, I have managed to accomplish what I needed.

Collectives™ on Stack Overflow

Adding the results of two queries to ViewData.Model

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related