You can download the SlicingDice ADO.net's driver by clicking on this link.
To connect to ADO.net Driver you can follow the instruction on the official ADO.net Driver documentation.
The ADO.net driver has a lot of connection string options that you can use to customize your ADO.net experience, below you can find the most important ones.
- Logfile - The path to the log file, with the log file you can find the translations made by the driver and debug if any error occur;
- Verbosity - The log verbosity, you can set a value between 1 and 5 where 1 is the lower verbosity and 5 the higher.
You can find all the connection string options on the ADO.net Driver documentation.
Use EnforceTableSchema to auto-create columns
The ADO.net driver allows the user to auto-create missing columns using the INSERT statement, to do so you will need to add the following connection string when loading the driver:
The SlicingDice supports the SQL-92 insertions and queries so you can use the pure SQL to make queries and insertions using our driver. To learn more about the SQL compliance you can check the driver documentation.