更新时间:2023-09-13 17:47:04
在通常情况下,您可以将data
属性定义为List<Dictionary<string, string>>
,如下所示:
Under normal circumstances, you could define your data
property as a List<Dictionary<string, string>>
, like so:
[DataMember(Name = "data", IsRequired = true)]
public List<Dictionary<string, string>> data { get; set; }
然后,您将可以使用Json.NET成功对其进行序列化和反序列化.不幸的是,您的数据对象之一具有重复的键:
Then you would be able to serialize and deserialize it successfully with Json.NET. Unfortunately, one of your data objects has duplicated keys:
{
"groupId":"group1",
"failbackAction":"null",
"normal":"null",
"failoverAction":"null",
"failbackAction":"null",
"failoverAction":"null",
"artifactId":"mywebserver",
"normalState":"null"
},
JSON标准不建议使用重复的密钥,该声明指出:
Using duplicated keys is not recommended by the JSON standard, which states:
当对象中的名称不是唯一的时,接收到该对象的软件的行为是不可预测的.
When the names within an object are not unique, the behavior of software that receives such an object is unpredictable.
此外,c#字典当然不支持重复的键,并且数据协定序列化也不重复属性名称.
In addition, c# dictionaries of course do not support duplicated keys, and data contract serialization does not duplicated property names.
但是,可以使用Json.NET的 JsonReader
并创建一个自定义JsonConverter 来处理重复的密钥.
However, it is possible to read a JSON object with duplicated keys using Json.NET's JsonReader
and create a custom JsonConverter to handle duplicated keys.
首先,定义以下类来替换 JsonValue
. JsonValue
是Silverlight特定的类,其使用已在整个.Net中不推荐使用:
First, define the following class to replace JsonValue
. JsonValue
is a silverlight-specific class whose use has been deprecated in overall .Net:
[JsonConverter(typeof(JsonValueListConverter))]
public sealed class JsonValueList
{
public JsonValueList()
{
this.Values = new List<KeyValuePair<string, string>>();
}
public List<KeyValuePair<string, string>> Values { get; private set; }
}
class JsonValueListConverter : JsonConverter
{
public override bool CanConvert(Type objectType)
{
return typeof(JsonValueList).IsAssignableFrom(objectType);
}
public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer)
{
if (reader.TokenType == JsonToken.Null)
return null;
var jsonValue = (existingValue as JsonValueList ?? new JsonValueList());
if (reader.TokenType != JsonToken.StartObject)
throw new JsonSerializationException("Invalid reader.TokenType " + reader.TokenType);
while (reader.Read())
{
switch (reader.TokenType)
{
case JsonToken.Comment:
break;
case JsonToken.PropertyName:
{
var key = reader.Value.ToString();
if (!reader.Read())
throw new JsonSerializationException(string.Format("Missing value at path: {0}", reader.Path));
var value = serializer.Deserialize<string>(reader);
jsonValue.Values.Add(new KeyValuePair<string, string>(key, value));
}
break;
case JsonToken.EndObject:
return jsonValue;
default:
throw new JsonSerializationException(string.Format("Unknown token {0} at path: {1} ", reader.TokenType, reader.Path));
}
}
throw new JsonSerializationException(string.Format("Unclosed object at path: {0}", reader.Path));
}
public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)
{
var jsonValue = (JsonValueList)value;
writer.WriteStartObject();
foreach (var pair in jsonValue.Values)
{
writer.WritePropertyName(pair.Key);
writer.WriteValue(pair.Value);
}
writer.WriteEndObject();
}
}
请注意使用 [JsonConverter(typeof(JsonValueListConverter))]
.这指定在序列化和反序列化JsonValueList
时使用自定义转换器.
Notice the use of [JsonConverter(typeof(JsonValueListConverter))]
. This specifies the use of a custom converter when serializing and deserializing JsonValueList
.
接下来,如下定义您的Update_DB
类:
Next, define your Update_DB
class as follows:
[DataContract]
public class Update_DB
{
[DataMember(Name = "appname", IsRequired = true)]
public string appname { get; set; }
[DataMember]
public string key { get; set; }
[DataMember(Name = "data", IsRequired = true)]
public List<JsonValueList> data { get; set; }
[DataMember]
public string updateId { get; set; }
[DataMember]
public string updateTS { get; set; }
[DataMember]
public string creationUser { get; set; }
}
现在,您将能够成功地序列化和反序列化JSON.样本小提琴.
Now you will be able to serialize and deserialize your JSON successfully. Sample fiddle.
更新
如果没有重复的键,则可以按以下方式定义您的类:
If you do not have duplicated keys, you can define your class as follows:
[DataContract]
public class Update_DB
{
[DataMember(Name = "appname", IsRequired = true)]
public string appname { get; set; }
[DataMember]
public string key { get; set; }
[DataMember(Name = "data", IsRequired = true)]
public List<Dictionary<string, string>> data { get; set; }
[DataMember]
public string updateId { get; set; }
[DataMember]
public string updateTS { get; set; }
[DataMember]
public string creationUser { get; set; }
}
然后是以下内容:
var collection = new Update_DB
{
data = new List<Dictionary<string, string>>
{
new Dictionary<string, string>
{
{"data1", "10551296"},
{"data2", "TrainingIns"},
{"data3", "Completed"},
},
new Dictionary<string, string>
{
{"connectorType", "webserver-to-appserver"},
{"sourceUri", "data4"},
{"destinationUri", "data5"},
},
},
};
string x = JsonConvert.SerializeObject(collection.data, Formatting.Indented);
Console.WriteLine(x);
产生输出:
[
{
"data1": "10551296",
"data2": "TrainingIns",
"data3": "Completed"
},
{
"connectorType": "webserver-to-appserver",
"sourceUri": "data4",
"destinationUri": "data5"
}
]
示例小提琴.