Class OpenJson
- Namespace
- PHCDataLayer
- Assembly
- PHCDataLayer.dll
The OPENJSON table-valued function parses the jsonExpression provided as the first argument and returns one or more rows containing data from the JSON objects in the expression. jsonExpression can contain nested sub-objects. If you want to parse a sub-object from within jsonExpression, you can specify a path parameter for the JSON sub-object.
public class OpenJson : ISelectedItens- Inheritance
-
OpenJson
Remarks
Constructors
OpenJson()
public OpenJson()OpenJson(string)
public OpenJson(string jsonExpression)Parameters
| Nome | Tipo | Descrição |
|---|---|---|
jsonExpression |
string |
OpenJson(string, string)
public OpenJson(string jsonExpression, string path)Parameters
| Nome | Tipo | Descrição |
|---|---|---|
jsonExpression |
string | |
path |
string |
Properties
AliasName
public string AliasName { get; set; }Property Value
EntityType
public Type EntityType { get; set; }Property Value
JsonExpression
Is a Unicode character expression containing JSON text. OPENJSON iterates over the elements of the array or the properties of the object in the JSON expression and returns one row for each element or property.
public string JsonExpression { get; set; }Property Value
Path
Is an optional JSON path expression that references an object or an array within jsonExpression. OPENJSON seeks into the JSON text at the specified position and parses only the referenced fragment
public string Path { get; set; }Property Value
Remarks
Methods
Parse()
public string Parse()Returns
Explicit Interface Implementations
SelectItems
Explicitly defines the output schema for the OPENJSON function to return
SelectItems SelectItems { get; set; }