DataConnector | ComponentOne
ADO.NET provider for CSV / Schema Discovery / Detection Scheme
In This Topic
    Detection Scheme
    In This Topic

    DetectionScheme is a connection string property. It allows users to specify their preferred data type detection scheme when the source is a local file.

    This property can be defined as a simple, case-insensitive string, for example:

    C#
    Copy Code
    string conString = @'detectionschemetype=RowScan'

    Or as an Enum with two possible values:

    1. Means that every column will be returned as the best suitable data type for the section of the table read, which by default is 500 rows.

    C#
    Copy Code
    builder.DetectionScheme = DetectionSchemeType.RowScan;

    2.  Means that every column data type will be returned as the default value that is string.

    C#
    Copy Code
    builder.DetectionScheme = DetectionSchemeType.None;