/// <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())); } }