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:

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.

builder.DetectionScheme = DetectionSchemeType.RowScan;

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

builder.DetectionScheme = DetectionSchemeType.None;