public static void SetupConnection(IDbIntegrationConfigurationProperties configuration) { //configuration.Dialect<SQLiteDialect>(); //configuration.Driver<SQLite20Driver>(); configuration.Dialect <MsSql2012Dialect>(); }
protected virtual void AppendConnectionString(IDbIntegrationConfigurationProperties c, ConnectionStringValueType value) { if (value.IsName) c.ConnectionStringName = value; else c.ConnectionString = value; }
protected override void DataBaseIntegration(IDbIntegrationConfigurationProperties c) { c.Dialect<SQLiteDialect>(); c.Driver<NHibernate.Driver.SQLite20Driver>(); c.IsolationLevel = IsolationLevel.ReadCommitted; c.HqlToSqlSubstitutions = "true=1;false=0"; }
public static void Dialect(this IDbIntegrationConfigurationProperties configuration, string providerName) { configuration .GetType() .GetMethod("Dialect") .MakeGenericMethod(dialectDictionary[providerName]) .Invoke(configuration, null); }
private static void ForSQLiteInMemory(IDbIntegrationConfigurationProperties db) { db.ConnectionString = "data source=:memory:"; db.ConnectionReleaseMode = ConnectionReleaseMode.OnClose; db.Dialect<SQLiteDialect>(); db.ConnectionProvider<DriverConnectionProvider>(); db.Driver<SQLite20Driver>(); db.BatchSize = 100; }
private static void ForSQLiteInMemory(IDbIntegrationConfigurationProperties db) { db.ConnectionString = "data source=:memory:"; db.ConnectionReleaseMode = ConnectionReleaseMode.OnClose; db.Dialect <SQLiteDialect>(); db.ConnectionProvider <DriverConnectionProvider>(); db.Driver <SQLite20Driver>(); db.BatchSize = 100; }
static void Integrate(IDbIntegrationConfigurationProperties db, string connectionString) { db.Dialect <SQLiteDialect>(); db.ConnectionString = connectionString ?? "Data Source=:memory:;Version=3;New=True;Pooling=True;Max Pool Size=1;"; db.BatchSize = 100; db.IsolationLevel = IsolationLevel.Serializable; db.LogSqlInConsole = false; db.LogFormattedSql = false; db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.SchemaAction = SchemaAutoAction.Update; }
static void Integrate(IDbIntegrationConfigurationProperties db, string connectionString, bool logToConsole) { db.Dialect<SQLiteDialect>(); db.ConnectionString = connectionString ?? InMemoryConnectionString; db.BatchSize = 100; db.IsolationLevel = IsolationLevel.Serializable; db.LogSqlInConsole = logToConsole; db.LogFormattedSql = logToConsole; db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.SchemaAction = SchemaAutoAction.Update; }
static void Integrate(IDbIntegrationConfigurationProperties db, string connectionString) { db.Dialect <MsSql2008Dialect>(); db.ConnectionString = connectionString; db.BatchSize = 100; db.IsolationLevel = IsolationLevel.RepeatableRead; db.LogSqlInConsole = true; db.LogFormattedSql = true; db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.SchemaAction = SchemaAutoAction.Update; }
static void Integrate(IDbIntegrationConfigurationProperties db, string connectionString) { db.Dialect<MsSql2008Dialect>(); db.ConnectionString = connectionString; db.BatchSize = 100; db.IsolationLevel = IsolationLevel.RepeatableRead; db.LogSqlInConsole = false; db.LogFormattedSql = false; db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.SchemaAction = SchemaAutoAction.Update; }
static void Integrate(IDbIntegrationConfigurationProperties db, string connectionString, bool logToConsole) { db.Dialect <SQLiteDialect>(); db.ConnectionString = connectionString ?? InMemoryConnectionString; db.BatchSize = 100; db.IsolationLevel = IsolationLevel.Serializable; db.LogSqlInConsole = logToConsole; db.LogFormattedSql = logToConsole; db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.SchemaAction = SchemaAutoAction.Update; }
public override void GetDatabaseIntegration(IDbIntegrationConfigurationProperties dBIntegration, string connectionString) { dBIntegration.Dialect <MsSql2008Dialect>(); dBIntegration.Driver <SqlClientDriver>(); dBIntegration.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; dBIntegration.IsolationLevel = IsolationLevel.ReadCommitted; dBIntegration.ConnectionString = connectionString; dBIntegration.LogSqlInConsole = true; dBIntegration.Timeout = 10; dBIntegration.LogFormatedSql = true; dBIntegration.HqlToSqlSubstitutions = "true 1, false 0, yes 'Y', no 'N'"; }
protected virtual void SetDatabase( IDbIntegrationConfigurationProperties db, IDatabaseProvider databaseProvider, Configuration configuration) { db.Dialect(databaseProvider.ProviderName); db.ConnectionString = databaseProvider.ConnectionString; db.AutoCommentSql = true; db.IsolationLevel = System.Data.IsolationLevel.ReadCommitted; db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.PrepareCommands = true; }
public override void GetDatabaseIntegration(IDbIntegrationConfigurationProperties dBIntegration, string connectionString) { dBIntegration.Dialect<MsSql2008Dialect>(); dBIntegration.Driver<SqlClientDriver>(); dBIntegration.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; dBIntegration.IsolationLevel = IsolationLevel.ReadCommitted; dBIntegration.ConnectionString = connectionString; dBIntegration.LogSqlInConsole = true; dBIntegration.Timeout = 10; dBIntegration.LogFormatedSql = true; dBIntegration.HqlToSqlSubstitutions = "true 1, false 0, yes 'Y', no 'N'"; }
static void Integrate(IDbIntegrationConfigurationProperties db, string connectionString, short batchSize, IsolationLevel isolationLevel, bool logSql, bool updateSchema) { db.Dialect<MsSql2008Dialect>(); db.ConnectionString = connectionString; db.BatchSize = batchSize; db.IsolationLevel = isolationLevel; db.LogSqlInConsole = logSql; db.LogFormattedSql = logSql; db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.SchemaAction = updateSchema ? SchemaAutoAction.Update : SchemaAutoAction.Validate; }
static void Integrate(IDbIntegrationConfigurationProperties db, string connectionString, short batchSize, IsolationLevel isolationLevel, bool logSql, bool updateSchema) { db.Dialect <MsSql2008Dialect>(); db.ConnectionString = connectionString; db.BatchSize = batchSize; db.IsolationLevel = isolationLevel; db.LogSqlInConsole = logSql; db.LogFormattedSql = logSql; db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.SchemaAction = updateSchema ? SchemaAutoAction.Update : SchemaAutoAction.Validate; }
public static void FullDriver(this IDbIntegrationConfigurationProperties config, NhDatabaseDriver databaseType) { switch (databaseType) { case NhDatabaseDriver.MsSql2005: config.Dialect <MsSql2005Dialect>(); config.Driver <SqlClientDriver>(); config.Batcher <SqlClientBatchingBatcherFactory>(); break; case NhDatabaseDriver.MsSql2008: config.Dialect <MsSql2008Dialect>(); config.Driver <SqlClientDriver>(); config.Batcher <SqlClientBatchingBatcherFactory>(); break; case NhDatabaseDriver.MsSql2012: config.Dialect <MsSql2012Dialect>(); config.Driver <SqlClientDriver>(); config.Batcher <SqlClientBatchingBatcherFactory>(); break; case NhDatabaseDriver.Oracle10: config.Dialect <Oracle10gDialect>(); config.Driver <OracleClientDriver>(); config.Batcher <OracleDataClientBatchingBatcherFactory>(); break; case NhDatabaseDriver.MySql: config.Dialect <MySQL5Dialect>(); config.Driver <MySqlDataDriver>(); break; case NhDatabaseDriver.PostgreSql: config.Dialect <PostgreSQL82Dialect>(); config.Driver <NpgsqlDriver>(); break; case NhDatabaseDriver.Sqlite: config.Dialect <SQLiteDialect>(); config.Driver <SQLite20Driver>(); break; default: throw new ArgumentException(databaseType + " is not a valid auto-configuration database"); } }
public static void ConfigureDialectAndDriver(this IDbIntegrationConfigurationProperties db, DatabaseServerType databaseServer) { switch (databaseServer) { case DatabaseServerType.SqlServer: db.Dialect <MsSql2012Dialect>(); db.Driver <SqlClientDriver>(); break; case DatabaseServerType.PostgreSql: db.Dialect <PostgreSQL81Dialect>(); db.Driver <NpgsqlDriver>(); break; default: throw new ArgumentOutOfRangeException(nameof(databaseServer), databaseServer, null); } }
static void Integrate(IDbIntegrationConfigurationProperties db, string connectionString, bool logToConsole) { db.Dialect <SQLiteDialect>(); //This is a custom dialect db.ConnectionString = connectionString ?? InMemoryConnectionString; db.BatchSize = 100; db.IsolationLevel = IsolationLevel.Serializable; db.LogSqlInConsole = logToConsole; db.LogFormattedSql = logToConsole; db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; // Do not use this property with real DB as it will modify schema db.SchemaAction = SchemaAutoAction.Update; //Disable comments until this issue is resolved // https://groups.google.com/forum/?fromgroups=#!topic/nhusers/xJ675yG2uhY //properties.AutoCommentSql = true; }
static void Integrate(IDbIntegrationConfigurationProperties db, string connectionString) { db.Dialect<SQLiteDialect>(); db.ConnectionString = connectionString ?? "Data Source=:memory:;Version=3;New=True;Pooling=True;Max Pool Size=1;"; db.BatchSize = 100; db.IsolationLevel = IsolationLevel.Serializable; db.LogSqlInConsole = false; db.LogFormattedSql = false; db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.SchemaAction = SchemaAutoAction.Recreate; }
public abstract void GetDatabaseIntegration(IDbIntegrationConfigurationProperties dBIntegration, string connectionString);
protected abstract void DataBaseIntegration(IDbIntegrationConfigurationProperties c);
public static void FullDriver(this IDbIntegrationConfigurationProperties config, string databaseType) { config.FullDriver((NhDatabaseDriver)Enum.Parse(typeof(NhDatabaseDriver), databaseType, true)); }
public static void MySqlConnectorDriver(this IDbIntegrationConfigurationProperties cfg) => cfg.Driver <MySqlConnectorDriver>();
static void Integrate(IDbIntegrationConfigurationProperties db, string connectionString, bool logToConsole) { db.Dialect<SQLiteDialect>(); //This is a custom dialect db.ConnectionString = connectionString ?? InMemoryConnectionString; db.BatchSize = 100; db.IsolationLevel = IsolationLevel.Serializable; db.LogSqlInConsole = logToConsole; db.LogFormattedSql = logToConsole; db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; // Do not use this property with real DB as it will modify schema db.SchemaAction = SchemaAutoAction.Update; //Disable comments until this issue is resolved // https://groups.google.com/forum/?fromgroups=#!topic/nhusers/xJ675yG2uhY //properties.AutoCommentSql = true; }
private static void ConfigureForSQLServer(IDbIntegrationConfigurationProperties dbi) { dbi.ConnectionString = "Data Source=(local);Integrated Security=SSPI;Initial Catalog=ReleaseManager"; dbi.Dialect <NHibernate.Dialect.MsSql2012Dialect>(); dbi.Driver <NHibernate.Driver.Sql2008ClientDriver>(); }