public static bool SetDatabaseParameters_MSSQL() { try { /*For future use * string exePath = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "PicSQL.config"); * ExeConfigurationFileMap configMap = new ExeConfigurationFileMap(); * configMap.ExeConfigFilename = exePath; * Configuration cfg = ConfigurationManager.OpenMappedExeConfiguration(configMap, ConfigurationUserLevel.None); * AppSettingsSection cs =(AppSettingsSection) cfg.GetSection("appSettings"); */ System.Data.SqlClient.SqlConnectionStringBuilder sqlCnnStrBld = new System.Data.SqlClient.SqlConnectionStringBuilder(); sqlCnnStrBld.DataSource = ConfigurationManager.AppSettings["dbDataSource_MSSQL"].ToString(); sqlCnnStrBld.InitialCatalog = ConfigurationManager.AppSettings["dbInitialCatalog_MSSQL"].ToString(); sqlCnnStrBld.PersistSecurityInfo = true; sqlCnnStrBld.UserID = ConfigurationManager.AppSettings["dbUserID_MSSQL"].ToString(); sqlCnnStrBld.Password = ConfigurationManager.AppSettings["dbPassword_MSSQL"].ToString(); strSQLconn_MSSQL = sqlCnnStrBld.ConnectionString; sqlCnnStrBld.Clear(); strTableName = ConfigurationManager.AppSettings["dbImageTable_MSSQL"].ToString(); return(true); } catch { return(false); } }
private string GetConnectionString() { var builder = new SqlConnectionStringBuilder(); builder.Clear(); builder.DataSource = Model.ServerName; if (Model.AuthenticationType == AuthenticationType.WindowsAuthentication) { builder.IntegratedSecurity = true; } else { builder.IntegratedSecurity = false; builder.UserID = Model.SqlServerUsername; builder.Password = Model.Password; } builder.InitialCatalog = Model.DatabaseName; return builder.ConnectionString; }