The DataProvider value determines the syntax used for the ConnectString and CommandText properties.
The table below contains the set of data source extensions available by default. Custom extensions can be created but RDL consumers take caution when loading reports containing unknown or unsupported extensions.
Extension | Description |
---|---|
SQL | Microsoft SQL Server |
OLEDB | Microsoft OLE DB Provider |
ODBC | Microsoft Open Database Connectivity Driver |
var connectionProperties = new ConnectionProperties(); connectionProperties.DataProvider = "SQL";