Is this a bug in JSON.NET or Entity Framework or am I doing something wrong while trying to serialize a list of Exceptions with JSON.NET?

entity-framework-6 exception json.net serialization

Question

Got this error when trying to serialize a set of errors:

"'System.Data.Entity.Infrastructure' is an ISerializable type. The constructor for DbUpdateConcurrencyException is invalid. A constructor that accepts SerializationInfo and StreamingContext parameters must exist in order to properly implement ISerializable."

The base classes do contain a constructor, however it is aprotected member.

A request was made to view the JSON:

{
    "$type": "System.Data.Entity.Infrastructure.DbUpdateConcurrencyException, EntityFramework",
    "ClassName": "System.Data.Entity.Infrastructure.DbUpdateConcurrencyException",
    "Message": "Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=472540 for information on understanding and handling optimistic concurrency exceptions.",
    "Data": {
        "$type": "System.Collections.ListDictionaryInternal, mscorlib"
    },
    "InnerException": {
        "$type": "System.Data.Entity.Core.OptimisticConcurrencyException, EntityFramework",
        "ClassName": "System.Data.Entity.Core.OptimisticConcurrencyException",
        "Message": "Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=472540 for information on understanding and handling optimistic concurrency exceptions.",
        "Data": {
            "$type": "System.Collections.ListDictionaryInternal, mscorlib"
        },
        "InnerException": null,
        "HelpURL": null,
        "StackTraceString": "   at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.ValidateRowsAffected(Int64 rowsAffected, UpdateCommand source)\r\n   at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()\r\n   at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.<Update>b__2(UpdateTranslator ut)\r\n   at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update[T](T noChangesResult, Func`2 updateFunction)\r\n   at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update()\r\n   at System.Data.Entity.Core.Objects.ObjectContext.<SaveChangesToStore>b__35()\r\n   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)\r\n   at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction)\r\n   at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass2a.<SaveChangesInternal>b__27()\r\n   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)\r\n   at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction)\r\n   at System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options)\r\n   at System.Data.Entity.Internal.InternalContext.SaveChanges()",
        "RemoteStackTraceString": null,
        "RemoteStackIndex": 0,
        "ExceptionMethod": "8\nValidateRowsAffected\nEntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\nSystem.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator\nVoid ValidateRowsAffected(Int64, System.Data.Entity.Core.Mapping.Update.Internal.UpdateCommand)",
        "HResult": -2146233087,
        "Source": "EntityFramework",
        "WatsonBuckets": null
    },
    "HelpURL": null,
    "StackTraceString": "   at System.Data.Entity.Internal.InternalContext.SaveChanges()\r\n   at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()\r\n   at System.Data.Entity.DbContext.SaveChanges()\r\n   at REDACTED FOR DISPLAY ON STACKOVERFLOW",
    "RemoteStackTraceString": null,
    "RemoteStackIndex": 0,
    "ExceptionMethod": "8\nSaveChanges\nEntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\nSystem.Data.Entity.Internal.InternalContext\nInt32 SaveChanges()",
    "HResult": -2146233087,
    "Source": "EntityFramework",
    "WatsonBuckets": null,
    "SafeSerializationManager": {
        "$type": "System.Runtime.Serialization.SafeSerializationManager, mscorlib",
        "m_serializedStates": {
            "$type": "System.Collections.Generic.List`1[[System.Object, mscorlib]], mscorlib",
            "$values": [
                {
                    "$type": "System.Data.Entity.Infrastructure.DbUpdateException+DbUpdateExceptionState, EntityFramework",
                    "InvolvesIndependentAssociations": false
                }
            ]
        }
    },
    "CLR_SafeSerializationManager_RealType": "System.Data.Entity.Infrastructure.DbUpdateConcurrencyException, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
}

The following sample code raises the exception:

var serializationSettings = new JsonSerializerSettings() {
    DateFormatHandling = DateFormatHandling.IsoDateFormat,
    DateParseHandling = DateParseHandling.DateTime,
    DateTimeZoneHandling = DateTimeZoneHandling.RoundtripKind,
    DefaultValueHandling = DefaultValueHandling.Include,
    TypeNameHandling = TypeNameHandling.All,
    TypeNameAssemblyFormat = System.Runtime.Serialization.Formatters.FormatterAssemblyStyle.Simple,
    ObjectCreationHandling = ObjectCreationHandling.Replace, //Necessary for subclassing list types
    ConstructorHandling = ConstructorHandling.AllowNonPublicDefaultConstructor
};

var json = JsonConvert.SerializeObject( new System.Data.Entity.Infrastructure.DbUpdateConcurrencyException( "hi" ), serializationSettings );
if (json == null)
    return null;
var err = JsonConvert.DeserializeObject<System.Data.Entity.Infrastructure.DbUpdateConcurrencyException>( json, serializationSettings ); //throws error

Even stranger, this class is unusual in that it does not explicitly implement a constructor with the anticipated signature, as one responder points out, which makes the situation even stranger. Instead, the class's decompilation reveals some sort of, blatantly obvious "justification" for not implementing the anticipated constructor.

/// <summary>
/// Exception thrown by <see cref="T:System.Data.Entity.DbContext" /> when the saving of changes to the database fails.
/// Note that state entries referenced by this exception are not serialized due to security and accesses to the
/// state entries after serialization will return null.
/// </summary>
[SuppressMessage("Microsoft.Design", "CA1032:ImplementStandardExceptionConstructors",
    Justification = "SerializeObjectState used instead")]
[Serializable]
public class DbUpdateException : DataException
{
    /// <summary>
    /// Holds exception state that will be serialized when the exception is serialized.
    /// </summary>
    [Serializable]
    private struct DbUpdateExceptionState : ISafeSerializationData
    {
1
2
3/10/2016 4:42:35 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

The Json.net documentation claims that

ISerializable

Types that implement ISerializable are serialized as JSON objects. When serializing, only the values returned from ISerializable.GetObjectData are used; members on the type are ignored. When deserializing, the constructor with a SerializationInfo and StreamingContext is called, passing the JSON object's values.

In situations where this behavior is not wanted, the JsonObjectAttribute can be placed on a .NET type that implements ISerializable to force it to be serialized as a normal JSON object.

as you don't owe theDbUpdateConcurrencyException class, An alternative would be to develop a unique exception class that derives from theDbUpdateConcurrencyException and add an attribute.JsonObject .

    [JsonObject]
    class CustomException : DbUpdateConcurrencyException
    {
        public CustomException(string message) : base(message) { }
    }

     // Serialize the new customException
     var json = JsonConvert.SerializeObject(
         new CustomException("hi"), serializationSettings);

     //shall not throw error now
     DbUpdateConcurrencyException err = 
          JsonConvert.DeserializeObject<DbUpdateConcurrencyException>(json, serializationSettings);

This is merely a proof-of-concept that I tried to adapt to JSON.Net. Making custom classes for every type that inherits makes no sense.ISerializable and lacks the necessary constructor. Perhaps you could try making a Castle core.DynamicProxy generator to wrap the exceptions that are thrownISerializable and put a mark on themJsonObject attribute dynamically prior to serialization.

You're correct, too. Because inheritance follows this pattern, Json.net cannot locate the protected constructor.

DbUpdateConcurrencyException <- DbUpdateException <- DataException

Additionally, the Protected constructor that json.net requires is present in the DataException class. Every.Net Framework exception class that is derived fromSystemException a protected constructor for this one, butDbUpdateException && DbUpdateConcurrencyException not possess it. Now you know who is to blame (IMO EF).

The classes I discovered that lacked the typical serializable constructor and would throw exceptions during deserialization are listed below.

  • EntitySqlException
  • PropertyConstraintException
  • DbUpdateConcurrencyException
  • DbUpdateException
  • ToolingException
  • DbEntityValidationException
  • CommandLineException

This message was sent to Team EF here.

2
3/9/2016 10:51:32 PM

Related Questions

JSON serialize Entity Framework objects

It seems that neither the native DataContractJsonSerializer in WCF nor the native JavaScript serializer in ASP.NET can serialize Entity Framework objects into JSON. This is because both serializers reject references counting problems. Additionally, I attempted ...Json.NET..., which likewise fails explicitly due to a Reference Counting problem....Ed...
asp.net-ajax entity-framework json wcf
asked by Program.X

Json.Net is used to serialize Entity Framework objects.

How can I convert entity framework objects into JSON, the JavaScript Object Nucleus? I tried using ...JSON.NET..., but when I attempt to serialize it, I get the following issue....Newtonsoft.Json.JsonSerialization is an exception. Exception, "Self referencing loop" in the message...Hitesh
asp.net-mvc entity-framework javascript json.net
asked by Hitesh

What am I doing wrong with MySQL and Entity Framework?

By adding a reference to MySql.Data.Entity.dll, I was able to overcome this problem (and MySql.Web.dll)
.net entity-framework mysql nullreferenceexception visual-studio-2010
asked by Rami A.

In Json.net, serialize one to many relationships.

In the most recent version, I believe this was fixed....Look at the ...help docs... beneath the ...JSON Serialization and Deserialization: Serialization with Object Reference Preservation... portion....When setting up the JSON.Net Serializer, enter the following value:...PreserveReferencesHandling = PreserveReferencesHandling.Objects; ...So here's ...
ef-code-first entity-framework json.net serialization
asked by John Bubriski

JSON Serialization of Entity Framework Objects

public class GenericHandler : IHttpHandler { public class ASSystem { public string SID { get; set; } public string Description { get; set; } public string SystemName { get; set; } } public class ErrorObj { public string ErrorMessage { get; set; } } public void ProcessRequest(HttpContext ...
c# entity-framework javascript json
asked by Johan

serialize entity foundation object using json.net (circular reference error)

I want to serialize an entity framework entity into a json object. I did some research and discovered that json.net should be able to serialize objects with circular references "out of the box" (http://james.newtonking.com/projects/json-net.aspx). I then tried using...string json = JsonConvert.SerializeObject(/* my ef entity */); ...But I continue ...
asp.net c# entity-framework json.net
asked by Johan

Circular reference detected exception while serializing object to JSON

I am experiencing a Json serialization problem when serializing an Entity Framework Proxy, as was previously noted in post ...this...:...A circular reference was detected while serializing an object of type 'System.Data.Entity.DynamicProxies.PurchaseOrder_446B939192F161CDBC740067F174F7A6059B0F9C0EEE68CD3EBBD63CF9AF5BD0'....However, I have a circu...
asp.net-mvc-4 c# entity-framework json serialization
asked by Mathijs

Entity to json error - A circular reference was detected while serializing an object of type

When trying to convert an entity object into a JSON string, the following issue was encountered. I'm designing my database utilizing code first in C# MVC4. It appears that this problem is caused by FKs and linkages between tables. What will the solution be?...While serializing an object of type System, a circular reference was found. Data.Entity. D...
.net asp.net-mvc-4 c# entity-framework json
asked by user4111217

Store JSON data object to database in ASP.NET MVC (Entity Framework)

Your JSON should appear as follows:... var json = { "id": "123", "firstName": "John", "lastName": "Doe", "phones": [ { "number": "555-555-555" }, { "number": "444-444-444" } ], "em...
asp.net asp.net-mvc c# entity-framework json
asked by Aria

Read Entity Framework 6 Connection String from appsettings.json file in ASP.NET CORE

ZZZ_tmp
appsettings asp.net-core entity-framework-6
asked by Regianni

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow