ADO.NET provider for JSON / Schema Discovery / RowsToScan JSON
RowsToScan JSON

For general documentation of RowsToScan refer to RowsToScan

When used with JSON data, the behavior of 'RowsToScan' varies based on the data model chosen by the user:

 

1. Document: In this mode, each JSON object is treated as one row of the database.

C#
Copy Code
C1JsonConnectionStringBuilder builder = new C1JsonConnectionStringBuilder();
builder.DetectionScheme = DetectionSchemeType.RowScan;
builder.RowsToScan = 200;
builder.DataModel = "Document";

2. Flattened Document: In this mode, 'RowsToScan' will scan as many rows as specified by the user, corresponding to the final flattened document table.

C#
Copy Code
C1JsonConnectionStringBuilder builder = new C1JsonConnectionStringBuilder();
builder.DetectionScheme = DetectionSchemeType.RowScan;
builder.RowsToScan = 200;
builder.DataModel = "Document";

 

3. Relational: In this mode, 'RowsToScan' will scan as many rows as specified by the user, corresponding to multiple tables. 'RowsToScan' keeps count of how many rows have been scanned in each table independently.

 

C#
Copy Code
C1JsonConnectionStringBuilder builder = new C1JsonConnectionStringBuilder();
builder.DetectionScheme = DetectionSchemeType.RowScan;
builder.RowsToScan = 200;
builder.DataModel = "Relational";