/// <summary>
/// Initializes the provider.
/// </summary>
/// <param name="name">The friendly name of the provider.</param>
/// <param name="config">A collection of the name/value pairs representing the provider-specific attributes specified in the configuration for this provider.</param>
/// <exception cref="T:System.ArgumentNullException">The name of the provider is null.</exception>
/// <exception cref="T:System.ArgumentException">The name of the provider has a length of zero.</exception>
/// <exception cref="T:System.InvalidOperationException">An attempt is made to call <see cref="M:System.Configuration.Provider.ProviderBase.Initialize(System.String,System.Collections.Specialized.NameValueCollection)"/> on a provider after the provider has already been initialized.</exception>
public override void Initialize(string name, NameValueCollection config)
{
// Validate arguments
if (config == null)
{
throw new ArgumentNullException("config");
}
if (string.IsNullOrEmpty(name))
{
name = "SimpleSqlRoleProvider";
}
if (String.IsNullOrEmpty(config["description"]))
{
config.Remove("description");
config.Add("description", "MyExtensions role provider");
}
// Initialize base class
base.Initialize(name, config);
// Initialize current class
System.Configuration.ConnectionStringSettings ConnectionStringSettings = System.Configuration.ConfigurationManager.ConnectionStrings[config["connectionStringName"]];
if (ConnectionStringSettings == null || ConnectionStringSettings.ConnectionString.Trim() == "")
{
throw new ProviderException("Connection string cannot be blank.");
}
this.connectionString = ConnectionStringSettings.ConnectionString;
this.applicationName = config["applicationName"];
}
public void ConnectionStringsTest()
{
System.Configuration.ConnectionStringSettings settings =
System.Configuration.ConfigurationManager.ConnectionStrings["OMEGA_PROD"];
if (null != settings)
{
// Retrieve the partial connection string.
string connectString = settings.ConnectionString;
Console.WriteLine("Original: {0}", connectString);
// Create a new SqlConnectionStringBuilder based on the
// partial connection string retrieved from the config file.
System.Data.SqlClient.SqlConnectionStringBuilder builder =
new System.Data.SqlClient.SqlConnectionStringBuilder(connectString);
builder.ConnectTimeout = 60;
SqlConnection con = new SqlConnection(builder.ConnectionString);
SqlCommand cmd = new SqlCommand("select top 10 * from com.produit", con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
int i = 0;
while (rdr.Read())
{
Console.WriteLine("Line {0}: {1}", i, rdr[i]);
i++;
}
//DataSet ds = new DataSet();
//SqlDataAdapter da = new SqlDataAdapter(cmd);
//da.Fill(ds);
con.Close();
}
}
public List <OpsLogix.WAP.RunPowerShell.ApiClient.DataContracts.Runbook> GetTARunbookList()
{
System.Configuration.ConnectionStringSettings mySetting = System.Configuration.ConfigurationManager.ConnectionStrings["ResourceProviderDatabase"];
taRunbooks = new List <OpsLogix.WAP.RunPowerShell.ApiClient.DataContracts.Runbook>();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = mySetting.ConnectionString;
conn.Open();
SqlCommand command = new SqlCommand("SELECT Id,RunbookId,RunbookName,RunbookTag,PlanId,PlanName FROM Runbooks", conn);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
taRunbooks.Add(new OpsLogix.WAP.RunPowerShell.ApiClient.DataContracts.Runbook {
RunbookId = reader["RunbookId"].ToString(), RunbookName = reader["RunbookName"].ToString(), RunbookTag = reader["RunbookTag"].ToString(), PlanId = reader["PlanId"].ToString(), PlanName = reader["PlanName"].ToString()
});
}
}
}
return(taRunbooks);
}
public string getCnx()
{
System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/Valemobi");
System.Configuration.ConnectionStringSettings connString = rootWebConfig.ConnectionStrings.ConnectionStrings["CnxValemobi"];
return(connString.ConnectionString);
}
private DatabaseFlavour DetectFlavor(ConnectionStringSettings css)
{
string provider = css.ProviderName;
if (provider == "" || provider.StartsWith("System.Data.SqlClient"))
{
return(DatabaseFlavour.SqlServer);
}
if (provider.StartsWith("System.Data.SQLite"))
{
return(DatabaseFlavour.SqLite);
}
if (provider.StartsWith("MySql.Data.MySqlClient"))
{
return(DatabaseFlavour.MySql);
}
if (provider.StartsWith("System.Data.OracleClient"))
{
return(DatabaseFlavour.Oracle);
}
if (provider.StartsWith("System.Data.SqlServerCe"))
{
return(DatabaseFlavour.SqlCe);
}
throw new ConfigurationErrorsException("Could not auto-detect the database flavor. Please configure this explicitly in the n2/database section.");
}
private OracleConnection GetConnection()
{
System.Configuration.ConnectionStringSettings conString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConString"];
string strConnString = conString.ConnectionString;
return(new OracleConnection(strConnString));
}
/// <summary> 创建并返回 IDBHelper,获取应用程序下ConnectionStrings中的第一个节点的值
/// </summary>
/// <returns></returns>
public static IDBHelper Create()
{
if (_FirstConfig == null)
{
var ee = System.Configuration.ConfigurationManager.ConnectionStrings.GetEnumerator();
while (ee.MoveNext())
{
_FirstConfig = (System.Configuration.ConnectionStringSettings)ee.Current;
if (_FirstConfig.ElementInformation.IsPresent)
{
break;
}
_FirstConfig = null;
}
if (_FirstConfig == null)
{
throw new KeyNotFoundException("不存在任何节点");
}
}
var helper = CreateDBHelper(_FirstConfig.ProviderName);
helper.ConnectionString = _FirstConfig.ConnectionString;
helper.ProviderName = _FirstConfig.ProviderName;
helper.Name = _FirstConfig.Name;
return(helper);
}
/// <summary>
/// Sets up the required files locally to test the web data service
/// through the local web server, including a string with arguments.
/// </summary>
public static string SetupServiceFiles(string serviceFileName, Type dataServiceType, Type serviceType, string testArgumentsText, string configSnippet = null, string initializeServiceCode = null)
{
Dictionary<string, string> connections = new Dictionary<string, string>();
if (serviceType == null)
{
serviceType = typeof(OpenWebDataService<>).MakeGenericType(dataServiceType);
}
string northwindConnectionString = NorthwindModel.NorthwindContext.ContextConnectionString;
if (northwindConnectionString.StartsWith("name"))
{
System.Configuration.ConnectionStringSettings northwindSettings = System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindContext"];
if (northwindSettings != null)
{
northwindConnectionString = northwindSettings.ConnectionString;
}
else
{
AstoriaUnitTests.Data.ServiceModelData.Northwind.EnsureDependenciesAvailable();
Debug.Assert(!NorthwindModel.NorthwindContext.ContextConnectionString.StartsWith("name"));
northwindConnectionString = NorthwindModel.NorthwindContext.ContextConnectionString;
}
}
connections.Add("NorthwindContext", northwindConnectionString);
return SetupServiceFiles(serviceFileName, dataServiceType, serviceType, testArgumentsText, connections, configSnippet, initializeServiceCode);
}
private static List <Tuple <Guid, String> > GetOperatorsId()
{
var rslt = new List <Tuple <Guid, String> >();
try
{
System.Data.SqlClient.SqlConnection conn = null;
System.Configuration.ConnectionStringSettings settings =
System.Configuration.ConfigurationManager.ConnectionStrings["oktell_ccwsConnectionString"];
SqlConnection myOdbcConnection = new SqlConnection(settings.ConnectionString);
SqlCommand myOdbcCommand = new SqlCommand();
myOdbcCommand.Connection = myOdbcConnection;
myOdbcCommand.CommandType = CommandType.Text;
myOdbcCommand.CommandText = "SELECT t2.Id, t2.Name FROM [oktell_settings].[dbo].[A_TaskManager_Operators] t1 WITH(NOLOCK), oktell_cc_temp.dbo.A_Cube_CC_Cat_OperatorInfo t2 with(nolock) WHERE t1.OperatorId = t2.Id and TaskId in ('DCFB629F-6B42-4985-AC55-115EA9819F16')";
myOdbcCommand.Connection.Open();
SqlDataReader myOdbcReader = myOdbcCommand.ExecuteReader(CommandBehavior.CloseConnection);
while (myOdbcReader.Read())
{
rslt.Add(new Tuple <Guid, String>(myOdbcReader.GetGuid(0), myOdbcReader.GetString(1)));
}
myOdbcReader.Close();
myOdbcConnection.Close();
return(rslt);
}
catch (Exception ex)
{
log.Error(ex);
return(new List <Tuple <Guid, String> >());
}
}
public ConexionBD()
{
System.Configuration.Configuration webConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/HousingU");
System.Configuration.ConnectionStringSettings conString = webConfig.ConnectionStrings.ConnectionStrings["BDHousingU"];
con = new OdbcConnection(conString.ToString());
con.Open();
}
private static void UpdateSettings(IEnumerable <System.IO.FileInfo> filesToUpdate, ProfileConfiguration config)
{
foreach (var file in filesToUpdate)
{
var configFile = System.Configuration.ConfigurationManager.OpenMappedMachineConfiguration(new System.Configuration.ConfigurationFileMap(file.FullName));
configFile.AppSettings.Settings.Clear();
configFile.ConnectionStrings.ConnectionStrings.Clear();
foreach (var appSetting in config.AppSettings)
{
configFile.AppSettings.Settings.Add(appSetting.Name, appSetting.Value);
}
foreach (var connectionString in config.ConnectionStrings)
{
var connectionConfig = new System.Configuration.ConnectionStringSettings(connectionString.Name, connectionString.Value);
if (!string.IsNullOrWhiteSpace(connectionString.Provider))
{
connectionConfig.ProviderName = connectionString.Provider;
}
configFile.ConnectionStrings.ConnectionStrings.Add(connectionConfig);
}
configFile.Save();
}
}
private static void LoadConnections()
{
System.Configuration.ConnectionStringSettings systemConnection = System.Configuration.ConfigurationManager.ConnectionStrings["SystemMapsConnectionString"] ?? null;
System.Data.Common.DbConnectionStringBuilder csb;
if (MySqlAccess.IsMySqlConnectionString(systemConnection.ConnectionString))
{
csb = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(systemConnection.ConnectionString);
}
else
{
csb = new System.Data.SqlClient.SqlConnectionStringBuilder(systemConnection.ConnectionString);
}
if (!List.ContainsKey(csb["data source"].ToString()))
{
List.Add(csb["data source"].ToString(), systemConnection.ConnectionString);
}
//else
// List[cnnParameter.serverName]=new SqlServersManager(connectionString) ;
AddOnPremissDemoDb();
AddExternalInstances();
isLoaded = true;
}
public override void Initialize(string name, NameValueCollection config)
{
foreach (var cfgKey in config.AllKeys)
{
config[cfgKey] = ConfigManager.ResolveValueSetting(config[cfgKey]);
}
verifyKey <bool>("enablePasswordRetrieval", config, false);
verifyKey <bool>("enablePasswordReset", config, false);
verifyKey <bool>("requiresQuestionAndAnswer", config, false);
verifyKey <bool>("requriesUniqueEmail", config, false);
verifyKey <MembershipPasswordFormat>("passwordFormat", config, false);
verifyKey <int>("maxInvalidPasswordAttempts", config, false);
verifyKey <int>("passwordAttemptWindow", config, false);
verifyKey <int>("minRequiredPasswordLength", config, false);
verifyKey <int>("minRequiredNonalphanumericCharacters", config, false);
ConnectionStringName = verifyKey <string>("connectionStringName", config, true);
ApplicationName = verifyKey <string>("applicationName", config, true);
ConnectionStringName = config["connectionStringName"];
System.Configuration.ConnectionStringSettings connection = System.Configuration.ConfigurationManager.ConnectionStrings[ConnectionStringName];
if (connection == null)
{
ExceptionFactory.Throw <System.Configuration.ConfigurationErrorsException>("Unable to find connection key '{0}' in <connectionStrings> section{1}{2}",
ConnectionStringName, Environment.NewLine, getConfigMessage(config));
}
{
ConnectionString = connection.ConnectionString;
}
dbConnectionString = connection.ConnectionString;
base.Initialize(name, config);
}
public List <OpsLogix.WAP.RunPowerShell.ApiClient.DataContracts.Runbook> GetSMARunbookList()
{
smaRunbooks = new List <OpsLogix.WAP.RunPowerShell.ApiClient.DataContracts.Runbook>();
System.Configuration.ConnectionStringSettings url = System.Configuration.ConfigurationManager.ConnectionStrings["SMAUrl"];
var api = new OrchestratorApi(new Uri(url.ConnectionString));
//var api = new OrchestratorApi(new Uri(url.ConnectionString));
/*
* var api = new OrchestratorApi(new Uri("https://sma.lab.local/00000000-0000-0000-0000-000000000000"));*/
((DataServiceContext)api).Credentials = CredentialCache.DefaultCredentials;
ServicePointManager.ServerCertificateValidationCallback = new RemoteCertificateValidationCallback(delegate { return(true); });
//var runbooks = api.Runbooks.Where(r => r.Tags.Contains("TenantRunbook")).AsEnumerable();
var runbooks = api.Runbooks.AsEnumerable();
foreach (OpsLogix.WAP.RunPowerShell.Api.ServiceReference.SMAWebservice.Runbook runbook in runbooks)
{
smaRunbooks.Add(new OpsLogix.WAP.RunPowerShell.ApiClient.DataContracts.Runbook {
RunbookId = runbook.RunbookID.ToString(), RunbookName = runbook.RunbookName, RunbookTag = runbook.Tags
});
}
return(smaRunbooks);
}
public static void ExecuteDataImportHandler()
{
System.Configuration.ConnectionStringSettings mySetting = System.Configuration.ConfigurationManager.ConnectionStrings["Solr"];
if (mySetting == null || string.IsNullOrEmpty(mySetting.ConnectionString))
{
throw new System.Exception("Fatal error: missing connecting string in web.config file");
}
var connectionString = mySetting.ConnectionString;
string solrTargetDIHUrl = connectionString + "/dataimport?command=delta-import";
//System.Diagnostics.Debug.WriteLine(solrTargetDIHUrl);
try
{
using (var solrClient = new System.Net.Http.HttpClient())
{
var resultObj = solrClient.GetAsync(new System.Uri(solrTargetDIHUrl)).Result;
//System.Diagnostics.Debug.WriteLine("Data Import Triggered Successfully!");
}
}
catch (System.Exception e)
{
//System.Diagnostics.Debug..WriteLine("ERROR in Data Import Handler Trigger: " + e.Message);
}
}
//Constructor
public BaseMySqlDbConnection(string connectionStringOrConnectionName)
{
System.Configuration.ConnectionStringSettings xmlConfiguration
= System.Configuration.ConfigurationManager.ConnectionStrings[connectionStringOrConnectionName];
if (xmlConfiguration == null)
{
BuildJsonConfig();
string jsonConnString = _jsonConfiguration["ConnectionStrings:" + connectionStringOrConnectionName];
if (string.IsNullOrEmpty(jsonConnString))
{
ConnectionString = connectionStringOrConnectionName;
}
else
{
ConnectionString = jsonConnString;
}
}
else
{
ConnectionString = xmlConfiguration.ConnectionString;
}
}
private static void LoadDataStoreTable(string name)
{
if (string.IsNullOrWhiteSpace(name))
{
throw new System.ArgumentException($"{nameof( name )} is null, empty or whitespaces only.", nameof(name));
}
DataPhilosophiaeSection dps = System.Configuration.ConfigurationManager.GetSection(nameof(DataPhilosophiaeSection)) as DataPhilosophiaeSection;
System.Configuration.ConnectionStringSettingsCollection css = System.Configuration.ConfigurationManager.ConnectionStrings;
if (dps == null)
{
throw new System.Exception("[DataPhilosophiaeSection] section missing in app.config!!!");
}
if (css == null)
{
throw new System.Exception("[connectionStrings] section missing in app.config!!!");
}
System.Data.DataTable dscTbl = MyDataSet.Tables[name];
foreach (DataStoreElement dse in dps.DataStores)
{
System.Configuration.ConnectionStringSettings cs = css[dse.ConnectionStringName];
DataStore ds = new DataStore(dps, dse, cs);
dscTbl.Rows.Add(ds.GetAsDataRow(dscTbl.NewRow( )));
}
}
private DataSet GetDatosPuntos(string ci)
{
DataSet theDataSet = new DataSet();
System.Configuration.ConnectionStringSettings conexionPuntos =
System.Configuration.ConfigurationManager.ConnectionStrings["DataBMSC"];
string sqlQuery = " SELECT CDP_DOCUMENTOID, CDP_NOMBRE, " +
" CDP_GRUPO, CDP_SECUENCIA, CDP_CATEGORIA, CDP_ACCION, CDP_PUNTOS " +
" FROM puntos.BMET_CPDETALLEPUNTOS " +
//" WHERE CDP_DOCUMENTOID = @ci " +
" WHERE CDP_DOCUMENTOID = HASHBYTES('SHA1', CAST(@ci as nvarchar)) " +
" ORDER BY CDP_DOCUMENTOID ASC, CDP_CODIGOCLUB ASC, CDP_SECUENCIA ASC ";
SqlParameter pCi = new SqlParameter("@ci", SqlDbType.NVarChar);
//pCi.Value = this.GetSHA1(ci);
pCi.Value = ci;
SqlConnection con = new SqlConnection(conexionPuntos.ConnectionString);
SqlDataAdapter dap = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.Parameters.Add(pCi);
dap.SelectCommand = cmd;
con.Open();
dap.Fill(theDataSet);
con.Close();
return(theDataSet);
}
public static System.Data.DataTable LoadDataStoreConfigurationSetting(string name = DataStore.DATA_STORE_CONFIG_TBLNAME)
{
if (string.IsNullOrWhiteSpace(name))
{
throw new System.ArgumentException($"{nameof( name )} is null, empty or whitespaces only.", nameof(name));
}
DataPhilosophiaeSection dps = System.Configuration.ConfigurationManager.GetSection(nameof(DataPhilosophiaeSection)) as DataPhilosophiaeSection;
System.Configuration.ConnectionStringSettingsCollection css = System.Configuration.ConfigurationManager.ConnectionStrings;
if (dps == null)
{
throw new System.Exception("[DataPhilosophiaeSection] section missing in app.config!!!");
}
if (css == null)
{
throw new System.Exception("[connectionStrings] section missing in app.config!!!");
}
System.Data.DataTable tbl = DataStore.CreateDataStoreConfigTable(name);
{
foreach (DataStoreElement dse in dps.DataStores)
{
System.Configuration.ConnectionStringSettings cs = css[dse.ConnectionStringName];
DataStore ds = new DataStore(dps, dse, cs);
tbl.Rows.Add(ds.GetAsDataRow(tbl.NewRow( )));
f(ds);
}
}
return(tbl);
}
private void btnInfo_Click(object sender, EventArgs e)
{
List <string> lst = new List <string>();
Event eventFilter = new Event();
try
{
_loger.Information("Fwk Loggin test", "Mensaje de prueba para Fwk Loggin");
System.Configuration.ConnectionStringSettings cnn = System.Configuration.ConfigurationManager.ConnectionStrings[_LoggingSection.GetProvider().CnnStringName];
if (cnn == null)
{
throw new Exception("no existe la ConnectionString " + _LoggingSection.GetProvider().CnnStringName + " configurada en el config file para EventType.Information");
}
ITarget t = DatabaseTarget.TargetFactory(TargetType.Database, cnn.Name);
_loger.Information("test logging", "Informe de error");
//eventFilter.LogType = EventType.Information;
//t.SearchByParam(eventFilter);
//foreach (Event wEvent in t.SearchByParam(eventFilter))
//{
// lst.Add(wEvent.Id.ToString());
//}
//t.Remove(lst);
//eventFilter.LogType = EventType.None;
txtNoStaticResult.Text = t.SearchByParam(eventFilter).GetXml();
}
catch (Exception ex)
{
ExceptionView.Show(ex);
}
}
/*
* Method to get a database connection from the server or local embedded database.
* built on generic ADO.Net
*/
public static DbConnection GetUasAdoConnection()
{
DbConnection dbConn = null;
try
{
System.Configuration.ConnectionStringSettings connectionString = new System.Configuration.ConnectionStringSettings();
if (SessionHelper.IsVentureMode)
{
connectionString = DataContext.getUASEntitiesAdoVenture();
}
else
{
connectionString = System.Configuration.ConfigurationManager.ConnectionStrings[DataContext.GetUasConnectionStringName()];
}
// Loads the factory
System.Data.Common.DbProviderFactory factory = System.Data.Common.DbProviderFactories.GetFactory(connectionString.ProviderName);
dbConn = factory.CreateConnection();
dbConn.ConnectionString = connectionString.ConnectionString;
}
catch (Exception ex)
{
Debug.WriteLine("* * * GetUasAdoConnection: " + ex.Message);
// GetProviderFactoryClasses();
}
return(dbConn);
}
public ParentData()
{
DatabaseSettings objSection = (DatabaseSettings)System.Configuration.ConfigurationManager.GetSection("dataConfiguration");
objDatabaseProviderFactory = new DatabaseProviderFactory();
objDatabase = objDatabaseProviderFactory.CreateDefault();
objConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings[objSection.DefaultDatabase];
}
public DbConnectionInfo Read(string ConnectionStringName, string WebConfigFilePath = "")
{
string TargetWebConfigFilePath = string.Empty;
if (!string.IsNullOrWhiteSpace(WebConfigFilePath))
{
//Path provided are an argument to the console application
TargetWebConfigFilePath = WebConfigFilePath;
}
else if (System.Diagnostics.Debugger.IsAttached)
{
//When running in Visual Studio we use the Pyro.ConsoleServer db connection info
string ExecutingDirectoryPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location);
string ProjectDirectory = System.IO.Directory.GetParent(System.IO.Directory.GetParent(System.IO.Directory.GetParent(ExecutingDirectoryPath).FullName).FullName).FullName;
TargetWebConfigFilePath = $@"{ProjectDirectory}\Pyro.ConsoleServer\{AppConfigFileName}";
}
else
{
//When run out side of Visual Studio and no argument parameter is given, we asume the web.config file
//is in the parent directory. This is true when deployed in IIS
string ExecutingDirectoryPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location);
string RootFolder = System.IO.Directory.GetParent(ExecutingDirectoryPath).FullName;
TargetWebConfigFilePath = $@"{RootFolder}\{WebConfigFileName}";
}
if (!System.IO.File.Exists(TargetWebConfigFilePath))
{
//Last resort, check if the WebConfig file is in the same directory.
string ExecutingDirectoryPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location);
TargetWebConfigFilePath = $@"{ExecutingDirectoryPath}\{WebConfigFileName}";
if (!System.IO.File.Exists(TargetWebConfigFilePath))
{
throw new FieldAccessException($"Unable to locate the {WebConfigFileName} file at the path: {TargetWebConfigFilePath}");
}
}
var webFile = new System.Configuration.ExeConfigurationFileMap();
webFile.ExeConfigFilename = TargetWebConfigFilePath;
System.Configuration.Configuration myConn = System.Configuration.ConfigurationManager.OpenMappedExeConfiguration(webFile, System.Configuration.ConfigurationUserLevel.None);
System.Configuration.ConnectionStringSettings connSet = myConn.ConnectionStrings.ConnectionStrings[ConnectionStringName];
if (connSet == null)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Failed!");
Console.WriteLine("Unable to read the database connection string from the Web.Config file.");
return(null);
}
else
{
var ConnectionString = connSet.ConnectionString;
var ProviderName = connSet.ProviderName;
var DbConnectionInfo = new DbConnectionInfo();
DbConnectionInfo.ProviderName = connSet.ProviderName;
DbConnectionInfo.ConnectionString = connSet.ConnectionString;
return(DbConnectionInfo);
}
}
private static string GetConnectionString(string connectionStringName)
{
System.Configuration.ConnectionStringSettings connectionStringSettings = System.Configuration.ConfigurationManager.ConnectionStrings[connectionStringName];
if (connectionStringSettings == null)
{
throw new InvalidOperationException("Connection string \"" + connectionStringName + "\" could not be found in the configuration file.");
}
return(connectionStringSettings.ConnectionString);
}
public MSSQLContext()
{
System.Configuration.ConnectionStringSettings connectionSettings =
System.Web.Configuration.WebConfigurationManager.ConnectionStrings["MSSQLConnection"];
_SQLConnection = new SqlConnection();
_SQLConnection.ConnectionString = connectionSettings.ConnectionString;
_SQLConnection.Open();
}
/// <summary>
/// 获取ConnectionStrings连接字符串
/// </summary>
public static string GetConnectionStrings(string Name)
{
System.Configuration.ConnectionStringSettings ConnStrSettings = System.Configuration.ConfigurationManager.ConnectionStrings[Name];
if (ConnStrSettings != null)
{
return(ConnStrSettings.ConnectionString);
}
return(null);
}
public DatabaseConnectorClass(System.Configuration.ConnectionStringSettings connectionStringSettings, string version)
: this((connectionStringSettings != null ? connectionStringSettings.ConnectionString : null),
(connectionStringSettings.ProviderName.ToLower().Contains("sqlclient") ? ProviderFactory.MSSQL :
connectionStringSettings.ProviderName.ToLower().Contains("oracle") ? ProviderFactory.Oracle :
connectionStringSettings.ProviderName.ToLower().Contains("mysql") ? ProviderFactory.MySQL :
connectionStringSettings.ProviderName.ToLower().Contains("npgsql") ? ProviderFactory.PostgreSQL :
ProviderFactory.MSSQL))
{
}
public DaoBase(string currentUser, System.Configuration.ConnectionStringSettings connectionStringSettings)
{
_currentUser = currentUser;
_commonDatabase = new Framework.DataServices.CommonDatabase(
connectionStringSettings.Name,
connectionStringSettings.ConnectionString,
connectionStringSettings.ProviderName);
}
static SolrHTTPMethods()
{
System.Configuration.ConnectionStringSettings mySetting = System.Configuration.ConfigurationManager.ConnectionStrings["Solr"];
if (mySetting == null || string.IsNullOrEmpty(mySetting.ConnectionString))
{
throw new System.Exception("Fatal error: missing connecting string in web.config file");
}
connectionString = mySetting.ConnectionString;
}
public TariffService(System.Configuration.ConnectionStringSettings connectionString, IQuotaService quotaService, ITenantService tenantService)
: base(connectionString, "tenant")
{
this.quotaService = quotaService;
this.tenantService = tenantService;
config = new CoreConfiguration(tenantService);
CacheExpiration = DEFAULT_CACHE_EXPIRATION;
test = ConfigurationManager.AppSettings["core:payment:test"] == "true";
int.TryParse(ConfigurationManager.AppSettings["core:payment:delay"], out paymentDelay);
}
public Repository()
{
System.Configuration.Configuration rootWebConfig =
System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/MyWebSiteRoot");
if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
{
connectionString =
rootWebConfig.ConnectionStrings.ConnectionStrings["AuzreDb"];
}
}
public static string GetConnectionString()
{
if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
{
connString = rootWebConfig.ConnectionStrings.ConnectionStrings["AppNFCCnn"];
if (connString != null)
Console.WriteLine("AppNFCCnn connection string = \"{0}\"",
connString.ConnectionString);
else
Console.WriteLine("No AppNFCCnn connection string");
}
return connString.ConnectionString;
}
public SQLTranslator()
{
connString = rootWebConfig.ConnectionStrings.ConnectionStrings["AssetInventoryConnectionString"];
connectionString = connString.ConnectionString;
}
System.Configuration.ConnectionStringsSection CreateConnectionStringsSection() {
var internalConnectionStringsSection = (System.Configuration.ConnectionStringsSection)internalConfigSystem.GetSection(ConnectionStringsSectionName);
var connectionStringsSection = new System.Configuration.ConnectionStringsSection();
foreach(var connectionStringSettings in internalConnectionStringsSection.ConnectionStrings.Cast<System.Configuration.ConnectionStringSettings>()) {
var patchedConnectionStringSettings = new System.Configuration.ConnectionStringSettings(
connectionStringSettings.Name,
DbEngineDetector.PatchConnectionString(connectionStringSettings.ConnectionString, connectionStringSettings.ProviderName == EntityFrameworkConnectionStringProviderName),
connectionStringSettings.ProviderName
);
connectionStringsSection.ConnectionStrings.Add(patchedConnectionStringSettings);
}
return connectionStringsSection;
}
public void TestFixtureSetup()
{
System.Configuration.ConnectionStringSettings cs = new System.Configuration.ConnectionStringSettings(Properties.Settings.Default.DBName, Properties.Settings.Default.DBConnection, Properties.Settings.Default.DBProvider);
Com.SunnySystems.Util.DB.PooledDBLayer.EnableTrace = true;
Control.RFGActivator.StartApplication(cs, Properties.Settings.Default.Smtp, 1, Properties.Settings.Default.TempDir);
}
private static void UpdateSettings(IEnumerable<System.IO.FileInfo> filesToUpdate, ProfileConfiguration config)
{
foreach (var file in filesToUpdate)
{
var configFile = System.Configuration.ConfigurationManager.OpenMappedMachineConfiguration(new System.Configuration.ConfigurationFileMap(file.FullName));
configFile.AppSettings.Settings.Clear();
configFile.ConnectionStrings.ConnectionStrings.Clear();
foreach (var appSetting in config.AppSettings)
configFile.AppSettings.Settings.Add(appSetting.Name, appSetting.Value);
foreach (var connectionString in config.ConnectionStrings)
{
var connectionConfig = new System.Configuration.ConnectionStringSettings(connectionString.Name, connectionString.Value);
if (!string.IsNullOrWhiteSpace(connectionString.Provider))
connectionConfig.ProviderName = connectionString.Provider;
configFile.ConnectionStrings.ConnectionStrings.Add(connectionConfig);
}
configFile.Save();
}
}
private DatabaseFlavour DetectFlavor(ConnectionStringSettings css)
{
string provider = css.ProviderName;
if (provider == "" || provider.StartsWith("System.Data.SqlClient"))
return DatabaseFlavour.SqlServer;
if (provider.StartsWith("System.Data.SQLite"))
return DatabaseFlavour.SqLite;
if (provider.StartsWith("MySql.Data.MySqlClient"))
return DatabaseFlavour.MySql;
if (provider.StartsWith("System.Data.OracleClient"))
return DatabaseFlavour.Oracle;
if (provider.StartsWith("System.Data.SqlServerCe"))
return DatabaseFlavour.SqlCe;
throw new ConfigurationErrorsException("Could not auto-detect the database flavor. Please configure this explicitly in the n2/database section.");
}
