使用来自Postgres jsonb列的顶级字典映射到POCOs

public class MyPOCO
{
    public string Name { get; set; }
    public int Age { get; set; }
    // 其他属性...
}

using Npgsql;
using Newtonsoft.Json.Linq;

public Dictionary<string, object> GetJsonDataFromPostgres()
{
    string connectionString = "Your_Postgres_Connection_String";
    string query = "SELECT jsonb_column FROM your_table WHERE id = 'your_id'";

    using (NpgsqlConnection connection = new NpgsqlConnection(connectionString))
    {
        connection.Open();

        using (NpgsqlCommand command = new NpgsqlCommand(query, connection))
        {
            NpgsqlDataReader reader = command.ExecuteReader();

            if (reader.Read())
            {
                JObject jsonObject = JObject.Parse(reader.GetString(0));
                return jsonObject.ToObject<Dictionary<string, object>>();
            }
        }
    }

    return null;
}

Dictionary<string, object> jsonData = GetJsonDataFromPostgres();

MyPOCO myPOCO = new MyPOCO();
myPOCO.Name = (string)jsonData["name"];
myPOCO.Age = (int)jsonData["age"];
// 其他属性...