Interface SqlFunctions.IJsonTreeRow
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
Id
The internal id of the element.
[Column("id")]
long Id { get; set; }
Property Value
Key
The array index or object label of the element, or null.
[Column("key")]
string? Key { get; set; }
Property Value
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
Type
The JSON type of the element (object, array, string, ...).
[Column("type")]
string? Type { get; set; }
Property Value
Value
The SQL value of the element.
[Column("value")]
string? Value { get; set; }