using System.Data.SqlClient; using System.Data.Common; namespace DbConnectionStringBuilderDemo { class Program { static void Main(string[] args) { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = "localhost"; builder.InitialCatalog = "MyDatabase"; builder.IntegratedSecurity = true; Console.WriteLine(builder.ToString()); } } }
using System.Data.OleDb; using System.Data.Common; namespace DbConnectionStringBuilderDemo { class Program { static void Main(string[] args) { OleDbConnectionStringBuilder builder = new OleDbConnectionStringBuilder(); builder.Provider = "Microsoft.ACE.OLEDB.12.0"; builder.DataSource = @"C:\MyFolder\MyDatabase.accdb"; Console.WriteLine(builder.ToString()); } } }This example shows how to use the OleDbConnectionStringBuilder to build a connection string for an Access database and then output it using the ToString() method. In both these examples, we are not using any external package libraries as DbConnectionStringBuilder class is available in the System.Data.Common namespace.