private void formMainWindow_Load(object sender, EventArgs e) { Configuration configuration = ConfiguratuionHelper.GetConfiguration(string.Empty); ConfigurationSection oracleSection = configuration.GetSection("oracle.manageddataaccess.client"); MessageBox.Show(string.Format("Config File Path = [{0}]", ConfiguratuionHelper.GetCustomConfigFilePath()), "Custom Configuration File Path"); string configFileName = ConfiguratuionHelper.GetExecutingAssemblyConfigFileName(); }
/// <summary> /// Constructor which takes the connection string name /// </summary> /// <param name="connectionStringName"></param> public OracleDBAccessor(string connectionStringName) { Configuration configuration = ConfiguratuionHelper.GetConfiguration(string.Empty); ConfigurationSection oracleSection = configuration.GetSection("oracle.manageddataaccess.client"); string connectionString = configuration.ConnectionStrings.ConnectionStrings[connectionStringName].ConnectionString; _connection = new OracleConnection(connectionString); }
private void btnConfiguration_Click(object sender, EventArgs e) { var ConnectionStrings = ConfiguratuionHelper.GetConfiguration(string.Empty).ConnectionStrings; if (ConnectionStrings != null && ConnectionStrings.ConnectionStrings["OracleConnection"] != null) { MessageBox.Show(string.Format("Oracle Connection Definition = [{0}]", ConnectionStrings.ConnectionStrings["OracleConnection"].ConnectionString), "Oracle Connection Info"); } else { MessageBox.Show("There is no Oracle connection information defined!", "Oracle Connection Info"); } }
/// <summary> /// Constructor which takes "ExcelConnection" /// </summary> /// <param name="connectionName"></param> public ExcelDBAccessor(string connectionName) { if (string.IsNullOrWhiteSpace(connectionName)) { throw new ArgumentNullException("connectionName"); } Configuration configuration = ConfiguratuionHelper.GetConfiguration(string.Empty); string connectionString = configuration.ConnectionStrings.ConnectionStrings[connectionName].ConnectionString; this._connection = new OleDbConnection(connectionString); this._connectionName = connectionName; }