A circular reference was detected while serializing an object of type ‘SubSonic.Schema .DatabaseColumn’.

by

It seems that there are circular references in your object hierarchy which is not supported by the JSON serializer. Do you need all the columns? You could pick up only the properties you need in the view:

return Json(new 
{  
    PropertyINeed1 = data.PropertyINeed1,
    PropertyINeed2 = data.PropertyINeed2
});

This will make your JSON object lighter and easier to understand. If you have many properties, AutoMapper could be used to automatically map between DTO objects and View objects.

More Related Contents:

  1. Deserialize JSON into C# dynamic object?
  2. How to Convert JSON object to Custom C# object?
  3. Decimal precision and scale in EF Code First
  4. EntityType has no key defined error
  5. dotnet core System.Text.Json unescape unicode string
  6. Insert data using Entity Framework model
  7. How to get property change notifications with EF 4.x DbContext generator
  8. How to disable cascade delete for link tables in EF code-first?
  9. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  10. Problems using Entity Framework 6 and SQLite
  11. Send JSON via POST in C# and Receive the JSON returned?
  12. DataTable to JSON [duplicate]
  13. ef4 cause Circular reference in web service
  14. Ignoring null fields in Json.net
  15. Join and Include in Entity Framework
  16. Entity framework raw SQL Query
  17. Why are all the collections in my POCO are null when deserializing some valid json with the .NET Newtonsoft.Json component
  18. Global setting for AsNoTracking()?
  19. EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata
  20. Remove item from list based on condition
  21. Unable to find the requested .Net Framework Data Provider. It may not be installed
  22. How to force LINQ Sum() to return 0 while source collection is empty
  23. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  24. How do I get formatted and indented JSON in .NET using C#?
  25. How to include() nested child entity in linq
  26. Remove empty string properties from json serialized object
  27. Json.net rename properties
  28. LINQ Query to Convert string to datetime
  29. Newtonsoft JSON for .net is ignoring jsonproperty tags
  30. Parsing field name with a colon in JSON

Leave a Comment