public ConnectionStringsSectionNodeBuilder(IServiceProvider serviceProvider, ConnectionStringsSection conectionStringsSection, string defaultDatabaseName, DatabaseSectionNode databaseSectionNode)
: base(serviceProvider)
{
this.connectionStringSections = conectionStringsSection;
this.databaseSectionNode = databaseSectionNode;
this.defaultDatabaseName = defaultDatabaseName;
}
public void SkipsConnectionStringsWithoutProviderNamesOrWithProviderNamesWhichDoNotMapToAProviderFactory()
{
DictionaryConfigurationSource configurationSource = new DictionaryConfigurationSource();
ConnectionStringsSection section = new ConnectionStringsSection();
section.ConnectionStrings.Add(new ConnectionStringSettings("cs1", "cs1", "System.Data.SqlClient"));
section.ConnectionStrings.Add(new ConnectionStringSettings("cs2", "cs2"));
section.ConnectionStrings.Add(new ConnectionStringSettings("cs3", "cs3", "a bogus provider name"));
section.ConnectionStrings.Add(new ConnectionStringSettings("cs4", "cs4", "System.Data.SqlClient"));
configurationSource.Add("connectionStrings", section);
var factory = new DatabaseProviderFactory(configurationSource.GetSection);
Assert.AreEqual("cs1", factory.Create("cs1").ConnectionString);
Assert.AreEqual("cs4", factory.Create("cs4").ConnectionString);
try
{
factory.Create("cs2");
Assert.Fail("should have thrown");
}
catch (InvalidOperationException)
{
// expected, connection string is ignored
}
try
{
factory.Create("cs3");
Assert.Fail("should have thrown");
}
catch (InvalidOperationException)
{
// expected, connection string is ignored
}
}
internal static string GetConnectionString(string name)
{
// Get the connectionStrings section.
System.Configuration.ConnectionStringsSection connectionStringsSection =
WebConfigurationManager.GetSection("connectionStrings")
as System.Configuration.ConnectionStringsSection;
ConnectionStringSettingsCollection connectionStrings =
connectionStringsSection.ConnectionStrings;
// Get the connectionStrings key,value pairs collection.
IEnumerator connectionStringsEnum = connectionStrings.GetEnumerator();
int i = 0;
while (connectionStringsEnum.MoveNext())
{
if (name == connectionStrings[i].Name)
{
return(connectionStrings[i].ConnectionString);
}
i += 1;
}
return("");
}
/// <summary>
/// 根据键值获取ConnectionStrings配置文件
/// </summary>
/// <returns></returns>
public static Dictionary <string, string> GetConnectionStringsConfig()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
try
{
foreach (string key in ConfigurationManager.ConnectionStrings)
{
dict.Add(key, ConfigurationManager.ConnectionStrings[key].ToString());
}
}
catch (Exception)
{
// Get the configuration file.
System.Configuration.Configuration config =
ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
// Get the appSettings section.
System.Configuration.ConnectionStringsSection appSettings =
(System.Configuration.ConnectionStringsSection)config.GetSection("connectionStrings");
if (appSettings.ConnectionStrings.Count != 0)
{
foreach (string key in appSettings.ConnectionStrings)
{
string value = appSettings.ConnectionStrings[key].ToString();
dict.Add(key, value);
}
}
}
return(dict);
}
static ConnectionStringsSection GetConnectionStringsSection()
{
ConnectionStringsSection section = new ConnectionStringsSection();
ConnectionStringSettings connectionStringSettings = new ConnectionStringSettings(instanceName, connectionString, providerName);
section.ConnectionStrings.Add(connectionStringSettings);
return section;
}
// This function shows how to write a key/value
// pair to the appSettings section.
static void WriteSettings(string name, string connectionString, string providerName)
{
// Get the application configuration file.
System.Configuration.Configuration config =
ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
//// Create a unique key/value pair to add to
//// the appSettings section.
//string keyName = "AppStg" + config.AppSettings.Settings.Count;
//string value = string.Concat(DateTime.Now.ToLongDateString(),
// " ", DateTime.Now.ToLongTimeString());
//// Add the key/value pair to the appSettings
//// section.
//// config.AppSettings.Settings.Add(keyName, value);
//System.Configuration.AppSettingsSection appSettings = config.AppSettings;
//appSettings.Settings.Add(keyName, value);
//// Save the configuration file.
//config.Save(ConfigurationSaveMode.Modified);
//// Force a reload in memory of the changed section.
//// This to to read the section with the
//// updated values.
//ConfigurationManager.RefreshSection("appSettings");
System.Configuration.ConnectionStringsSection connection = config.ConnectionStrings;
connection.ConnectionStrings.Remove("Name");
connection.ConnectionStrings.Add(new ConnectionStringSettings(name, connectionString, providerName));
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("connectionStrings");
}
public void AddTo(ConnectionStringsSection section)
{
var setting = new ConnectionStringSettings(settings.Name,
settings.ConnectionString, settings.ProviderName);
section.ConnectionStrings.Add(setting);
}
/// <summary>Sets properties configuration dictionary based on configuration in the database section.</summary>
/// <param name="config">The database section configuration.</param>
/// <param name="connectionStrings">Connection strings from configuration</param>
protected void SetupProperties(DatabaseSection config, ConnectionStringsSection connectionStrings)
{
NHibernate.Cfg.Environment.UseReflectionOptimizer = Utility.GetTrustLevel() > System.Web.AspNetHostingPermissionLevel.Medium;
// connection
Properties[NHibernate.Cfg.Environment.ConnectionStringName] = config.ConnectionStringName;
Properties[NHibernate.Cfg.Environment.ConnectionProvider] = "NHibernate.Connection.DriverConnectionProvider";
Properties[NHibernate.Cfg.Environment.Hbm2ddlKeyWords] = "none";
SetupFlavourProperties(config, connectionStrings);
bool useNonBatcher =
// configured batch size <= 1
(batchSize.HasValue && batchSize.Value <= 1)
// medium trust in combination with sql client driver
// causes fault: Attempt by method 'NHibernate.AdoNet.SqlClientSqlCommandSet..ctor()' to access method 'System.Data.SqlClient.SqlCommandSet..ctor()' failed. at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
|| (Utility.GetTrustLevel() <= System.Web.AspNetHostingPermissionLevel.Medium && typeof(SqlClientDriver).IsAssignableFrom(Type.GetType(Properties[Environment.ConnectionDriver])));
if (useNonBatcher)
Properties[NHibernate.Cfg.Environment.BatchStrategy] = typeof(NonBatchingBatcherFactory).AssemblyQualifiedName;
SetupCacheProperties(config);
if (config.Isolation.HasValue)
Properties[NHibernate.Cfg.Environment.Isolation] = config.Isolation.ToString();
foreach (string key in config.HibernateProperties.AllKeys)
{
Properties[key] = config.HibernateProperties[key].Value;
}
}
public void SetUp()
{
loggingSettings = new LoggingSettings();
connectionStringsSection = new ConnectionStringsSection();
configurationSource = new DictionaryConfigurationSource();
configurationSource.Add(LoggingSettings.SectionName, loggingSettings);
configurationSource.Add("connectionStrings", connectionStringsSection);
}
public void SetConnectionString(string str_Key, string str_ConnectionString)
{
Configuration myConfig = System.Configuration.ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
System.Configuration.ConnectionStringsSection mySection = (System.Configuration.ConnectionStringsSection)myConfig.GetSection("connectionStrings");
mySection.ConnectionStrings[str_Key].ConnectionString = str_ConnectionString;
myConfig.Save();
}
private static ConnectionStringsSection GenerateConnectionStringSection()
{
ConnectionStringsSection section = new ConnectionStringsSection();
section.ConnectionStrings.Add(new ConnectionStringSettings("Service_Dflt", "Data Source=ORACLE82;User id=system;Password=aaaabbbccc;", "Oracle.DataAccess.Client"));
section.ConnectionStrings.Add(new ConnectionStringSettings("NewDatabase", "Data Source=XE;User id=system;Password=admin;", "Oracle.DataAccess.Client"));
section.ConnectionStrings.Add(new ConnectionStringSettings("DbWithOracleAuthn", "Data Source=XE;User id=system;Password=admin;", "Oracle.DataAccess.Client"));
section.ConnectionStrings.Add(new ConnectionStringSettings("NwindPersistFalse", "Data Source=XE;User id=system;Password=admin;Persist Security Info=false;", "Oracle.DataAccess.Client"));
return section;
}
public ConnectionStringsSection Build()
{
connectionStringsSection = new ConnectionStringsSection();
foreach (ConnectionStringSettingsNode node in connectionStringsSectionNode.Nodes)
{
BuildConnectionString(node);
}
return connectionStringsSection;
}
public static void Reload()
{
Config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.PerUserRoamingAndLocal);
ConnectionStringsSection = Config.GetSection("userConnectionStrings") as System.Configuration.ConnectionStringsSection;
if (ConnectionStringsSection == null)
{
ConnectionStringsSection = new System.Configuration.ConnectionStringsSection();
ConnectionStringsSection.SectionInformation.set_AllowExeDefinition(ConfigurationAllowExeDefinition.MachineToLocalUser);
Config.Sections.Add("userConnectionStrings", ConnectionStringsSection);
Config.Save();
}
}
/// <summary>
/// Initializes a new instance of the <see cref="DBInfo"/> class.
/// </summary>
/// <param name="connectionStringSettings">
/// The db connection settings
/// </param>
public DBInfo(string connectionString)
{
if (string.IsNullOrEmpty(connectionString))
throw new ArgumentNullException("connectionStringSettings");
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
ConnectionStringSettings connectionStringSettings = new ConnectionStringSettings(Constants.ConnectionStringSettingsName, connectionString, Constants.SystemDataSqlite);
ConnectionStringsSection section = new ConnectionStringsSection();
section.ConnectionStrings.Add(connectionStringSettings);
source.Add("connectionStrings", section);
this._database = new DatabaseProviderFactory(source).Create(connectionStringSettings.Name);
this.CreateConnection();
}
void IAddTo.AddTo(IConfigurationSource configurationSource)
{
var section = new ConnectionStringsSection();
foreach(var builder in builders)
{
builder.AddTo(section);
}
configurationSource.Add("connectionStrings", section);
var databaseSettings = new DatabaseSettings {DefaultDatabase = defaultDatabase};
configurationSource.Add(DatabaseSettings.SectionName, databaseSettings);
}
public static DictionaryConfigurationSource CreateConfigurationSource()
{
DictionaryConfigurationSource configSource = TestConfigurationSource.CreateConfigurationSource();
var connectionString = new ConnectionStringSettings(
OracleConnectionStringName,
OracleConnectionString,
OracleProviderName);
var connectionStrings = new ConnectionStringsSection();
connectionStrings.ConnectionStrings.Add(connectionString);
configSource.Add("connectionStrings", connectionStrings);
return configSource;
}
/// <summary>
/// Sets the connection string value in the given config file
/// </summary>
/// <param name="installer"></param>
/// <param name="configFilePath"></param>
/// <param name="connectionString"></param>
public static void SetConnectionStringInConfigFile(string configFilePath, string name, string connectionString)
{
var configuration = OpenConfigFile(configFilePath);
System.Configuration.ConnectionStringsSection sec = configuration.GetSection("connectionStrings") as ConnectionStringsSection;
if (sec.ConnectionStrings[name] == null)
{
sec.ConnectionStrings.Add(new ConnectionStringSettings(name, connectionString));
}
else
{
sec.ConnectionStrings[name].ConnectionString = connectionString;
}
configuration.Save();
}
public void Given()
{
configurationSource = new DictionaryConfigurationSource();
var connectionStringsSection = new ConnectionStringsSection();
connectionStringsSection.ConnectionStrings.Add(
new ConnectionStringSettings
{
Name = "odbc connection",
ConnectionString = "connection string",
ProviderName = "System.Data.Odbc"
});
configurationSource.Add("connectionStrings", connectionStringsSection);
settings = new DatabaseSyntheticConfigSettings(configurationSource.GetSection);
}
public static DictionaryConfigurationSource CreateConfigurationSource()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
settings.DefaultDatabase = "SqlCeTestConnection";
ConnectionStringsSection section = new ConnectionStringsSection();
section.ConnectionStrings.Add(new ConnectionStringSettings("SqlCeTestConnection", "Data Source='testdb.sdf'", "System.Data.SqlServerCe.3.5"));
source.Add(DatabaseSettings.SectionName, settings);
source.Add("connectionStrings", section);
return source;
}
protected override void Act()
{
var section = new ConnectionStringsSection();
source = new DesignDictionaryConfigurationSource();
source.Add("connectionStrings", section);
var configurationSection = source.GetSection(DataAccessDesignTime.ConnectionStringSettingsSectionName);
var configurationSourceModel = Container.Resolve<ConfigurationSourceModel>();
configurationSourceModel.Load(source);
var databaseSectionViewModel = configurationSourceModel.Sections
.Where(x => x.SectionName == DataAccessDesignTime.ConnectionStringSettingsSectionName)
.Single();
databaseSectionViewModel.Save(source);
}
/// <summary>Creates a new instance of the <see cref="ConfigurationBuilder"/>.</summary>
public ConfigurationBuilder(IDefinitionProvider[] definitionProviders, ClassMappingGenerator generator, IWebContext webContext, ConfigurationBuilderParticipator[] participators, DatabaseSection config, ConnectionStringsSection connectionStrings)
{
this.definitionProviders = definitionProviders;
this.generator = generator;
this.webContext = webContext;
this.participators = participators;
if (config == null) config = new DatabaseSection();
TryLocatingHbmResources = config.TryLocatingHbmResources;
tablePrefix = config.TablePrefix;
batchSize = config.BatchSize;
childrenLaziness = config.ChildrenLaziness;
SetupProperties(config, connectionStrings);
SetupMappings(config);
}
/// <summary>Creates a new instance of the <see cref="ConfigurationBuilder"/>.</summary>
public ConfigurationBuilder(IDefinitionManager definitions, ClassMappingGenerator generator, DatabaseSection config, ConnectionStringsSection connectionStrings)
{
this.definitions = definitions;
this.generator = generator;
if (config == null) config = new DatabaseSection();
if (!string.IsNullOrEmpty(config.HibernateMapping))
DefaultMapping = config.HibernateMapping;
SetupProperties(config, connectionStrings);
SetupMappings(config);
TryLocatingHbmResources = config.TryLocatingHbmResources;
tablePrefix = config.TablePrefix;
batchSize = config.BatchSize;
childrenLaziness = config.ChildrenLaziness;
}
public Configuracoes mudaConfigurações()
{
SqlConnectionStringBuilder myCSB = new SqlConnectionStringBuilder();
ConnectionStringsSection csSection = new ConnectionStringsSection();
#region Implementação
myCSB.DataSource = config.Servidor;
myCSB.InitialCatalog = config.Database;
myCSB.UserID = config.User;
myCSB.Password = config.Senha;
config.ConectionString = myCSB.ConnectionString;
return config;
#endregion
}
//##### INICIALIZA LOS DATOS DEL APPCONFIG #####
public ClassModConfig()
{
try
{
MiAppConfig = ConfigurationManager.OpenExeConfiguration(Application.ExecutablePath); //Se abre el app.config
CadenaConexion = (ConnectionStringsSection)MiAppConfig.GetSection("connectionStrings"); //Obtengo la cadena de conexion
MiConfig = (AppSettingsSection)MiAppConfig.GetSection("appSettings"); //Obtengo la seccion appSettings
MiCnx = ConfigurationManager.ConnectionStrings["EnterpriseSolution.Properties.Settings.bdnominaConnectionString"]; //capturo cadena de conexion
Estado = ConfigurationManager.AppSettings["Validador"];
Licencia = ConfigurationManager.AppSettings["Licencia"];
InfEmp = ConfigurationManager.AppSettings["InfEmp"];
Skins = ConfigurationManager.AppSettings["Skins"];
Update = ConfigurationManager.AppSettings["Update"];
}
catch (Exception ex)
{
MsjErr.MsjBox(1, "ERR001-01", "No se pueden leer todos los valores del app.config - " + ex.ToString());
Environment.Exit(0);
}
}
public virtual object Create (object parent, object configContext, XmlNode section)
{
ConnectionStringsSection csSection = new ConnectionStringsSection ();
ConnectionStringSettingsCollection csList = csSection.ConnectionStrings;
foreach (XmlNode addNode in section.SelectNodes (".//add")) {
if (addNode.NodeType != XmlNodeType.Element)
continue;
string name;
string providerName;
string connectionString;
name = GetAttributeValue (addNode, "name");
providerName = GetAttributeValue (addNode, "providerName");
connectionString = GetAttributeValue (addNode, "connectionString");
ConnectionStringSettings cs = new ConnectionStringSettings (name, connectionString, providerName);
csList.Add (cs);
}
return csSection;
}
private AzureFileSystem Init(ConnectionStringsSection connectionStrings, string containerName, bool isPrivate = false)
{
ConnectionStringSettings css = connectionStrings.ConnectionStrings["AzureStorageConnection"];
string connectionString = css != null
? css.ConnectionString
: (ConfigurationManager.AppSettings["AzureStorageConnectionString"] ?? "UseDevelopmentStorage=true");
var account = CloudStorageAccount.Parse(connectionString);
if (string.IsNullOrEmpty(containerName))
containerName = ConfigurationManager.AppSettings["AzureStorageContainerName"] ?? "n2tests";
_root = ConfigurationManager.AppSettings["AzureStorageRootFolderName"] ?? "default"; // orchard: default
string delAll = ConfigurationManager.AppSettings["AzureStorageDeleteAllOnStartup"] ?? "false";
if (account == null)
throw new ConfigurationErrorsException("Bad Azure Storage Configuration");
var isp = new AzureFileSystem(containerName, _root, isPrivate, account);
if (delAll.Equals("true", StringComparison.InvariantCultureIgnoreCase))
{
isp.Container.DeleteAllBlobs(); // start with a fresh container, used in unit tests
}
return isp;
}
private void LoadConnectionStrings()
{
var map = new ExeConfigurationFileMap();
map.ExeConfigFilename = FindConfig("K2HostServer.config", "K2HostServer.exe.config");
_configuration = ConfigurationManager.OpenMappedExeConfiguration(map, ConfigurationUserLevel.None);
_connectionStrings = _configuration.GetSection("connectionStrings") as ConnectionStringsSection;
foreach (ConnectionStringSettings item in _connectionStrings.ConnectionStrings)
{
try
{
var colonIndex = item.Name.IndexOf(':');
string connectionStringName = null, targetEntity = null;
if (colonIndex < 0)
{
connectionStringName = item.Name;
}
else
{
connectionStringName = item.Name.Substring(0, colonIndex);
targetEntity = item.Name.Substring(colonIndex + 1);
}
IConnectionStringLoader loader;
if (_loaders.TryGetValue(connectionStringName, out loader))
{
var connectionString = loader.LoadConnectionString(item.ConnectionString);
var info = new ConnectionStringInfo(targetEntity, connectionStringName, connectionString);
mainListBox.Items.Add(info);
}
}
catch (Exception ex)
{
FriendlyException.ThrowFatal("Failure loading connection strings", ex.Message);
}
}
}
/// <summary>
/// Configures the properties of each supported database flavor. You need to extend this method if you want to
/// add your own database flavor.
/// </summary>
/// <param name="config"></param>
/// <param name="connectionStrings"></param>
/// <returns></returns>
private DatabaseFlavour SetupFlavourProperties(DatabaseSection config, ConnectionStringsSection connectionStrings)
{
DatabaseFlavour flavour = config.Flavour;
if (flavour == DatabaseFlavour.AutoDetect)
{
ConnectionStringSettings css = connectionStrings.ConnectionStrings[config.ConnectionStringName];
if (css == null)
throw new ConfigurationErrorsException("Could not find the connection string named '" + config.ConnectionStringName + "' that was defined in the n2/database configuration section. If you installed using NuGet try installing 'N2 CMS SQLite config' or configuring this connection string manually.");
flavour = DetectFlavor(css);
}
// HACK: used to support seamless text/nvarchar(max) support across databases
if (flavour == DatabaseFlavour.MySql)
stringLength = 16777215;
switch (flavour)
{
case DatabaseFlavour.SqlServer2000:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.SqlClientDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.MsSql2000Dialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.SqlServer2005:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.SqlClientDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.MsSql2005Dialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.SqlServer:
case DatabaseFlavour.SqlServer2008:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.SqlClientDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.MsSql2008Dialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.SqlCe3:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.SqlServerCeDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.MsSqlCeDialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.SqlCe:
case DatabaseFlavour.SqlCe4:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.SqlServerCeDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.MsSqlCe40Dialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.MySql:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.MySqlDataDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.MySQL5Dialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.SqLite:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.SQLite20Driver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.SQLiteDialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.Firebird:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.FirebirdDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.FirebirdDialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.Generic:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.OleDbDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.GenericDialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.Jet:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = "NHibernate.JetDriver.JetDriver, NHibernate.JetDriver";
Properties[NHibernate.Cfg.Environment.Dialect] = "NHibernate.JetDriver.JetDialect, NHibernate.JetDriver";
break;
case DatabaseFlavour.DB2:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.OdbcDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.DB2Dialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.Oracle9i:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.OracleClientDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.Oracle9iDialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.Oracle:
case DatabaseFlavour.Oracle10g:
// if you have OracleOdpDriver installed
// use the following line instead of the the later one (NOTICE both apply to the same property)
// Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.OracleDataClientDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.OracleClientDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.Oracle10gDialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.MongoDB:
return DatabaseFlavour.MongoDB;
case DatabaseFlavour.Xml:
return DatabaseFlavour.Xml;
default:
throw new ConfigurationErrorsException("Couldn't determine database flavour. Please check the 'flavour' attribute of the n2/database configuration section.");
}
return flavour;
}
private static void ToggleConnectionStringProtection(string pathName, bool protect)
{
// Define the Dpapi provider name.
string strProvider = "DataProtectionConfigurationProvider";
// string strProvider = "RSAProtectedConfigurationProvider";
System.Configuration.Configuration oConfiguration = null;
System.Configuration.ConnectionStringsSection oSection = null;
try
{
// Open the configuration file and retrieve
// the connectionStrings section.
// For Web!
// oConfiguration = System.Web.Configuration.
// WebConfigurationManager.OpenWebConfiguration("~");
// For Windows!
// Takes the executable file name without the config extension.
oConfiguration = System.Configuration.ConfigurationManager.OpenExeConfiguration(pathName);
if (oConfiguration != null)
{
bool blnChanged = false;
oSection = oConfiguration.GetSection("connectionStrings") as
System.Configuration.ConnectionStringsSection;
if (oSection != null)
{
if ((!(oSection.ElementInformation.IsLocked)) &&
(!(oSection.SectionInformation.IsLocked)))
{
if (protect)
{
if (!(oSection.SectionInformation.IsProtected))
{
blnChanged = true;
// Encrypt the section.
oSection.SectionInformation.ProtectSection(strProvider);
}
}
else
{
if (oSection.SectionInformation.IsProtected)
{
blnChanged = true;
// Remove encryption.
oSection.SectionInformation.UnprotectSection();
}
}
}
if (blnChanged)
{
// Indicates whether the associated configuration section
// will be saved even if it has not been modified.
oSection.SectionInformation.ForceSave = true;
// Save the current configuration.
oConfiguration.Save();
ConfigurationManager.RefreshSection("connectionStrings");
}
}
}
}
catch (System.Exception ex)
{
throw (ex);
}
finally
{
}
}
public object GetSection(string configKey)
{
object section = clientConfigSystem.GetSection(configKey);
switch (configKey)
{
case "appSettings":
if (appSettings != null)
return appSettings;
if (section is NameValueCollection)
{
if (configProviders != null)
{
var cfg = new NameValueCollection();
NameValueCollection localSettings = (NameValueCollection)section;
foreach (string key in localSettings)
{
cfg.Add(key, localSettings[key]);
}
foreach (var configProvider in configProviders)
{
var settings = configProvider.GetAppSettings();
if (settings != null)
{
foreach (string key in settings)
{
cfg.Add(key, settings[key]);
}
}
}
this.appSettings = cfg;
section = this.appSettings;
}
else
{
this.appSettings = section;
}
}
break;
case "connectionStrings":
if (this.connectionStrings != null)
{
return this.connectionStrings;
}
if (configProviders != null)
{
ConnectionStringsSection connectionStringsSection = new ConnectionStringsSection();
foreach (ConnectionStringSettings connectionStringSetting in ((ConnectionStringsSection)section).ConnectionStrings)
{
connectionStringsSection.ConnectionStrings.Add(connectionStringSetting);
}
foreach (var configProvider in configProviders)
{
var conns = configProvider.GetConnectionStrings();
if (conns != null)
{
foreach (ConnectionStringSettings connectionStringSetting in conns)
{
connectionStringsSection.ConnectionStrings.Add(connectionStringSetting);
}
}
}
this.connectionStrings = connectionStringsSection;
section = this.connectionStrings;
}
else
{
this.connectionStrings = section;
}
break;
}
return section;
}
protected override void Arrange()
{
base.Arrange();
section = new ConnectionStringsSection();
section.ConnectionStrings.Add(new ConnectionStringSettings("name", "conn1"));
section.ConnectionStrings.Add(new ConnectionStringSettings("name2", "conn2"));
}
private static void ToggleConnectionStringProtection
(string pathName, bool protect)
{
// Define the Dpapi provider name.
string strProvider = "DataProtectionConfigurationProvider";
// string strProvider = "RSAProtectedConfigurationProvider";
System.Configuration.Configuration oConfiguration = null;
System.Configuration.ConnectionStringsSection oSection = null;
try
{
// Open the configuration file and retrieve
// the connectionStrings section.
// For Web!
oConfiguration = System.Web.Configuration.
WebConfigurationManager.OpenWebConfiguration("~");
// For Windows!
// Takes the executable file name without the config extension.
//oConfiguration = System.Configuration.ConfigurationManager.
// OpenExeConfiguration(pathName);
if (oConfiguration != null)
{
bool blnChanged = false;
oSection = oConfiguration.GetSection("connectionStrings") as
System.Configuration.ConnectionStringsSection;
if (oSection != null)
{
if ((!(oSection.ElementInformation.IsLocked)) &&
(!(oSection.SectionInformation.IsLocked)))
{
if (protect)
{
if (!(oSection.SectionInformation.IsProtected))
{
blnChanged = true;
// Encrypt the section.
oSection.SectionInformation.ProtectSection
(strProvider);
oConfiguration.AppSettings.Settings["Cypher"].Value = "true";
}
}
else
{
if (oSection.SectionInformation.IsProtected)
{
blnChanged = true;
// Remove encryption.
oSection.SectionInformation.UnprotectSection();
System.Configuration.ConnectionStringSettings connString = new ConnectionStringSettings();
if (0 < oConfiguration.ConnectionStrings.ConnectionStrings.Count)
{
connString =
oConfiguration.ConnectionStrings.ConnectionStrings["CNTSEntities"];
}
string con = connString.ConnectionString;
int inicio = con.IndexOf("\"");
int fin = con.IndexOf("\"", inicio + 1);
string conectionString = con.Substring(inicio + 1, fin - inicio - 1);
}
}
}
if (blnChanged)
{
// Indicates whether the associated configuration section
// will be saved even if it has not been modified.
oSection.SectionInformation.ForceSave = true;
// Save the current configuration.
oConfiguration.Save();
}
}
}
}
catch (System.Exception ex)
{
throw (ex);
}
finally
{
}
}
private void Initialization(string ConfigPath)
{
fileMap = new ExeConfigurationFileMap();
fileMap.ExeConfigFilename = ConfigPath;
config = ConfigurationManager.OpenMappedExeConfiguration(fileMap, ConfigurationUserLevel.None);
AppSettings = (AppSettingsSection)config.GetSection("appSettings");
ConnectionStrings = (ConnectionStringsSection)config.GetSection("connectionStrings");
}
/// <summary>
/// 子类重载实现资源释放逻辑
/// </summary>
/// <param name="disposing">从Dispose调用（释放所有资源）还是析构函数调用（释放非托管资源）</param>
protected override void OnDispose(Boolean disposing)
{
base.OnDispose(disposing);
if (disposing)
{
// 释放托管资源
fileMap = null;
AppSettings = null;
ConnectionStrings = null;
config = null;
}
cacheLock.Dispose();
// 释放非托管资源
}
/// <summary>GetConnectionSection 用于改更ConnectionStrings节点对像</summary>
/// <param name="GroupsName"></param>
/// <param name="SectionsName"></param>
/// <param name="Create">如果节点不存在是否创建</param>
public void GetConnectionSection(string GroupsName, string SectionsName, bool Create)
{
if (DME_Validation.IsNull(SectionsName))
{
return;
}
if (DME_Validation.IsNull(GroupsName))
{
if (!DME_Validation.IsNull(config.GetSection(SectionsName)))
{
ConnectionStrings = (ConnectionStringsSection)config.GetSection(SectionsName);
}
else
{
if (Create)
{
ConnectionStrings = new ConnectionStringsSection();
config.Sections.Add(SectionsName, ConnectionStrings);
}
}
}
else
{
if (!DME_Validation.IsNull(config.GetSection(string.Format(@"{0}/{1}", GroupsName, SectionsName))))
{
ConnectionStrings = (ConnectionStringsSection)config.GetSection(string.Format(@"{0}/{1}", GroupsName, SectionsName));
}
else
{
if (Create)
{
ConnectionStrings = new ConnectionStringsSection();
if (config.GetSectionGroup(GroupsName) != null)
{
config.SectionGroups[GroupsName].Sections.Add(SectionsName, ConnectionStrings);
}
else
{
config.SectionGroups.Add(GroupsName, new ConfigurationSectionGroup());
config.SectionGroups[GroupsName].Sections.Add(SectionsName, ConnectionStrings);
}
}
}
}
}
public void Setup()
{
var configSource = new DictionaryConfigurationSource();
var connectionStrings = new ConnectionStringsSection();
connectionStrings.ConnectionStrings.Add(
new ConnectionStringSettings("someSetting", "someConnectionString", "System.Data.OracleClient"));
configSource.Add("connectionStrings", connectionStrings);
var oracleConnectionData = new OracleConnectionData { Name = "someSetting" };
oracleConnectionData.Packages.Add(new OraclePackageData("foo", "bar"));
var oracleSettings = new OracleConnectionSettings();
oracleSettings.OracleConnectionsData.Add(oracleConnectionData);
configSource.Add(OracleConnectionSettings.SectionName, oracleSettings);
configSettings = new DatabaseSyntheticConfigSettings(configSource);
}
public ConnectionStringsStore()
: base(new[] { typeof(string) })
{
_exeConfiguration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
_connectionStringsSection = _exeConfiguration.ConnectionStrings;
}
