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"; |