json - 将 JSON 导入到 SQL

Question

我正在通过 Azure Functions 将 Webhook 导入到 SQL 数据库。

当我使用导入时

{
        "remote_address": "1234",
}

这有效。

但是当我使用导入时

{
        "transaction": {
            "remote_address": "1234",
    }
}

这不起作用。

我的Azure函数代码是:

using System.Net;
using Dapper;
using System.Data.SqlClient;
using System.Configuration;

public static async Task<HttpResponseMessage> Run(HttpRequestMessage req, TraceWriter log)
{
log.Info($"C# HTTP trigger function processed a request. RequestUri={req.RequestUri}");

var successful =true;
try
{
    var cnnString  = ConfigurationManager.ConnectionStrings["sqlConnection"].ConnectionString;

    using(var connection = new SqlConnection(cnnString))
    {
        connection.Open();

        var rLog = await req.Content.ReadAsAsync<LogRequest>();

        // insert a log to the database
        connection.Execute("INSERT INTO [dbo].[TABLE] ([COLUMN]) VALUES (@remote_address)", rLog);
        log.Info("Log added to database successfully!");
    }
}
catch
{
    successful=false;
}

return !successful
    ? req.CreateResponse(HttpStatusCode.BadRequest, "Unable to process your request!")
    : req.CreateResponse(HttpStatusCode.OK, "Data saved successfully!");
}

public class LogRequest
{
    public int Id{get;set;}
    public string remote_address{get;set;}
}

如何获取嵌套 JSON 对象？

Answer 1

基本上，您可以嵌套 C# 类，以便它们对应于 JSON 结构:

public class Transaction
{
    public string remote_address { get; set; }
}

public class LogRequest
{
    public Transaction transaction { get; set; }
}