注册自定义类型
// 解析值
public class JsonTypeHandler: SqlMapper.ITypeHandler
{
public void SetValue(IDbDataParameter parameter, object value)
{
parameter.Value = JsonConvert.SerializeObject(value);
}
public object Parse(Type destinationType, object value)
{
return JsonConvert.DeserializeObject(value as string, destinationType);
}
}
// 注册
SqlMapper.AddTypeHandler(typeof(自定义实体类型),new JsonTypeHandler());