private static string GetConnectionStringHeader(string provider, ConnectionStringHeaderType headerType, string value) { if (provider == "SQLOLEDB" || String.IsNullOrEmpty(provider)) { switch (headerType) { case ConnectionStringHeaderType.Provider: return "Provider=SQLOLEDB;"; case ConnectionStringHeaderType.Server: return String.Format(CultureInfo.InvariantCulture, "Data Source={0};", value); case ConnectionStringHeaderType.Database: return String.Format(CultureInfo.InvariantCulture, "Initial Catalog={0};", value); case ConnectionStringHeaderType.Username: return String.Format(CultureInfo.InvariantCulture, "User Id={0};", value); case ConnectionStringHeaderType.Password: return String.Format(CultureInfo.InvariantCulture, "Password={0};", value); case ConnectionStringHeaderType.Trusted: return "Integrated Security=SSPI;"; case ConnectionStringHeaderType.MarsConnection: return String.Format(CultureInfo.InvariantCulture,"MARS Connection={0};", value); } } else if (provider == "SQLNCLI10" || provider == "SQLNCLI10.1" || provider == "SQLNCLI") { switch (headerType) { case ConnectionStringHeaderType.Provider: return String.Format(CultureInfo.InvariantCulture, "Provider={0};", provider); case ConnectionStringHeaderType.Server: return String.Format(CultureInfo.InvariantCulture, "Data Source={0};", value); case ConnectionStringHeaderType.Database: return String.Format(CultureInfo.InvariantCulture, "Initial Catalog={0};", value); case ConnectionStringHeaderType.Username: return String.Format(CultureInfo.InvariantCulture, "User ID={0};", value); case ConnectionStringHeaderType.Password: return String.Format(CultureInfo.InvariantCulture, "Password={0};", value); case ConnectionStringHeaderType.Trusted: return "Trusted_Connection=yes;Integrated Security=SSPI;"; case ConnectionStringHeaderType.MarsConnection: return String.Format(CultureInfo.InvariantCulture,"MARS Connection={0};", value); } } else if (provider == "{SQL Server Native Client 10.0}" || provider == "{SQL Native Client}") { switch (headerType) { case ConnectionStringHeaderType.Provider: return String.Format(CultureInfo.InvariantCulture, "Driver={0};", provider); case ConnectionStringHeaderType.Server: return String.Format(CultureInfo.InvariantCulture, "Server={0};", value); case ConnectionStringHeaderType.Database: return String.Format(CultureInfo.InvariantCulture, "Database={0};", value); case ConnectionStringHeaderType.Username: return String.Format(CultureInfo.InvariantCulture, "UId={0};", value); case ConnectionStringHeaderType.Password: return String.Format(CultureInfo.InvariantCulture, "Pwd={0};", value); case ConnectionStringHeaderType.Trusted: return "Trusted_Connection=yes;"; case ConnectionStringHeaderType.MarsConnection: return String.Format(CultureInfo.InvariantCulture,"MARS Connection={0};", value); } } else if (provider == "SQLXMLOLEDB") { } else if (provider == "Microsoft.ACE.OLEDB.12.0" || provider == "Microsoft.Jet.OLEDB.4.0") { switch (headerType) { case ConnectionStringHeaderType.Provider: return String.Format(CultureInfo.InvariantCulture, "Provider={0};", provider); case ConnectionStringHeaderType.Server: return String.Format(CultureInfo.InvariantCulture, "Data Source={0};", value); case ConnectionStringHeaderType.PersistSecurityInfo: return String.Format(CultureInfo.InvariantCulture, "Persist Security Info={0};", value); case ConnectionStringHeaderType.AdditionalParameters: return String.Format(CultureInfo.InvariantCulture, "Extended Properties=\"{0}\";", value); } } return null; }
private static string GetConnectionStringHeader(string provider, ConnectionStringHeaderType headerType, string value) { if (provider == "SQLOLEDB" || String.IsNullOrEmpty(provider)) { switch (headerType) { case ConnectionStringHeaderType.Provider: return("Provider=SQLOLEDB;"); case ConnectionStringHeaderType.Server: return(String.Format(CultureInfo.InvariantCulture, "Data Source={0};", value)); case ConnectionStringHeaderType.Database: return(String.Format(CultureInfo.InvariantCulture, "Initial Catalog={0};", value)); case ConnectionStringHeaderType.Username: return(String.Format(CultureInfo.InvariantCulture, "User Id={0};", value)); case ConnectionStringHeaderType.Password: return(String.Format(CultureInfo.InvariantCulture, "Password={0};", value)); case ConnectionStringHeaderType.Trusted: return("Integrated Security=SSPI;"); case ConnectionStringHeaderType.MarsConnection: return(String.Format(CultureInfo.InvariantCulture, "MARS Connection={0};", value)); } } else if (provider == "SQLNCLI10" || provider == "SQLNCLI10.1" || provider == "SQLNCLI") { switch (headerType) { case ConnectionStringHeaderType.Provider: return(String.Format(CultureInfo.InvariantCulture, "Provider={0};", provider)); case ConnectionStringHeaderType.Server: return(String.Format(CultureInfo.InvariantCulture, "Data Source={0};", value)); case ConnectionStringHeaderType.Database: return(String.Format(CultureInfo.InvariantCulture, "Initial Catalog={0};", value)); case ConnectionStringHeaderType.Username: return(String.Format(CultureInfo.InvariantCulture, "User ID={0};", value)); case ConnectionStringHeaderType.Password: return(String.Format(CultureInfo.InvariantCulture, "Password={0};", value)); case ConnectionStringHeaderType.Trusted: return("Trusted_Connection=yes;Integrated Security=SSPI;"); case ConnectionStringHeaderType.MarsConnection: return(String.Format(CultureInfo.InvariantCulture, "MARS Connection={0};", value)); } } else if (provider == "{SQL Server Native Client 10.0}" || provider == "{SQL Native Client}") { switch (headerType) { case ConnectionStringHeaderType.Provider: return(String.Format(CultureInfo.InvariantCulture, "Driver={0};", provider)); case ConnectionStringHeaderType.Server: return(String.Format(CultureInfo.InvariantCulture, "Server={0};", value)); case ConnectionStringHeaderType.Database: return(String.Format(CultureInfo.InvariantCulture, "Database={0};", value)); case ConnectionStringHeaderType.Username: return(String.Format(CultureInfo.InvariantCulture, "UId={0};", value)); case ConnectionStringHeaderType.Password: return(String.Format(CultureInfo.InvariantCulture, "Pwd={0};", value)); case ConnectionStringHeaderType.Trusted: return("Trusted_Connection=yes;"); case ConnectionStringHeaderType.MarsConnection: return(String.Format(CultureInfo.InvariantCulture, "MARS Connection={0};", value)); } } else if (provider == "SQLXMLOLEDB") { } else if (provider == "Microsoft.ACE.OLEDB.12.0" || provider == "Microsoft.Jet.OLEDB.4.0") { switch (headerType) { case ConnectionStringHeaderType.Provider: return(String.Format(CultureInfo.InvariantCulture, "Provider={0};", provider)); case ConnectionStringHeaderType.Server: return(String.Format(CultureInfo.InvariantCulture, "Data Source={0};", value)); case ConnectionStringHeaderType.PersistSecurityInfo: return(String.Format(CultureInfo.InvariantCulture, "Persist Security Info={0};", value)); case ConnectionStringHeaderType.AdditionalParameters: return(String.Format(CultureInfo.InvariantCulture, "Extended Properties=\"{0}\";", value)); } } return(null); }