I am using asp.net entity framework, when I tried to convert entity object list to json and return jsonresult in mvc. I used json serialize, while running the application I got this following error,
Problem with this following code:
[HttpPost]
public ActionResult CreateJson()
{
try
{
using (models context = new models())
{
var CustomerList = context.Customers.ToList();
var jsondata = new JavaScriptSerializer().Serialize(CustomerList);
string path =Server.MapPath("~/Json/");
System.IO.File.WriteAllText(path + "customer.json",jsondata);
return Json(CustomerList, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ez)
{
return null;
}
}
Solution:
The database circular reference was solved by setting ProxyCreationEnabled to false. So those not to load to child objects of customer object. I have included the following line “context.Configuration.ProxyCreationEnabled = false;” in the json method.
using (models context = new models())
{
context.Configuration.ProxyCreationEnabled= false; // included the following code
var CustomerList =context.Customers.ToList();
var jsondata = new JavaScriptSerializer().Serialize(CustomerList);
string path =Server.MapPath("~/Json/");
System.IO.File.WriteAllText(path + "customer.json",jsondata);
return Json(CustomerList, JsonRequestBehavior.AllowGet);
}
Post your comments / questions
Recent Article
- ValueError:All arrays must be of the same length - Python
- Check hostname requires server hostname - SOLVED
- How to restrict access to the page Access only for logged user in Django
- Migration admin.0001_initial is applied before its dependency admin.0001_initial on database default
- Add or change a related_name argument to the definition for 'auth.User.groups' or 'DriverUser.groups'. -Django ERROR
- Addition of two numbers in django python
- The request was aborted: Could not create SSL/TLS secure channel -Error in Asp.net
- FieldError: Cannot resolve keyword 'id' into field in Django project
Related Article