static void Main(string[] args) { Console.WriteLine("Started publisher and inserting data."); Publisher.Start(); var config = new Configuration(); config.Configure("nh.sqlserver.config"); config.SessionFactoryName("Test session factory"); config.AddAssembly(typeof(Dog).Assembly); new SchemaUpdate(config).Execute(false, true); using(var sessionFactory = config.BuildSessionFactory()) { Stopwatch sw = new Stopwatch(); sw.Start(); InsertData(sessionFactory); Console.WriteLine("Inserting data with logging took: {0}", sw.Elapsed); sw.Restart(); Publisher.Shutdown(); Console.WriteLine("Publisher shutdown complete in {0}", sw.Elapsed); Console.WriteLine("inserting data with publisher shutdown"); sw.Restart(); InsertData(sessionFactory); Console.WriteLine("Inserting data without logging took: {0}", sw.Elapsed); } Console.ReadLine(); }
private Configuration InitConfiguration() { var configuration = new Configuration(); configuration.SessionFactoryName(typeof(NHibernateConfigurer).Assembly.GetName(). FullName); configuration.DataBaseIntegration(dicp => { dicp.ConnectionProvider <DriverConnectionProvider>(); dicp.Dialect <MsSql2008Dialect>(); dicp.Driver <Sql2008ClientDriver>(); dicp.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; dicp.IsolationLevel = IsolationLevel.ReadCommitted; dicp.ConnectionString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; dicp.Timeout = 10; dicp.BatchSize = 20; if (ShowLogs) { dicp.LogFormattedSql = true; dicp.LogSqlInConsole = true; dicp.AutoCommentSql = false; } }); return(configuration); }
public Configuration BuildConfiguration(string connectionString, string sessionFactoryName) { Contract.Requires(!string.IsNullOrEmpty(connectionString), "ConnectionString is null or empty"); Contract.Requires(!string.IsNullOrEmpty(sessionFactoryName), "SessionFactory name is null or empty"); Contract.Requires(!string.IsNullOrEmpty(_databaseSchema), "Database Schema is null or empty"); Contract.Requires(_configurator != null, "Configurator is null"); return CatchExceptionHelper.TryCatchFunction( () => { DomainTypes = GetTypeOfEntities(_assemblies); if (DomainTypes == null) throw new Exception("Type of domains is null"); var configure = new Configuration(); configure.SessionFactoryName(sessionFactoryName); configure.Proxy(p => p.ProxyFactoryFactory<ProxyFactoryFactory>()); configure.DataBaseIntegration(db => GetDatabaseIntegration(db, connectionString)); if (_configurator.GetAppSettingString("IsCreateNewDatabase").ConvertToBoolean()) { configure.SetProperty("hbm2ddl.auto", "create-drop"); } configure.Properties.Add("default_schema", _databaseSchema); configure.AddDeserializedMapping(GetMapping(), _configurator.GetAppSettingString("DocumentFileName")); SchemaMetadataUpdater.QuoteTableAndColumns(configure); return configure; }, Logger); }
private static Configuration ConfigureNHibernate() { var configure = new Configuration(); configure.SessionFactoryName("BuildIt"); configure.DataBaseIntegration(db => { db.Dialect <MsSql2008Dialect>(); db.Driver <Sql2008ClientDriver>(); db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.IsolationLevel = IsolationLevel.ReadCommitted; db.ConnectionStringName = "TestDB"; db.Timeout = 10; // enabled for testing db.LogFormattedSql = true; db.LogSqlInConsole = true; db.AutoCommentSql = true; }); var mapping = GetMappings(); configure.AddDeserializedMapping(mapping, "NHSchemaTest"); SchemaMetadataUpdater.QuoteTableAndColumns(configure); return(configure); }
static Configuration ConfigureNHibernate() { var configure = new Configuration(); configure.SessionFactoryName("HemArkivAccess"); configure.DataBaseIntegration(db => { db.Dialect<NHibernate.JetDriver.JetDialect>(); db.Driver<NHibernate.JetDriver.JetDriver>(); db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.ConnectionStringName = "HemArkivAccess"; db.Timeout = 10; // enabled for testing db.LogFormattedSql = true; db.LogSqlInConsole = false; db.AutoCommentSql = false; db.Timeout = 10; //db.ConnectionProvider<NHibernate.Connection.DriverConnectionProvider>(); }); var mapping = GetMappings(); configure.AddDeserializedMapping(mapping, "HemArkivAccess"); return configure; }
/// <summary> /// Configure NHibernate /// </summary> private static Configuration ConfigureNHibernate() { Configuration configure = new Configuration(); configure.SessionFactoryName("SessionFactory"); configure.DataBaseIntegration(db => { db.Dialect<MsSql2008Dialect>(); db.Driver<SqlClientDriver>(); db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.IsolationLevel = IsolationLevel.ReadCommitted; db.ConnectionStringName = RegtestingServerConfiguration.DefaultConnectionString; //db.Timeout = 10; //For testing //db.LogFormattedSql = true; //db.LogSqlInConsole = true; //db.AutoCommentSql = true; }); HbmMapping hbmMapping = GetMappings(); configure.AddDeserializedMapping(hbmMapping,"NHMapping"); SchemaMetadataUpdater.QuoteTableAndColumns(configure); return configure; }
/// <summary> /// Creates session factory /// </summary> /// <param name="configurationReader">configuration reader</param> /// <returns></returns> private static ISessionFactory CreateSessionFactory(IConfigurationReader configurationReader) { var configuration = new NHibernate.Cfg.Configuration(); configuration.SessionFactoryName("Jumblocks Blog"); configuration.DataBaseIntegration(db => { db.Dialect<MsSql2008FixedDialect>(); db.IsolationLevel = IsolationLevel.ReadCommitted; db.ConnectionString = configurationReader.ConnectionStrings["BlogDb"].ConnectionString; db.BatchSize = 100; //for testing db.LogFormattedSql = true; db.LogSqlInConsole = true; db.AutoCommentSql = true; }); var mapper = new ModelMapper(); mapper.AddMapping<BlogPostMap>(); mapper.AddMapping<BlogUserMap>(); mapper.AddMapping<ImageReferenceMap>(); mapper.AddMapping<TagMap>(); mapper.AddMapping<SeriesMap>(); mapper.AddMapping<UserMap>(); mapper.AddMapping<RoleMap>(); mapper.AddMapping<OperationMap>(); configuration.AddMapping(mapper.CompileMappingForAllExplicitlyAddedEntities()); configuration.CurrentSessionContext<WebSessionContext>(); return configuration.BuildSessionFactory(); }
public static Configuration ConfigureNHibernate() { var configure = new Configuration(); configure.SessionFactoryName("Demo"); configure.Proxy(p => p.ProxyFactoryFactory<ProxyFactoryFactory>()); configure.DataBaseIntegration(db => { db.Dialect<MsSql2008Dialect>(); db.Driver<SqlClientDriver>(); db.ConnectionString = ConnectionString; db.LogSqlInConsole = true;//用于显示输出SQL }); return configure; }
public static Configuration GetConfiguration() { var configure = new Configuration(); configure.SessionFactoryName("NHibernateDB"); //Proxy扩展方法用于配置NHibernate延迟加载的字节码提供程序 configure.Proxy(p => p.ProxyFactoryFactory<ProxyFactoryFactory>()); configure.DataBaseIntegration(db => { db.Dialect<MsSql2005Dialect>(); db.Driver<SqlClientDriver>(); db.ConnectionString = _ConnectionString; }); return configure; }
private static Configuration BuildConfiguration() { Configuration cfg = new Configuration(); cfg.SessionFactoryName("Sample.ReadModel"); cfg.DataBaseIntegration(db => { db.Dialect<NHibernate.Dialect.MsSql2008Dialect>(); db.Driver<NHibernate.Driver.SqlClientDriver>(); db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ReadModel"].ConnectionString; db.AutoCommentSql = true; db.LogSqlInConsole = false; db.LogFormatedSql = true; db.HqlToSqlSubstitutions = "true 1, false 0, yes 'Y', no 'N'"; }); cfg.AddAssembly(typeof(NHibernateMappings).Assembly); return cfg; }
public Configuration ConfigureNHibernate() { var configure = new Configuration(); configure.SessionFactoryName("Demo"); configure.Proxy(p => { p.Validation = false; p.ProxyFactoryFactory<ProxyFactoryFactory>(); }); configure.DataBaseIntegration(db => { db.Dialect<MsSql2008Dialect>(); db.Driver<SqlClientDriver>(); db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.IsolationLevel = IsolationLevel.ReadCommitted; db.ConnectionString = ConnectionString; db.Timeout = 10; db.HqlToSqlSubstitutions = "true 1, false 0, yes 'Y', no 'N'"; }); return configure; }
private static Configuration GetConfig() { var configure = new Configuration(); configure.SessionFactoryName("SessionFactory_dicenfa"); configure.DataBaseIntegration( db => { db.ConnectionProvider <DriverConnectionProvider>(); db.Dialect <SQLiteDialect>(); db.Driver <SQLite20Driver>(); db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.IsolationLevel = IsolationLevel.ReadCommitted; db.ConnectionString = ConfigurationManager.ConnectionStrings["dicenfaConnectionString"].ConnectionString; db.Timeout = 15; ////for testing ... //db.LogFormattedSql = true; //db.LogSqlInConsole = true; }); return(configure); }
public static NHibernate.Cfg.Configuration ConfigureNhibernate() { var configure = new NHibernate.Cfg.Configuration(); configure.SessionFactoryName("BuildIt"); configure.DataBaseIntegration(db => { //*** SQL 2012 Express db.Dialect<MsSql2012Dialect>(); db.Driver<SqlClientDriver>(); db.ConnectionString = "Data Source=.\\sqlexpress2012;Initial Catalog=Dig;Integrated Security=True;Application Name=DigDb;"; //db.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["digdb"].ConnectionString; db.Timeout = 10; //*** Testing Settings db.LogFormattedSql = true; db.LogSqlInConsole = true; db.AutoCommentSql = true; }); return configure; }
public static Configuration BuildConfiguration(string connectionString) { var configure = new Configuration(); configure.SessionFactoryName("SessionFactoryName"); configure.DataBaseIntegration(db => { db.Dialect<MsSql2008Dialect>(); db.Driver<SqlClientDriver>(); db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.IsolationLevel = IsolationLevel.ReadCommitted; db.ConnectionString = connectionString; db.Timeout = 10; db.LogFormattedSql = true; db.LogSqlInConsole = true; db.AutoCommentSql = true; }); InitMappings(configure); GenerateSchema(configure); return configure; }
public static void NHibernateConfigurationInBuild(TestContext context) { log4net.Config.XmlConfigurator.Configure(); Configuration cfg = new Configuration(); cfg.SessionFactoryName("BuildIt"); cfg.DataBaseIntegration(db => { db.LogSqlInConsole = true; db.ConnectionString = @"Server=localhost;initial catalog=nhibernate;User Id=sa;Password=masterkey;"; db.Driver<SqlClientDriver>(); db.Dialect<MsSql2012Dialect>(); }); var mapper = new ModelMapper(); mapper.AddMappings(Assembly.GetExecutingAssembly().GetExportedTypes()); cfg.AddMapping(mapper.CompileMappingForAllExplicitlyAddedEntities()); cfg.AddAssembly(Assembly.GetExecutingAssembly()); SessionFactory = cfg.BuildSessionFactory(); }
public void FullConfiguration() { var configure = new Configuration(); configure.SessionFactoryName("SomeName"); configure.Cache(c => { c.UseMinimalPuts = true; c.DefaultExpiration = 15; c.RegionsPrefix = "xyz"; c.Provider<HashtableCacheProvider>(); c.QueryCache<StandardQueryCache>(); }); configure.CollectionTypeFactory<DefaultCollectionTypeFactory>(); configure.HqlQueryTranslator<ClassicQueryTranslatorFactory>(); configure.LinqToHqlGeneratorsRegistry<DefaultLinqToHqlGeneratorsRegistry>(); configure.Proxy(p => { p.Validation = false; p.ProxyFactoryFactory<DefaultProxyFactoryFactory>(); }); configure.Mappings(m=> { m.DefaultCatalog = "MyCatalog"; m.DefaultSchema = "MySche"; }); configure.DataBaseIntegration(db => { db.Dialect<MsSql2000Dialect>(); db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.Batcher<SqlClientBatchingBatcherFactory>(); db.BatchSize = 15; db.ConnectionProvider<DebugConnectionProvider>(); db.Driver<SqlClientDriver>(); db.ConnectionReleaseMode = ConnectionReleaseMode.AfterTransaction; db.IsolationLevel = IsolationLevel.ReadCommitted; db.ConnectionString = "The connection string"; db.AutoCommentSql = true; db.ExceptionConverter<SQLStateConverter>(); db.PrepareCommands = true; db.Timeout = 10; db.MaximumDepthOfOuterJoinFetching = 11; db.HqlToSqlSubstitutions = "true 1, false 0, yes 'Y', no 'N'"; db.SchemaAction = SchemaAutoAction.Validate; }); Assert.That(configure.Properties[Environment.SessionFactoryName], Is.EqualTo("SomeName")); Assert.That(configure.Properties[Environment.CacheProvider], Is.EqualTo(typeof(HashtableCacheProvider).AssemblyQualifiedName)); Assert.That(configure.Properties[Environment.CacheRegionPrefix], Is.EqualTo("xyz")); Assert.That(configure.Properties[Environment.QueryCacheFactory], Is.EqualTo(typeof(StandardQueryCache).AssemblyQualifiedName)); Assert.That(configure.Properties[Environment.UseMinimalPuts], Is.EqualTo("true")); Assert.That(configure.Properties[Environment.CacheDefaultExpiration], Is.EqualTo("15")); Assert.That(configure.Properties[Environment.CollectionTypeFactoryClass], Is.EqualTo(typeof(DefaultCollectionTypeFactory).AssemblyQualifiedName)); Assert.That(configure.Properties[Environment.UseProxyValidator], Is.EqualTo("false")); Assert.That(configure.Properties[Environment.ProxyFactoryFactoryClass], Is.EqualTo(typeof(DefaultProxyFactoryFactory).AssemblyQualifiedName)); Assert.That(configure.Properties[Environment.QueryTranslator], Is.EqualTo(typeof(ClassicQueryTranslatorFactory).AssemblyQualifiedName)); Assert.That(configure.Properties[Environment.DefaultCatalog], Is.EqualTo("MyCatalog")); Assert.That(configure.Properties[Environment.DefaultSchema], Is.EqualTo("MySche")); Assert.That(configure.Properties[Environment.Dialect], Is.EqualTo(typeof(MsSql2000Dialect).AssemblyQualifiedName)); Assert.That(configure.Properties[Environment.Hbm2ddlKeyWords], Is.EqualTo("auto-quote")); Assert.That(configure.Properties[Environment.BatchStrategy], Is.EqualTo(typeof(SqlClientBatchingBatcherFactory).AssemblyQualifiedName)); Assert.That(configure.Properties[Environment.BatchSize], Is.EqualTo("15")); Assert.That(configure.Properties[Environment.ConnectionProvider], Is.EqualTo(typeof(DebugConnectionProvider).AssemblyQualifiedName)); Assert.That(configure.Properties[Environment.ConnectionDriver], Is.EqualTo(typeof(SqlClientDriver).AssemblyQualifiedName)); Assert.That(configure.Properties[Environment.ReleaseConnections], Is.EqualTo(ConnectionReleaseModeParser.ToString(ConnectionReleaseMode.AfterTransaction))); Assert.That(configure.Properties[Environment.Isolation], Is.EqualTo("ReadCommitted")); Assert.That(configure.Properties[Environment.ConnectionString], Is.EqualTo("The connection string")); Assert.That(configure.Properties[Environment.UseSqlComments], Is.EqualTo("true")); Assert.That(configure.Properties[Environment.SqlExceptionConverter], Is.EqualTo(typeof(SQLStateConverter).AssemblyQualifiedName)); Assert.That(configure.Properties[Environment.PrepareSql], Is.EqualTo("true")); Assert.That(configure.Properties[Environment.CommandTimeout], Is.EqualTo("10")); Assert.That(configure.Properties[Environment.MaxFetchDepth], Is.EqualTo("11")); Assert.That(configure.Properties[Environment.QuerySubstitutions], Is.EqualTo("true 1, false 0, yes 'Y', no 'N'")); Assert.That(configure.Properties[Environment.Hbm2ddlAuto], Is.EqualTo("validate")); configure.Properties[Environment.LinqToHqlGeneratorsRegistry].Should().Be(typeof(DefaultLinqToHqlGeneratorsRegistry).AssemblyQualifiedName); }
/// <summary> /// Configuration nhibernate and data base /// </summary> /// <returns></returns> private Configuration ConfigureNHibernate() { var configure = new Configuration(); configure.SessionFactoryName("SQL"); configure.DataBaseIntegration(db => { db.Dialect<MsSql2012Dialect>(); db.Driver<NHibernate.Driver.SqlClientDriver>(); db.ConnectionString = this.ConnectionString.ConnectionString; db.Timeout = 10; db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.IsolationLevel = System.Data.IsolationLevel.ReadCommitted; }); return configure; }
public void Initialize() { configure = new Configuration(); configure.SessionFactoryName("Demo"); configure.Proxy(p => { p.ProxyFactoryFactory<ProxyFactoryFactory>(); }); configure.DataBaseIntegration(db => { db.Dialect<MsSql2008Dialect>(); db.Driver<SqlClientDriver>(); db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.IsolationLevel = IsolationLevel.ReadCommitted; db.ConnectionString = ConnectionString; db.BatchSize = 20; db.Timeout = 10; db.HqlToSqlSubstitutions = "true 1, false 0, yes 'Y', no 'N'"; }); Map(); }
private Configuration initConfiguration() { var configure = new Configuration(); configure.SessionFactoryName("BuildIt"); configure.DataBaseIntegration(db => { db.ConnectionProvider<DriverConnectionProvider>(); db.Dialect<MsSql2008Dialect>(); db.Driver<Sql2008ClientDriver>(); db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote; db.IsolationLevel = IsolationLevel.ReadCommitted; db.ConnectionString = ConnectionString; db.Timeout = 10; db.BatchSize = 20; if (ShowLogs) { db.LogFormattedSql = true; db.LogSqlInConsole = true; db.AutoCommentSql = false; } }); configure.SetProperty(NHibernate.Cfg.Environment.ConnectionDriver, typeof(ProfiledSql2008ClientDriver).AssemblyQualifiedName); return configure; }
// public class Order // { // public int Id { get; set; } // public Customer Customer { get; set; } // } static void InitializeNHibernate() { NHibernateProfiler.Initialize(); cfg = new Configuration(); cfg.DataBaseIntegration(x => { x.ConnectionStringName = "adventureworks"; x.Driver<SqlClientDriver>(); x.Dialect<MsSql2008Dialect>(); x.IsolationLevel = IsolationLevel.ReadCommitted; x.Timeout = 10; }); cfg.SessionFactoryName("AdventureWorks"); cfg.Cache(x => { x.Provider<HashtableCacheProvider>(); x.UseQueryCache = true; }); cfg.SessionFactory().GenerateStatistics(); cfg.AddAssembly(typeof (Customer).Assembly); }