Why Asp.net MVC3 Chart is not showing the image?

Question

I have got the following code that produce an image. But I'm getting the an error message.

My code:

public ActionResult Index()
    {
        eCommerceEntities db = new eCommerceEntities();

        var orders = (from c in db.Orders
                      group c by c.PaymentTypeID into g
                      select new { PaymentTypeID = g.Key, Number = g.Count() });


        var bytes = new Chart(width: 600, height: 400)
           .AddTitle("Orders")
           .DataBindTable(dataSource: orders, xField: "PaymentTypeID") 
           .GetBytes("png");

        return File(bytes, "image/png");
    }

Error Message:

Specified method is not supported.

Stack Trace:

enter image description here

Thanks in advance.

Please post the text of the stack trace.

SLaks
– SLaks

2012-02-14 17:20:37 +00:00
Commented Feb 14, 2012 at 17:20 — SLaks
– SLaks, Commented Feb 14, 2012 at 17:20

SLaks · Accepted Answer · 2012-02-14 17:20:24Z

2

It looks like the chart is trying to enumerate the LINQ query multiple times on one enumerator.

Call ToList() before passing the data to the chart.

answered Feb 14, 2012 at 17:20

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

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

Collectives™ on Stack Overflow

Why Asp.net MVC3 Chart is not showing the image?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related