Table of Contents

Interface SqlFunctions.IJsonTreeRow

Namespace
NextORM.Core
Assembly
nextorm.core.dll

Row shape produced by json_tree(string?): one row per JSON element, recursively. In addition to the SqlFunctions.IJsonEachRow columns it exposes the element id and the parent id.

public interface SqlFunctions.IJsonTreeRow
Extension Methods

Properties

FullKey

The full path that identifies the element.

[Column("fullkey")]
string? FullKey { get; set; }

Property Value

string

Id

The internal id of the element.

[Column("id")]
long Id { get; set; }

Property Value

long

Key

The array index or object label of the element, or null.

[Column("key")]
string? Key { get; set; }

Property Value

string

Parent

The internal id of the parent element, or null for the top-level element.

[Column("parent")]
long? Parent { get; set; }

Property Value

long?

Path

The path to the container of the element.

[Column("path")]
string? Path { get; set; }

Property Value

string

Type

The JSON type of the element (object, array, string, ...).

[Column("type")]
string? Type { get; set; }

Property Value

string

Value

The SQL value of the element.

[Column("value")]
string? Value { get; set; }

Property Value

string