/// <summary>
/// Initialize Oracle connection using Oracle10 client configuration and using Oracle.DataAccess.dll to connect to database
/// </summary>
/// <param name="configuration">The fluentNHibernate configuration.</param>
/// <param name="configSectionName">Configuration section name in App.config or Web.config file</param>
/// <param name="additionalClientConfiguration">The additional client configuration.</param>
/// <returns></returns>
/// <exception cref="ArgumentNullException"></exception>
public static FluentConfiguration InitializeFromConfigOracleOdpNetNative(this FluentConfiguration configuration,
string configSectionName = "DatabaseConnectionSettings",
Action <OracleDataClientConfiguration> additionalClientConfiguration = null)
{
if (configuration == null)
{
throw new ArgumentNullException(nameof(configuration));
}
var settings = new DbConnectionSettings(configSectionName);
var clientConfiguration = OracleDataClientConfiguration.Oracle10.ConnectionString(c => c
.Server(settings.ServerName)
.Port(settings.Port ?? 1521)
.Instance(settings.DataBaseName)
.Username(settings.UserName)
.Password(settings.UserPassword))
.Driver <OracleDataClientDriverFix>();
additionalClientConfiguration?.Invoke(clientConfiguration);
configuration.Database(clientConfiguration);
configuration.ExposeConfiguration(c => c.Properties.Add("hbm2ddl.keywords", "none"));
if (settings.ShowSql)
{
configuration.ExposeConfiguration(x => x.SetInterceptor(new SqlStatementInterceptor()));
}
return(configuration);
}
/// <summary>
/// Initialize PostgreSQL connection using PostgreSQL82 client configuration
/// </summary>
/// <param name="configuration">The fluentNHibernate configuration.</param>
/// <param name="configSectionName">Configuration section name in App.config or Web.config file</param>
/// <param name="additionalClientConfiguration">The additional client configuration.</param>
/// <returns></returns>
/// <exception cref="ArgumentNullException"></exception>
public static FluentConfiguration InitializeFromConfigPostgreSql(this FluentConfiguration configuration,
string configSectionName = "DatabaseConnectionSettings",
Action <PostgreSQLConfiguration> additionalClientConfiguration = null)
{
if (configuration == null)
{
throw new ArgumentNullException(nameof(configuration));
}
var settings = new DbConnectionSettings(configSectionName);
var clientConfiguration = PostgreSQLConfiguration.PostgreSQL82.ConnectionString(c => c
.Host(settings.ServerName)
.Port(settings.Port ?? 5432)
.Database(settings.DataBaseName)
.Username(settings.UserName)
.Password(settings.UserPassword));
additionalClientConfiguration?.Invoke(clientConfiguration);
configuration.Database(clientConfiguration);
configuration.ExposeConfiguration(c => c.Properties.Add("hbm2ddl.keywords", "none"));
if (settings.ShowSql)
{
configuration.ExposeConfiguration(x => x.SetInterceptor(new SqlStatementInterceptor()));
}
return(configuration);
}
private static void InitializeFromConfigMsSql(FluentConfiguration fluentConfiguration,
DbConnectionSettings settings,
Action <MsSqlConfiguration>?additionalClientConfiguration = null)
{
var clientConfiguration = MsSqlConfiguration.MsSql2008.ConnectionString(c => c
.Server(settings.ServerName)
.Database(settings.DataBaseName)
.Username(settings.UserName)
.Password(settings.UserPassword ?? throw new ArgumentNullException(nameof(settings.UserPassword))));
additionalClientConfiguration?.Invoke(clientConfiguration);
fluentConfiguration.Database(clientConfiguration);
PerformCommonInitialization(fluentConfiguration, settings.ShowSql);
}
private static void InitializeFromConfigMySql(FluentConfiguration fluentConfiguration,
DbConnectionSettings settings,
Action <MySQLConfiguration>?additionalClientConfiguration = null)
{
var clientConfiguration = MySQLConfiguration.Standard.ConnectionString(c => c
.Server(settings.ServerName)
.Database(settings.DataBaseName)
.Username(settings.UserName)
.Password(settings.UserPassword));
additionalClientConfiguration?.Invoke(clientConfiguration);
fluentConfiguration.Database(clientConfiguration);
PerformCommonInitialization(fluentConfiguration, settings.ShowSql);
}
private static void InitializeFromConfigOracleClient(FluentConfiguration fluentConfiguration,
DbConnectionSettings settings,
Action <OracleDataClientConfiguration>?additionalClientConfiguration = null)
{
var clientConfiguration = OracleDataClientConfiguration.Oracle10.ConnectionString(c =>
c.Server(settings.ServerName)
.Port(settings.Port ?? 1521)
.Instance(settings.DataBaseName)
.Username(settings.UserName)
.Password(settings.UserPassword));
additionalClientConfiguration?.Invoke(clientConfiguration);
fluentConfiguration.Database(clientConfiguration);
PerformCommonInitialization(fluentConfiguration, settings.ShowSql);
}
private static void InitializeFromConfigPostgreSql(FluentConfiguration fluentConfiguration,
DbConnectionSettings settings,
Action <PostgreSQLConfiguration>?additionalClientConfiguration = null)
{
var clientConfiguration = PostgreSQLConfiguration.PostgreSQL82.ConnectionString(c => c
.Host(settings.ServerName)
.Port(settings.Port ?? 5432)
.Database(settings.DataBaseName)
.Username(settings.UserName)
.Password(settings.UserPassword));
additionalClientConfiguration?.Invoke(clientConfiguration);
fluentConfiguration.Database(clientConfiguration);
PerformCommonInitialization(fluentConfiguration, settings.ShowSql);
}
/// <summary>
/// Initialize PostgreSQL connection using PostgreSQL82 client configuration
/// </summary>
/// <param name="configuration">The fluentNHibernate configuration.</param>
/// <param name="configSectionName">Configuration section name in App.config or Web.config file</param>
public static void InitializeFromConfigPostgreSql(this FluentConfiguration configuration, string configSectionName = "DatabaseConnectionSettings")
{
if (configuration == null)
{
throw new ArgumentNullException("configuration");
}
var settings = new DbConnectionSettings(configSectionName);
configuration.Database(PostgreSQLConfiguration.PostgreSQL82.ConnectionString(c => c
.Host(settings.ServerName)
.Database(settings.DataBaseName)
.Username(settings.UserName)
.Password(settings.UserPassword)));
configuration.ExposeConfiguration(c => c.Properties.Add("hbm2ddl.keywords", "none"));
if (settings.ShowSql)
{
configuration.ExposeConfiguration(x => x.SetInterceptor(new SqlStatementInterceptor()));
}
}
/// <summary>
/// Initialize Oracle connection using Oracle10 client configuration and using Oracle.ManagedDataAccess.dll to connect to database
/// </summary>
/// <param name="configuration">The fluentNHibernate configuration.</param>
/// <param name="configSectionName">Configuration section name in App.config or Web.config file</param>
public static void InitializeFromConfigOracleOdpNet(this FluentConfiguration configuration, string configSectionName = "DatabaseConnectionSettings")
{
if (configuration == null)
{
throw new ArgumentNullException("configuration");
}
var settings = new DbConnectionSettings(configSectionName);
configuration.Database(OracleClientConfiguration.Oracle10.ConnectionString(c => c
.Server(settings.ServerName)
.Port(1521)
.Instance(settings.DataBaseName)
.Username(settings.UserName)
.Password(settings.UserPassword))
.Driver <OracleManagedDataClientDriver>());
configuration.ExposeConfiguration(c => c.Properties.Add("hbm2ddl.keywords", "none"));
if (settings.ShowSql)
{
configuration.ExposeConfiguration(x => x.SetInterceptor(new SqlStatementInterceptor()));
}
}