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;
}
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 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 abstract void GetDatabaseIntegration(IDbIntegrationConfigurationProperties dBIntegration, string connectionString);
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>();
}
