Here are sample connection strings for different ADO.NET Providers and database systems.


Connection strings are set when initializing an AdoConnector object.

SQL Server

Server=(local);Initial Catalog=AdventureWorks2017;Integrated Security=SSPI;Max Pool Size=250;Connect Timeout=30;

SQL Server Express

Server=.\SQLEXPRESS;Initial Catalog=AdventureWorks2017;Connection Timeout=30;Integrated Security=True;MultipleActiveResultSets=True

Azure SQL

Server=tcp:venturatemplate.database.windows.net,1433;Initial Catalog=AdventureWorks2017;Persist Security Info=False;User ID=USERNAME;Password=PASSWORD;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

SQLite

Data Source=C:\DATA\VanArsdel.db;FailIfMissing=True;

CData Exchange

auth scheme=BASIC;password=PASSWORD;platform=Exchange_Online;
server=https://outlook.office365.com/EWS/Exchange.asmx;user=USER@EMAIL.COM