Web Api忽略用于DbGeography的自定义JsonConverter
问题描述:
与此有关的主要挣扎。所以我试图将嵌套的Json数据发送到我的web api。我有一个自定义的儿子转换器,用于我的DbGeography类型。但是,当我发送我的请求时,似乎我的自定义转换器从未被调用过。我得到错误说:无法将对象类型对象转换为DbGeography。我为我的数据模型首先使用数据库。 注释掉locationAccountCreated属性,其他一切正常,数据成功保存到数据库。Web Api忽略用于DbGeography的自定义JsonConverter
请任何帮助将非常感激。下面
控制器
[Route("Create")]
[HttpPost]
public HttpResponseMessage PostNewAccount([FromBody]IDictionary<string, object> formData)
{
if (formData != null)
{
var nValueCol = formData;
var account = new Account()
{
Email = (string)nValueCol["email"],
Password = (string)nValueCol["password"],
AgreedToTerms = Convert.ToBoolean(nValueCol["agreesToTerms"]),
LocationAccountCreated = (DbGeography)nValueCol["userLocation"]//source of error
//LocationAccountCreated = (DbGeography)(IDictionary<string, IDictionary<string, double>>)nValueCol["userLocation"]
};
//...rest of code unrelated to problem
}
定制Conveter
public class DbGeographyConverter : JsonConverter
{
private const string LATITUDE_KEY = "latitude";
private const string LONGITUDE_KEY = "longitude";
public override bool CanConvert(Type objectType)
{
return objectType.Equals(typeof(DbGeography));
}
public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer)
{
if(reader.TokenType == JsonToken.Null) // checks if token is null.
{
return default(DbGeography);
}
var jObject = JObject.Load(reader);
if (!jObject.HasValues || (jObject.Property(LATITUDE_KEY)) == null || (jObject.Property(LONGITUDE_KEY)) == null) //checks if Json Object is null, and if longitude or latitude properties are null
{
return default(DbGeography);
}
string wellKnownText = string.Format("POINT({0} {1})", jObject[LATITUDE_KEY], jObject[LONGITUDE_KEY]);
return DbGeography.FromText(wellKnownText, DbGeography.DefaultCoordinateSystemId);
}
public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)
{
var dbGeography = value as DbGeography;
serializer.Serialize(writer, dbGeography == null || dbGeography.IsEmpty ? null : new { latitude = dbGeography.Latitude.Value, longitude = dbGeography.Longitude.Value });
}
}
public class QueryLocationMetadata
{
[JsonConverter(typeof(DbGeographyConverter))]
public virtual System.Data.Entity.Spatial.DbGeography LocationAccountCreated { get; set; }
}
分部类
请参见相关代码
[MetadataType(typeof(QueryLocationMetadata))]
public partial class Account
{
}
的Global.asax
protected void Application_Start()
{
var config = GlobalConfiguration.Configuration;
//Registering routes from the WebApi.Config file
GlobalConfiguration.Configure(Config.WebApiConfig.Register);
//Registering Autofac
GlobalConfiguration.Configure(Config.AutofacConfig.Initialize);
//Registering Formatter
config.Formatters.JsonFormatter.SerializerSettings.Converters.Add(new DbGeographyConverter());
}
提琴手请求
http://localhost:9576/Account/Create
User-Agent: Fiddler
Content-type: application/json
Host: localhost:9576
Content-Length: 316
{
"email":"[email protected]",
"firstName":"myFName",
"lastName":"myFName",
"dateOfBirth":"1992-02-18",
"password":"password",
"agreesToTerms":true,
"userName" : "Cool User",
"gender" : "Female",
"userLocation": {"geopoint":{"latitude" : 40.334910, "longitude" : -32.254586}}
}
答
尝试插入它作为第一个提供者:
config.Formatters.JsonFormatter.SerializerSettings.Converters.Insert(0, new DbGeographyConverter());
我与你的转换器这样的代码尝试这样的网络API 2控制器:
public void Post([FromBody]System.Data.Entity.Spatial.DbGeography value)
处理数字格式问题所以。该WKT部分可能需要看起来像这样:
string wellKnownText = string.Format("POINT({0} {1})", jObject[LATITUDE_KEY].Value<double>().ToString(System.Globalization.NumberFormatInfo.InvariantInfo), jObject[LONGITUDE_KEY].Value<double>().ToString(System.Globalization.NumberFormatInfo.InvariantInfo));
Kagelos嗨,我想你的建议,仍然没有工作,没有确切知道在哪里,我就这一个走错了。当你按照上面的方法试用时,转换器是否工作? – user6201138