Passing records grouped using group by in LINQ to a MVC View

Anjali

12y19.2kLINQ

I have a table with products details and i want to group it by supplierId and pass the query result to a MVC view which throws error " The model item passed into the dictionary is of type 'System.Collections.Generic.List`1<>f__AnonymousType`2[System.Int32,System.Linq.IGrouping`2, but this dictionary requires a model item of type"
My table is:
ProductDetails
ProductId
SKU
SupplierId
Package
Price
I want to group it according to the supplier. Pls help me in how to pass the LINQ grouped query result to a MVC view. and how to display the recrds in groups in the View.
TIA.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi12y ago
hi,
Try
custom Models required....
public class ProductDetail
    {
        public int ProductId { get; set; }
        public string SKU { get; set; }
        public int SupplierId { get; set; }
        public string Package { get; set; }
        public double Price { get; set; }
    }
    public class RenderView
    {
        public int SupplierId { get; set; }
        public IEnumerable ProductDetails { get; set; }
    }
// Controller Action method
public ActionResult Index()
        {
            List l = new List();
            l.Add(new ProductDetail { ProductId = 1, SKU = "test1", SupplierId = 1, Package = "", Price = 25 });
            l.Add(new ProductDetail { ProductId = 2, SKU = "test2", SupplierId = 1, Package = "", Price = 30 });
            l.Add(new ProductDetail { ProductId = 3, SKU = "test3", SupplierId = 2, Package = "", Price = 35 });
            l.Add(new ProductDetail { ProductId = 4, SKU = "test4", SupplierId = 2, Package = "", Price = 55 });
            ViewBag.Message = "Welcome to ASP.NET MVC!";
            var model = from p in l
                        group p by p.SupplierId into g
                        select new RenderView { SupplierId = g.Key, ProductDetails = g.ToList() };
            return View(model);
        }
//View
@model IEnumerable
@{
    ViewBag.Title = "Home Page";
}
@ViewBag.Message

    To learn more about ASP.NET MVC visit http://asp.net/mvc" title="ASP.NET MVC Website">http://asp.net/mvc.

@{
    foreach(var f in Model)
    {

SupplierId : @f.SupplierId

        foreach(var k in f.ProductDetails)
        {
            @k.ProductId

        }

    }
}
hope this will help you.
0
Anupam Singh12y ago
Hi,

We use group by in sql for grouping the records with aggregate function.
Same works in linq to sql.

here you mentioned you want to group records by supplierId ?
but with what. anyway let me assume you want to group by with price.

now your linq query will look like this:

var result = from p in ProductDetails
group p.Price by p.SupplierId into x
select new { SupplierId = x.Key, Price = x.sum() };

its not tested .please verify before use.
0

Passing records grouped using group by in LINQ to a MVC View

@ViewBag.Message