Devart Forums

Code: Select all

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Devart.Data.PostgreSql;

namespace ConsoleApp1
{

    public class MyContext : DbContext
    {

        public DbSet<JsonTable> JsonTables { get; set; }

    }

    public class JsonTable
    {

        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }

        [Column(TypeName = "jsonb")]
        public string JObject { get; set; }

        public string Text { get; set; }

    }

    class Program
    {
        static void Main(string[] args)
        {
            var context = new MyContext();
            context.Database.Create();


            var query = context.JsonTables
              .Where(t => PgSqlJsonbFunctions.GetObjectFieldAsText(t.JObject, "a") == "foo")
              .Select(t => new {
                  Id = t.Id,
                  Json = t.JObject,
                  ObjectType = PgSqlJsonbFunctions.TypeOf(t.JObject),
                  FieldType = PgSqlJsonbFunctions.TypeOf(PgSqlJsonbFunctions.ExtractPath(t.JObject, "a")),
                  ExtractPath = PgSqlJsonbFunctions.ExtractPath(t.JObject, "a"),
                  ExtractPathText = PgSqlJsonbFunctions.ExtractPathText(t.JObject, "a"),
                  GetObjectField = PgSqlJsonbFunctions.GetObjectField(t.JObject, "a"),
                  GetObjectFieldAsText = PgSqlJsonbFunctions.GetObjectFieldAsText(t.JObject, "a")
              });
        }
    }
}