/// <summary>
/// Creates the dependency enlisters for any dependecies that require notification enlistment
/// </summary>
/// <param name="dependencyConfig">Settings for the dependencies</param>
/// <param name="defaultConnectionName">connection name to use when setting up data dependencies if no connection string provider is specified</param>
/// <param name="defaultConnectionString">default connection string to use for data dependencies if no connection string provider is specified </param>
private void CreateDependencyEnlisters(CacheDependenciesElement dependencyConfig, string defaultConnectionName,
string defaultConnectionString)
{
//dont do anything if there is no config
if (dependencyConfig == null)
{
log.Debug("no data dependencies specified");
return;
}
//build the table dependency enlisters
if (dependencyConfig.TableDependencies.Count > 0)
{
foreach (TableCacheDependencyElement tableConfig in dependencyConfig.TableDependencies)
{
if (log.IsDebugEnabled)
{
log.DebugFormat("configuring sql table dependency, '{0}' using table, '{1}', and database entry. '{2}'",
tableConfig.Name, tableConfig.TableName, tableConfig.DatabaseEntryName);
}
var tableEnlister = new SqlTableCacheDependencyEnlister(tableConfig.TableName, tableConfig.DatabaseEntryName);
_dependencyEnlisters.Add(tableEnlister);
}
}
//build the command dependency enlisters
if (dependencyConfig.CommandDependencies.Count > 0)
{
foreach (CommandCacheDependencyElement commandConfig in dependencyConfig.CommandDependencies)
{
//construct the correct connection string provider, we will do are best fallback to a connection string provider
//that will help us find a connection string even if one isnt specified
if (log.IsDebugEnabled)
{
log.DebugFormat("configuring sql command dependency, '{0}', using command, '{1}'", commandConfig.Name,
commandConfig.Command);
log.DebugFormat("command configured as stored procedure: {0}", commandConfig.IsStoredProcedure);
}
IConnectionStringProvider connectionStringProvider;
string connectionName = null;
if (commandConfig.ConnectionStringProviderType != null)
{
if (log.IsDebugEnabled)
{
log.DebugFormat("Activating configured connection string provider, '{0}'",
commandConfig.ConnectionStringProviderType.ToString());
}
connectionStringProvider =
Activator.CreateInstance(commandConfig.ConnectionStringProviderType) as IConnectionStringProvider;
connectionName = commandConfig.ConnectionName;
}
else
{
//no connection string provider specified so use the appropriate default
//if a connection string was specified and we dont have a specifi name in the cache regions settings
//then just use the default connection string
if (String.IsNullOrEmpty(defaultConnectionName) && String.IsNullOrEmpty(commandConfig.ConnectionName))
{
log.DebugFormat("no connection string provider specified using nhibernate configured connection string");
connectionStringProvider = new StaticConnectionStringProvider(defaultConnectionString);
}
else
{
//we dont have any connection strings specified so we must get it from config
connectionStringProvider = new ConfigConnectionStringProvider();
//tweak the connection name based on whether the region has one specified or not
if (String.IsNullOrEmpty(commandConfig.ConnectionName) == false)
{
connectionName = commandConfig.ConnectionName;
}
else
{
connectionName = defaultConnectionName;
}
if (log.IsDebugEnabled)
{
log.DebugFormat("no connection string provider specified, using connection with name : {0}", connectionName);
}
}
}
var commandEnlister = new SqlCommandCacheDependencyEnlister(commandConfig.Command, commandConfig.IsStoredProcedure,
commandConfig.CommandTimeout, connectionName,
connectionStringProvider);
_dependencyEnlisters.Add(commandEnlister);
}
}
}
/// <summary>
/// Creates the dependency enlisters for any dependecies that require notification enlistment
/// </summary>
/// <param name="dependencyConfig">Settings for the dependencies</param>
/// <param name="defaultConnectionName">connection name to use when setting up data dependencies if no connection string provider is specified</param>
/// <param name="defaultConnectionString">default connection string to use for data dependencies if no connection string provider is specified </param>
private void CreateDependencyEnlisters(CacheDependenciesElement dependencyConfig, string defaultConnectionName,
string defaultConnectionString)
{
//dont do anything if there is no config
if (dependencyConfig == null)
{
log.Debug("no data dependencies specified");
return;
}
//build the table dependency enlisters
if (dependencyConfig.TableDependencies.Count > 0)
{
foreach (TableCacheDependencyElement tableConfig in dependencyConfig.TableDependencies)
{
if (log.IsDebugEnabled)
{
log.DebugFormat("configuring sql table dependency, '{0}' using table, '{1}', and database entry. '{2}'",
tableConfig.Name, tableConfig.TableName, tableConfig.DatabaseEntryName);
}
var tableEnlister = new SqlTableCacheDependencyEnlister(tableConfig.TableName, tableConfig.DatabaseEntryName);
_dependencyEnlisters.Add(tableEnlister);
}
}
//build the command dependency enlisters
if (dependencyConfig.CommandDependencies.Count > 0)
{
foreach (CommandCacheDependencyElement commandConfig in dependencyConfig.CommandDependencies)
{
//construct the correct connection string provider, we will do are best fallback to a connection string provider
//that will help us find a connection string even if one isnt specified
if (log.IsDebugEnabled)
{
log.DebugFormat("configuring sql command dependency, '{0}', using command, '{1}'", commandConfig.Name,
commandConfig.Command);
log.DebugFormat("command configured as stored procedure: {0}", commandConfig.IsStoredProcedure);
}
IConnectionStringProvider connectionStringProvider;
string connectionName = null;
if (commandConfig.ConnectionStringProviderType != null)
{
if (log.IsDebugEnabled)
{
log.DebugFormat("Activating configured connection string provider, '{0}'",
commandConfig.ConnectionStringProviderType.ToString());
}
connectionStringProvider =
Activator.CreateInstance(commandConfig.ConnectionStringProviderType) as IConnectionStringProvider;
connectionName = commandConfig.ConnectionName;
}
else
{
//no connection string provider specified so use the appropriate default
//if a connection string was specified and we dont have a specifi name in the cache regions settings
//then just use the default connection string
if (String.IsNullOrEmpty(defaultConnectionName) && String.IsNullOrEmpty(commandConfig.ConnectionName))
{
log.DebugFormat("no connection string provider specified using nhibernate configured connection string");
connectionStringProvider = new StaticConnectionStringProvider(defaultConnectionString);
}
else
{
//we dont have any connection strings specified so we must get it from config
connectionStringProvider = new ConfigConnectionStringProvider();
//tweak the connection name based on whether the region has one specified or not
if (String.IsNullOrEmpty(commandConfig.ConnectionName) == false)
{
connectionName = commandConfig.ConnectionName;
}
else
{
connectionName = defaultConnectionName;
}
if (log.IsDebugEnabled)
{
log.DebugFormat("no connection string provider specified, using connection with name : {0}", connectionName);
}
}
}
var commandEnlister = new SqlCommandCacheDependencyEnlister(commandConfig.Command, commandConfig.IsStoredProcedure,
commandConfig.CommandTimeout, connectionName,
connectionStringProvider);
_dependencyEnlisters.Add(commandEnlister);
}
}
}