/// <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."); }