c# - Azure Function 返回多个 JSON 对象

Question

这是我的 azure 函数应用程序。

#r "System.Configuration"
#r "System.Data"
using System.Net;
using System.Configuration;
using System.Data.SqlClient;
using System.Threading.Tasks;

public static async Task<HttpResponseMessage> Run(HttpRequestMessage req, 
TraceWriter log)
{       
    int num;    
    string query = req.GetQueryNameValuePairs()
        .FirstOrDefault(q => string.Compare(q.Key, "num", true) == 0)
        .Value;    

    if (query == null)
    {
        // Get request body
        dynamic data = await req.Content.ReadAsAsync<object>();
        num = data.num;
    }
    else {
        num = Convert.ToInt32(query);
    }      

    int[] numRead = new int[3];
    string[] nameRead = new string[3];    

    var str = 
ConfigurationManager.ConnectionStrings["sqldb_connection"].ConnectionString;

    using (SqlConnection conn = new SqlConnection(str))
    {
        conn.Open();
        var text = "select num,name from bus where num=@num;";

        using (SqlCommand cmd = new SqlCommand(text, conn))
        {
            cmd.Parameters.AddWithValue("@num", num);
            using (SqlDataReader reader = cmd.ExecuteReader()) 
            {
                int i = 0;
                while (reader.Read())
                {
                    numRead[i] = reader.GetInt32(0);                    
                    nameRead[i++] = reader.GetString(1);
                    Console.WriteLine(numRead[i] + ":" + nameRead[i]);                    
                }
            }
        }        
    }
    return req.CreateResponse(HttpStatusCode.OK, new {            
        name = nameRead[0],
        num = numRead[0]           
    });    
}

我希望函数像这样返回多个 json

return req.CreateResponse(HttpStatusCode.OK, new {
        "item1" : {
            name = nameRead[0],
            num = numRead[0]
        },
        "item2" : {
            name = nameRead[1],
            num = numRead[1]
        },
        "item3" : {
            name = nameRead[2],
            num = numRead[2]
        }
    });

但它不起作用。

C# 有 JsonArray、JsonObject 或 JsonValue 类，但我不明白如何使用它们，也不知道它们之间的区别他们之间。

Answer 1

如果你让它有效的 C# 它应该可以工作:

return req.CreateResponse(HttpStatusCode.OK, new {
    item1 = new {
        name = nameRead[0],
        num = numRead[0]
    },
    item2 = new {
        name = nameRead[1],
        num = numRead[1]
    },
    item3 = new {
        name = nameRead[2],
        num = numRead[2]
    }
});