/// <summary>
/// Method for invoking a specified Database service object. Reads service settings
/// from the ConnectionSettings.config file.
/// </summary>
/// <example>
/// <code>
/// Database dbSvc = DatabaseFactory.CreateDatabase("SQL_Customers");
/// </code>
/// </example>
/// <param name="instanceName">configuration key for database service</param>
/// <returns>Database</returns>
/// <exception cref="System.Configuration.ConfigurationException">
/// <para><paramref name="instanceName"/> is not defined in configuration.</para>
/// <para>- or -</para>
/// <para>An error exists in the configuration.</para>
/// <para>- or -</para>
/// <para>A error occured while reading the configuration.</para>
/// </exception>
/// <exception cref="System.Reflection.TargetInvocationException">
/// <para>The constructor being called throws an exception.</para>
/// </exception>
public static Database CreateDatabase(string instanceName)
{
ConfigurationContext context = ConfigurationManager.GetCurrentContext();
DatabaseProviderFactory factory = new DatabaseProviderFactory(context);
return(factory.CreateDatabase(instanceName));
}
private void ExecuteStoredProcedure(LogEntry logEntry)
{
DatabaseSinkData databaseSinkData = loggingConfigurationView.GetSinkData(ConfigurationName) as DatabaseSinkData;
DatabaseProviderFactory factory = new DatabaseProviderFactory(loggingConfigurationView.ConfigurationContext);
Data.Database db = factory.CreateDatabase(databaseSinkData.DatabaseInstanceName);
DBCommandWrapper cmd = db.GetStoredProcCommandWrapper(databaseSinkData.StoredProcName);
cmd.AddInParameter("eventID", DbType.Int32, logEntry.EventId);
cmd.AddInParameter("category", DbType.String, logEntry.Category);
cmd.AddInParameter("priority", DbType.Int32, logEntry.Priority);
cmd.AddInParameter("severity", DbType.String, logEntry.Severity.ToString());
cmd.AddInParameter("title", DbType.String, logEntry.Title);
cmd.AddInParameter("timestamp", DbType.DateTime, logEntry.TimeStamp);
cmd.AddInParameter("machineName", DbType.String, logEntry.MachineName);
cmd.AddInParameter("AppDomainName", DbType.String, logEntry.AppDomainName);
cmd.AddInParameter("ProcessID", DbType.String, logEntry.ProcessId);
cmd.AddInParameter("ProcessName", DbType.String, logEntry.ProcessName);
cmd.AddInParameter("ThreadName", DbType.String, logEntry.ManagedThreadName);
cmd.AddInParameter("Win32ThreadId", DbType.String, logEntry.Win32ThreadId);
cmd.AddInParameter("message", DbType.String, logEntry.Message);
cmd.AddInParameter("formattedmessage", DbType.String, FormatEntry(logEntry));
db.ExecuteNonQuery(cmd);
}
private Data.Database GetSecurityDatabase()
{
ProfileProviderData profileProviderData = securityConfigurationView.GetProfileProviderData(ConfigurationName);
ArgumentValidation.CheckExpectedType(profileProviderData, typeof(DbProfileProviderData));
DbProfileProviderData dbProfileProviderData = (DbProfileProviderData)profileProviderData;
DatabaseProviderFactory factory = new DatabaseProviderFactory(securityConfigurationView.ConfigurationContext);
return factory.CreateDatabase(dbProfileProviderData.Database);
}
/// <summary>
/// Method for invoking a specified Database service object. Reads service settings
/// from the ConnectionSettings.config file.
/// </summary>
/// <example>
/// <code>
/// Database dbSvc = DatabaseFactory.CreateDatabase("SQL_Customers");
/// </code>
/// </example>
/// <param name="instanceName">configuration key for database service</param>
/// <returns>Database</returns>
/// <exception cref="System.Configuration.ConfigurationException">
/// <para><paramref name="instanceName"/> is not defined in configuration.</para>
/// <para>- or -</para>
/// <para>An error exists in the configuration.</para>
/// <para>- or -</para>
/// <para>A error occured while reading the configuration.</para>
/// </exception>
/// <exception cref="System.Reflection.TargetInvocationException">
/// <para>The constructor being called throws an exception.</para>
/// </exception>
public static Database CreateDatabase(string instanceName)
{
ConfigurationContext context = ConfigurationManager.GetCurrentContext();
DatabaseProviderFactory factory = new DatabaseProviderFactory(context);
return factory.CreateDatabase(instanceName);
}
public override void FixtureSetup()
{
base.FixtureSetup();
DatabaseProviderFactory factory = new DatabaseProviderFactory(Context);
userDb = factory.CreateDatabase(DbServiceKey);
}
/// <summary>
/// Creates an instance of the utility class with a specified configuration context.
/// </summary>
/// <param name="databaseService">Database service instance name.</param>
/// <param name="context">The configuration context to use.</param>
public UserRoleManager(string databaseService, ConfigurationContext context)
{
DatabaseProviderFactory dbProviderFactory = new DatabaseProviderFactory(context);
this.securityDb = dbProviderFactory.CreateDatabase(databaseService);
}
/// <summary>
/// Initializes a new instance of the <see cref="DataBackingStore"/> class
/// with the specified configuration information.
/// </summary>
/// <param name="configurationView">A <see cref="CachingConfigurationView"></see> object</param>
/// <exception cref="System.Configuration.ConfigurationException">Reflects any failures to read configuration information</exception>
/// <remarks>Other exceptions thrown depend on the implementation of the underlying database.</remarks>
public override void Initialize(ConfigurationView configurationView)
{
ArgumentValidation.CheckForNullReference(configurationView, "configurationView");
ArgumentValidation.CheckExpectedType(configurationView, typeof (CachingConfigurationView));
CachingConfigurationView cachingConfigurationView = (CachingConfigurationView) configurationView;
DataCacheStorageData dataConfiguration = (DataCacheStorageData) cachingConfigurationView.GetCacheStorageDataForCacheManager(CurrentCacheManager);
partitionName = dataConfiguration.PartitionName;
DatabaseProviderFactory dataFactory = new DatabaseProviderFactory(cachingConfigurationView.ConfigurationContext);
database = dataFactory.CreateDatabase(dataConfiguration.DatabaseInstanceName);
if (dataConfiguration.StorageEncryption != null)
{
StorageEncryptionFactory encryptionFactory = new StorageEncryptionFactory(cachingConfigurationView.ConfigurationContext);
encryptionProvider = encryptionFactory.CreateSymmetricProvider(CurrentCacheManager);
}
}
