/// <summary>
/// Initializes PostgreSqlStorage from the provided PostgreSqlStorageOptions and either the provided connection
/// string or the connection string with provided name pulled from the application config file.
/// </summary>
/// <param name="nameOrConnectionString">Either a SQL Server connection string or the name of
/// a SQL Server connection string located in the connectionStrings node in the application config</param>
/// <param name="connectionSetup">Optional setup action to apply to created connections</param>
/// <param name="options"></param>
/// <exception cref="ArgumentNullException"><paramref name="nameOrConnectionString"/> argument is null.</exception>
/// <exception cref="ArgumentNullException"><paramref name="options"/> argument is null.</exception>
/// <exception cref="ArgumentException"><paramref name="nameOrConnectionString"/> argument is neither
/// a valid SQL Server connection string nor the name of a connection string in the application
/// config file.</exception>
public PostgreSqlStorage(string nameOrConnectionString, Action <NpgsqlConnection> connectionSetup,
PostgreSqlStorageOptions options)
{
if (nameOrConnectionString == null)
{
throw new ArgumentNullException(nameof(nameOrConnectionString));
}
_options = options ?? throw new ArgumentNullException(nameof(options));
if (IsConnectionString(nameOrConnectionString))
{
_connectionString = nameOrConnectionString;
}
else
{
throw new ArgumentException(
$"Could not find connection string with name '{nameOrConnectionString}' in application config file");
}
_connectionSetup = connectionSetup;
if (options.PrepareSchemaIfNecessary)
{
using (var connection = CreateAndOpenConnection())
{
PostgreSqlObjectsInstaller.Install(connection, options.SchemaName);
}
}
InitializeQueueProviders();
}
/// <summary>
/// Initializes PostgreSqlStorage from the provided PostgreSqlStorageOptions and either the provided connection
/// string or the connection string with provided name pulled from the application config file.
/// </summary>
/// <param name="nameOrConnectionString">Either a SQL Server connection string or the name of
/// a SQL Server connection string located in the connectionStrings node in the application config</param>
/// <param name="options"></param>
/// <exception cref="ArgumentNullException"><paramref name="nameOrConnectionString"/> argument is null.</exception>
/// <exception cref="ArgumentNullException"><paramref name="options"/> argument is null.</exception>
/// <exception cref="ArgumentException"><paramref name="nameOrConnectionString"/> argument is neither
/// a valid SQL Server connection string nor the name of a connection string in the application
/// config file.</exception>
public PostgreSqlStorage(string nameOrConnectionString, PostgreSqlStorageOptions options)
{
if (nameOrConnectionString == null)
{
throw new ArgumentNullException(nameof(nameOrConnectionString));
}
if (options == null)
{
throw new ArgumentNullException(nameof(options));
}
_options = options;
if (IsConnectionString(nameOrConnectionString))
{
_connectionString = nameOrConnectionString;
}
#if (NETSTANDARD2_0)
#else
else if (IsConnectionStringInConfiguration(nameOrConnectionString))
{
_connectionString = ConfigurationManager.ConnectionStrings[nameOrConnectionString].ConnectionString;
}
#endif
else
{
throw new ArgumentException(
$"Could not find connection string with name '{nameOrConnectionString}' in application config file");
}
if (options.PrepareSchemaIfNecessary)
{
using (var connection = CreateAndOpenConnection())
{
PostgreSqlObjectsInstaller.Install(connection, options.SchemaName);
}
}
InitializeQueueProviders();
}
/// <summary>
/// Initializes PostgreSqlStorage from the provided PostgreSqlStorageOptions and either the provided connection
/// string or the connection string with provided name pulled from the application config file.
/// </summary>
/// <param name="nameOrConnectionString">Either a SQL Server connection string or the name of
/// a SQL Server connection string located in the connectionStrings node in the application config</param>
/// <param name="options"></param>
/// <exception cref="ArgumentNullException"><paramref name="nameOrConnectionString"/> argument is null.</exception>
/// <exception cref="ArgumentNullException"><paramref name="options"/> argument is null.</exception>
/// <exception cref="ArgumentException"><paramref name="nameOrConnectionString"/> argument is neither
/// a valid SQL Server connection string nor the name of a connection string in the application
/// config file.</exception>
public PostgreSqlStorage(string nameOrConnectionString, PostgreSqlStorageOptions options)
{
if (nameOrConnectionString == null)
{
throw new ArgumentNullException("nameOrConnectionString");
}
if (options == null)
{
throw new ArgumentNullException("options");
}
_options = options;
if (IsConnectionString(nameOrConnectionString))
{
_connectionString = nameOrConnectionString;
}
else if (IsConnectionStringInConfiguration(nameOrConnectionString))
{
_connectionString = ConfigurationManager.ConnectionStrings[nameOrConnectionString].ConnectionString;
}
else
{
throw new ArgumentException(
string.Format("Could not find connection string with name '{0}' in application config file",
nameOrConnectionString));
}
if (options.PrepareSchemaIfNecessary)
{
using (var connection = CreateAndOpenConnection())
{
PostgreSqlObjectsInstaller.Install(connection);
}
}
var defaultQueueProvider = new PostgreSqlJobQueueProvider(options);
QueueProviders = new PersistentJobQueueProviderCollection(defaultQueueProvider);
}
