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;
}
