DataConnector | ComponentOne
ADO.NET provider for JSON / Schema Discovery / RowsToScan JSON
In This Topic
    RowsToScan JSON
    In This Topic

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