using System.Data.Common;
public static void Main()
OdbcConnectionStringBuilder odbcConnectionString = new OdbcConnectionStringBuilder();
odbcConnectionString.Add("Driver", "{Microsoft Text Driver (*.txt; *.csv)}");
odbcConnectionString.Add("Dbq", @"C:\Temp\");
odbcConnectionString.Add("Extensions", "asc,csv,tab,txt");
odbcConnectionString.Add("Persist Security Info", "False");
Console.WriteLine(odbcConnectionString.ConnectionString + " <-- Odbc Connection String");
DbConnectionStringBuilder dbConnectionString = new DbConnectionStringBuilder();
dbConnectionString.Add("Driver", "{Microsoft Text Driver (*.txt; *.csv)}");
dbConnectionString.Add("Dbq", @"C:\Temp\");
dbConnectionString.Add("Extensions", "asc,csv,tab,txt");
dbConnectionString.Add("Persist Security Info", "False");
Console.WriteLine(dbConnectionString.ConnectionString + " <-- DBConnection String - No Work Around");
Console.WriteLine(dbConnectionString.ConnectionString.Replace("\"", string.Empty) + " <-- DBConnection String - With Work Around");