You can convert the entity object to list Object by looping the LINQ Query results and adding the object to the list.
The following example code clears how to convert to List Object
public ActionResult GetChart()
{
List<object>chartData = new List<object>();
chartData.Add(new object[]{
"ShipCity", "TotalOrders"
});
var result = (from order in db.Orders.AsEnumerable()
group order by order.ShipCity into rowGroup
select new
{
ShipCity =rowGroup.Key,
TotalOrders =rowGroup.Count()
}).Distinct().ToList();
foreach (var c in result)
{
chartData.Add(new object[]
{
c.ShipCity, c.TotalOrders
});
}
return new JsonResult
{
Data = new
{
success = chartData,
message = "Success",
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
}
Output:
Post your comments / questions
Recent Article
- ImportError: cannot import name 'url' from 'django.conf.urls' - Django Error
- How to Enable Virtualization in BIOS Security Settings in Intel Processors For Android Studio?
- Dependency 'androidx.activity:activity:1.8.0' requires libraries and applications that depend on it.
- AttributeError: 'NoneType' object has no attribute 'get_text' - Python
- ModuleNotFoundError: No module named 'openpyxl' - Python
- How to get thumbnail from vimeo video URL in Python?
- Remove all special characters, punctuation except spaces from string - Python
- OSError: cannot write mode RGBA as JPEG- Python
Related Article