private static IConfigurationSource GetConfigurationSource(string ConnectionString = null) { //read from the app config file if //no connection string specified if (string.IsNullOrEmpty(ConnectionString)) { return(ConfigurationManager.GetSection(ACTIVE_RECORD_SECTION_NAME) as IConfigurationSource); } //use inplace config for active record //to create a connection string var properties = new Dictionary <string, string> { { "connection.driver_class", "NHibernate.Driver.SqlClientDriver" }, { "dialect", "NHibernate.Dialect.MsSql2000Dialect" }, { "connection.provider", "NHibernate.Connection.DriverConnectionProvider" }, { "connection.connection_string", ConnectionString } }; var source = new InPlaceConfigurationSource(); source.Add(typeof(ActiveRecordBase), properties); return(source); }
public override bool Execute() { AppDomain.CurrentDomain.AssemblyResolve += CurrentDomain_AssemblyResolve; AppDomain.CurrentDomain.TypeResolve += CurrentDomain_AssemblyResolve; try { InPlaceConfigurationSource src = new InPlaceConfigurationSource(); IDictionary <string, string> cfg = new Dictionary <string, string>(); cfg[Environment.Dialect] = dialect; cfg[Environment.ConnectionDriver] = driver; cfg[Environment.ConnectionString] = connectionString; src.PluralizeTableNames = PloralizeTableNames; src.Add(typeof(ActiveRecordBase), cfg); List <Assembly> loadedAssemblies = new List <Assembly>(); foreach (ITaskItem assembly in assemblies) { Assembly asm = Assembly.LoadFrom(assembly.ItemSpec); loadedAssemblies.Add(asm); } ActiveRecordStarter.ResetInitializationFlag(); ActiveRecordStarter.Initialize(loadedAssemblies.ToArray(), src); Configuration configuration = ActiveRecordMediator.GetSessionFactoryHolder().GetConfiguration(typeof(ActiveRecordBase)); new SchemaExport(configuration).Execute(true, true, false); } finally { AppDomain.CurrentDomain.AssemblyResolve -= CurrentDomain_AssemblyResolve; AppDomain.CurrentDomain.TypeResolve -= CurrentDomain_AssemblyResolve; } return(true); }
public static void InitConnection(SCommon.SUtil.SConstants.S_DbType type, string connection_string, Assembly assembly) { switch (type) { case SCommon.SUtil.SConstants.S_DbType.MSSQL: break; case SCommon.SUtil.SConstants.S_DbType.MySQL: InPlaceConfigurationSource source = new InPlaceConfigurationSource(); IDictionary <string, string> properties = new Dictionary <string, string>(); properties.Add("connection.provider", "NHibernate.Connection.DriverConnectionProvider"); properties.Add("proxyfactory.factory_class", "NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle"); properties.Add("connection.driver_class", "NHibernate.Driver.MySqlDataDriver"); properties.Add("dialect", "NHibernate.Dialect.MySQLDialect"); properties.Add("connection.connection_string", connection_string); // 数据库连接配置 source.Add(typeof(ActiveRecordBase), properties); // 载入程序集中所有 ActiveRecord 类。 ActiveRecordStarter.Initialize(assembly, source); // 自主载入指定类型 //ActiveRecordStarter.Initialize(source, typeof(ActiveRecordBase), typeof(User), typeof(Base)); // 删除数据库架构 //ActiveRecordStarter.DropSchema(); // 创建数据库架构(该方法会删除同名表后再创建) //ActiveRecordStarter.CreateSchema(); break; } }
public static void StartDatabase() { if (Utilities.ConfigurationManager.GetStringValue("SQLUsername") == "root") { Utilities.ConsoleStyle.Warning(@"'root' Username is not safe, please modify this for your security"); } var config = new DatabaseConfiguration(DatabaseType.MySQL, Utilities.ConfigurationManager.GetStringValue("SQLHost"), Utilities.ConfigurationManager.GetStringValue("SQLDB"), Utilities.ConfigurationManager.GetStringValue("SQLUsername"), Utilities.ConfigurationManager.GetStringValue("SQLPassword")); var source = new InPlaceConfigurationSource(); source.Add(typeof(ActiveRecordBase), config.GetProperties()); ActiveRecordStarter.Initialize(source, typeof(CharacterRecord), typeof(MapRecords), typeof(TriggerRecord), typeof(ItemRecord), typeof(WorldItemRecord), typeof(NpcRecord), typeof(NpcPositionRecord), typeof(NpcDialogRecord), typeof(ZaapRecord), typeof(AccountDataRecord), typeof(OriginalBreedStartMapRecord), typeof(IncarnamTeleportRecord), typeof(ExpFloorRecord), typeof(BaseSpellRecord), typeof(MonstersTemplateRecord), typeof(MonsterLevelRecord), typeof(MountTemplateRecord), typeof(GuildCreatorLocationRecord), typeof(SpellRecord), typeof(ShopItemRecord), typeof(BreedRecord), typeof(GuildRecord), typeof(DungeonRoomRecord), typeof(WorldMountRecord), typeof(PaddockRecord), typeof(DropRecord), typeof(BannedAccountRecord), typeof(ElitesRecord), typeof(LiveActionRecord), typeof(HotelRecord), typeof(ServerInfoRecord), typeof(ItemSetRecord), typeof(IODataRecord), typeof(JobDataRecord), typeof(CraftRecord), typeof(ItemBagRecord), typeof(AuctionHouseRecord), typeof(AuctionHouseItemRecord)); }
/// <summary> /// Initialize Active Record, and initialize the container. /// If <paramref name="rhinoContainerConfig"/> is <see langword="null" /> or <see cref="string.Empty">string.Empty</see> /// a <see cref="RhinoContainer">RhinoContainer</see> will not be initialized. /// </summary> /// <param name="rhinoContainerConfig">The configuration file to initialize a <see cref="RhinoContainer">RhinoContainer</see> /// or <see langword="null" />.</param> /// <param name="cfg">The configuration to supply to AR</param> /// <param name="assemblies">The assemblies to load for NHibernate mapping files.</param> public void FixtureInitialize(string rhinoContainerConfig, InPlaceConfigurationSource cfg, params Assembly[] assemblies) { if (cfg == null) { throw new ArgumentNullException("cfg"); } IoC.Reset(); ActiveRecordStarter.ResetInitializationFlag(); cfg.Add(typeof(ActiveRecordBase), CreateProperties()); //here we either configure the IUnitOfWorkFactory appropriately (which calls ActiveRecordStarter) //or we configure ActiveRecordStarter ourselves if (!string.IsNullOrEmpty(rhinoContainerConfig)) { if (!IoC.IsInitialized) { IoC.Initialize(new RhinoContainer(rhinoContainerConfig)); } IHandler unitOfWorkFactoryHandler = IoC.Container.Kernel .GetHandler(typeof(IUnitOfWorkFactory)); unitOfWorkFactoryHandler .AddCustomDependencyValue("configurationSource", cfg); unitOfWorkFactoryHandler .AddCustomDependencyValue("assemblies", assemblies); IoC.Resolve <IUnitOfWorkFactory>().Init(); } else { ActiveRecordStarter.Initialize(assemblies, cfg); } }
public void InitDB(string FileDB) { ActiveRecordStarter.ResetInitializationFlag(); IDictionary <string, string> properties = new Dictionary <string, string> { { "connection.driver_class", "NHibernate.Driver.SQLite20Driver" }, { "dialect", "NHibernate.Dialect.SQLiteDialect" }, { "connection.provider", "NHibernate.Connection.DriverConnectionProvider" }, { "connection.connection_string", "Data Source=" + FileDB + ";locked=true" }, { "proxyfactory.factory_class", @"NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle" } }; try { InPlaceConfigurationSource source = new InPlaceConfigurationSource(); source.Add(typeof(ActiveRecordBase), properties); ActiveRecordStarter.Initialize(source, TestRequest_DBHelper.GetTypes()); } catch (Exception e1) { MessageBox.Show(e1.ToString()); } }
public void Initialize( ) { var source = new InPlaceConfigurationSource( ); source.Add(typeof(ActiveRecordBase), this.Properties); ActiveRecordStarter.Initialize(GetDataAccessAssemblies( ), source); }
public static void StartDatabase() { var config = new DatabaseConfiguration(DatabaseType.MySQL, Utilities.ConfigurationManager.GetStringValue("SQLHost"), Utilities.ConfigurationManager.GetStringValue("SQLDB"), Utilities.ConfigurationManager.GetStringValue("SQLUsername"), Utilities.ConfigurationManager.GetStringValue("SQLPassword")); var source = new InPlaceConfigurationSource(); source.Add(typeof(ActiveRecordBase), config.GetProperties()); ActiveRecordStarter.Initialize(source, typeof(AccountRecord), typeof(GameServerRecord), typeof(AccountCharactersInformationsRecord)); }
/// <summary> /// Opens the file. /// </summary> private void OpenFile() { bool createSchema = false; if (!File.Exists(Filename)) { createSchema = true; SqlCeEngine engine = new SqlCeEngine(SqlCE.GetConnectionString(Filename)); engine.CreateDatabase(); engine.Dispose(); } if (!SqlCeTicketDataSource.ActiveRecordsInitialized) { IDictionary <string, string> properties = new Dictionary <string, string>(); properties.Add("connection.driver_class", "NHibernate.Driver.SqlServerCeDriver"); properties.Add("dialect", "NHibernate.Dialect.MsSqlCeDialect"); properties.Add("connection.provider", "NHibernate.Connection.DriverConnectionProvider"); properties.Add("connection.connection_string", SqlCE.GetConnectionString(Filename)); properties.Add("proxyfactory.factory_class", "NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle"); InPlaceConfigurationSource source = new InPlaceConfigurationSource(); source.Add(typeof(ActiveRecordBase), properties); ActiveRecordStarter.Initialize(Assembly.GetExecutingAssembly(), source); SqlCeTicketDataSource.ActiveRecordsInitialized = true; } else { SqlCeConnection con = new SqlCeConnection(SqlCE.GetConnectionString(Filename)); con.Open(); DifferentDatabaseScope scope = new DifferentDatabaseScope(con); } if (createSchema) { ActiveRecordStarter.CreateSchema(); } AllTickets = new ObservableCollection <ITicket>(); IQueryable <ITicket> list = (from t in TicketRecord.Queryable select t).Cast <ITicket>(); list.ToList().ForEach((Action <ITicket>) delegate(ITicket t) { t.PropertyChanged += new PropertyChangedEventHandler(ticket_PropertyChanged); AllTickets.Add(t); }); AllTickets.CollectionChanged += new NotifyCollectionChangedEventHandler(Tickets_CollectionChanged); UpdateActiveTickets(); }
public static InPlaceConfigurationSource GetConfigSource() { Hashtable properties = new Hashtable(); properties.Add("hibernate.connection.driver_class", "NHibernate.Driver.NpgsqlDriver"); properties.Add("hibernate.dialect", "NHibernate.Dialect.PostgreSQLDialect"); properties.Add("hibernate.connection.provider", "NHibernate.Connection.DriverConnectionProvider"); properties.Add("hibernate.connection.connection_string", ConfigurationManager.ConnectionStrings[GetServidor()].ConnectionString); InPlaceConfigurationSource source = new InPlaceConfigurationSource(); source.Add(typeof(ActiveRecordBase), properties); return(source); }
private InPlaceConfigurationSource _GetConfigSource() { Dictionary <string, string> properties = new Dictionary <string, string>(); properties.Add("connection.driver_class", "NHibernate.Driver.NpgsqlDriver"); properties.Add("dialect", "NHibernate.Dialect.PostgreSQLDialect"); properties.Add("connection.provider", "NHibernate.Connection.DriverConnectionProvider"); properties.Add("proxyfactory.factory_class", "NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle"); properties.Add("show_sql", _ShowSql.ToString()); properties.Add("connection.connection_string", _ConnectionString); InPlaceConfigurationSource source = new InPlaceConfigurationSource(); source.Add(typeof(ActiveRecordBase), properties); return(source); }
public static void InitActiveRecord(Assembly[] assemblies) { var config = new InPlaceConfigurationSource(); config.PluralizeTableNames = true; config.Add(typeof(ActiveRecordBase), new Dictionary <string, string> { { Environment.Dialect, "NHibernate.Dialect.MySQLDialect" }, { Environment.ConnectionDriver, "NHibernate.Driver.MySqlDataDriver" }, { Environment.ConnectionProvider, "NHibernate.Connection.DriverConnectionProvider" }, { Environment.ConnectionStringName, ConnectionHelper.DefaultConnectionStringName }, { Environment.Hbm2ddlKeyWords, "none" } }); ActiveRecordStarter.Initialize(assemblies, config); }
protected IConfigurationSource GetConfigSource() { InPlaceConfigurationSource source = new InPlaceConfigurationSource(); Dictionary <string, string> properties = new Dictionary <string, string>(); properties.Add("hibernate.connection.driver_class", "NHibernate.Driver.SqlClientDriver"); properties.Add("hibernate.dialect", "NHibernate.Dialect.MsSql2000Dialect"); properties.Add("hibernate.connection.provider", "NHibernate.Connection.DriverConnectionProvider"); properties.Add("hibernate.connection.connection_string", "Data Source=.;Initial Catalog=test;Integrated Security=SSPI"); source.Add(typeof(ActiveRecordBase), properties); source.Add(typeof(NonAbstractRootType), properties); return(source); }
/// <summary> /// Handle the initialisation of ActiveRecord data layer. This must only be done once in the /// application lifecycle so this class maintains a count to enforce this. /// </summary> public static void InitDB() { lock (_lockingObject) { if (!_hasInitialised) { try { string data_source = ReservationsServiceInitHelper.BuildReservationsDataSourceString(); Log.Info(string.Format(" ... using => {0} as database", data_source)); Log.Info(string.Format(" ... initializing database connection")); IDictionary <string, string> properties = new Dictionary <string, string>(); properties["connection.driver_class"] = "NHibernate.Driver.FirebirdClientDriver"; properties["dialect"] = "NHibernate.Dialect.FirebirdDialect"; properties["connection.provider"] = "NHibernate.Connection.DriverConnectionProvider"; properties["connection.connection_string"] = data_source; //#if DEBUG // properties["show_sql"] = "true"; //#endif properties["proxyfactory.factory_class"] = "NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle"; InPlaceConfigurationSource source = new InPlaceConfigurationSource(); source.Add(typeof(ActiveRecordBase), properties); ActiveRecordStarter.Initialize(source, typeof(Location), typeof(Session), typeof(Table), typeof(Guest), typeof(Reservation), typeof(Terminal) ); Log.Info(string.Format("... database initialised ok ***")); } catch (SystemException e) { Log.FatalException("*** database did NOT initialise ***", e); throw; } _hasInitialised = true; } } }
public void SetupFixture() { Environment.CurrentDirectory = TestContext.CurrentContext.TestDirectory; var connectionStringName = ConnectionHelper.GetConnectionName(); ConnectionString = ConnectionHelper.GetConnectionString(); if (!ActiveRecordStarter.IsInitialized) { var config = new InPlaceConfigurationSource(); config.PluralizeTableNames = true; config.Add(typeof(ActiveRecordBase), new Dictionary <string, string> { { NHibernate.Cfg.Environment.Dialect, "NHibernate.Dialect.MySQLDialect" }, { NHibernate.Cfg.Environment.ConnectionDriver, "NHibernate.Driver.MySqlDataDriver" }, { NHibernate.Cfg.Environment.ConnectionProvider, "NHibernate.Connection.DriverConnectionProvider" }, { NHibernate.Cfg.Environment.ConnectionStringName, connectionStringName }, { NHibernate.Cfg.Environment.Hbm2ddlKeyWords, "none" }, { NHibernate.Cfg.Environment.FormatSql, "true" }, { NHibernate.Cfg.Environment.UseSqlComments, "true" } }); ActiveRecordStarter.Initialize(new[] { Assembly.Load("Test.Support"), Assembly.Load("ReportTuner"), Assembly.Load("Common.Web.Ui") }, config); } var holder = ActiveRecordMediator.GetSessionFactoryHolder(); var session = holder.CreateSession(typeof(ActiveRecordBase)); var ownerId = uint.Parse(ConfigurationManager.AppSettings["ReportsContactGroupOwnerId"]); if (session.Get <ContactGroupOwner>(ownerId) == null) { session.CreateSQLQuery($"Insert into contacts.contact_group_owners (Id) VALUES({ownerId})").UniqueResult(); } holder = ActiveRecordMediator.GetSessionFactoryHolder(); holder.ReleaseSession(session); IntegrationFixture2.Factory = holder.GetSessionFactory(typeof(ActiveRecordBase)); _webServer = SeleniumFixture.StartServer(); SeleniumFixture.GlobalSetup(); using (var taskService = ScheduleHelper.GetService()) { ScheduleHelper.CreateFolderIfNeeded(taskService); } }
public void Setup() { ConnectionHelper.DefaultConnectionStringName = ConnectionHelper.GetConnectionName(); var config = new InPlaceConfigurationSource(); config.PluralizeTableNames = true; config.Add(typeof(ActiveRecordBase), new Dictionary <string, string> { { Environment.Dialect, "NHibernate.Dialect.MySQLDialect" }, { Environment.ConnectionDriver, "NHibernate.Driver.MySqlDataDriver" }, { Environment.ConnectionProvider, "NHibernate.Connection.DriverConnectionProvider" }, { Environment.ConnectionStringName, ConnectionHelper.GetConnectionName() }, { Environment.Isolation, "ReadCommitted" }, { Environment.Hbm2ddlKeyWords, "none" }, { Environment.FormatSql, "true" }, { Environment.UseSqlComments, "true" } }); ActiveRecordStarter.Initialize(new[] { typeof(Job).Assembly, Assembly.Load("Test.Support") }, config); }
private void ActiveRecordInitialize(string connectionName, Assembly[] assemblies) { if (!ActiveRecordStarter.IsInitialized) { var config = new InPlaceConfigurationSource(); config.IsRunningInWebApp = true; config.PluralizeTableNames = true; config.Add(typeof(ActiveRecordBase), new Dictionary <string, string> { { NHibernate.Cfg.Environment.Dialect, "NHibernate.Dialect.MySQLDialect" }, { NHibernate.Cfg.Environment.ConnectionDriver, "NHibernate.Driver.MySqlDataDriver" }, { NHibernate.Cfg.Environment.ConnectionProvider, "NHibernate.Connection.DriverConnectionProvider" }, { NHibernate.Cfg.Environment.ConnectionStringName, connectionName }, { NHibernate.Cfg.Environment.Hbm2ddlKeyWords, "none" }, { NHibernate.Cfg.Environment.FormatSql, "true" }, { NHibernate.Cfg.Environment.Isolation, "ReadCommitted" } }); ActiveRecordStarter.Initialize(assemblies, config); } }
public InPlaceConfigurationSource CreateSource() { InPlaceConfigurationSource source = new InPlaceConfigurationSource(); for (int i = 0; i < (int)ProfileType.Last - 1; i++) { if (m_host[i].Length > 0) { Hashtable properties = new Hashtable(); properties.Add("hibernate.connection.driver_class", "NHibernate.Driver.MySqlDataDriver"); properties.Add("hibernate.dialect", "NHibernate.Dialect.MySQLDialect"); properties.Add("hibernate.connection.provider", "NHibernate.Connection.DriverConnectionProvider"); properties.Add("hibernate.connection.connection_string", GenerateConnectionString(DatabaseType.MySQL, (ProfileType)i)); source.Add(typeof(ActiveRecordBase), properties); } } return(source); }
public static void Setup(TestContext testContext) { if (!ActiveRecordStarter.IsInitialized) { //Castle.ActiveRecord.Framework.IConfigurationSource config = ActiveRecordSectionHandler.Instance; //Castle.ActiveRecord.Framework.IConfigurationSource config = new XmlConfigurationSource("QuartzAdmin.web.Tests.dll.config"); InPlaceConfigurationSource config = new InPlaceConfigurationSource(); Dictionary <string, string> properties = new Dictionary <string, string>(); properties.Add("connection.driver_class", "NHibernate.Driver.SQLite20Driver"); properties.Add("dialect", "NHibernate.Dialect.SQLiteDialect"); properties.Add("connection.provider", "NHibernate.Connection.DriverConnectionProvider"); properties.Add("connection.connection_string", "Data Source=|DataDirectory|..\\..\\..\\database\\quartz_admin.db"); properties.Add("proxyfactory.factory_class", "NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle"); config.Add(typeof(ActiveRecordBase), properties); Assembly asm1 = Assembly.Load("QuartzAdmin.web"); ActiveRecordStarter.Initialize(asm1, config); } }
/// <summary> /// The common test setup code. To activate it in a specific test framework, /// it must be called from a framework-specific setup-Method. /// </summary> public virtual void SetUp() { ActiveRecordStarter.ResetInitializationFlag(); Dictionary <string, string> properties = new Dictionary <string, string>(); properties.Add("connection.driver_class", "NHibernate.Driver.SQLite20Driver"); properties.Add("dialect", "NHibernate.Dialect.SQLiteDialect"); properties.Add("connection.provider", typeof(InMemoryConnectionProvider).AssemblyQualifiedName); properties.Add("connection.connection_string", "Data Source=:memory:;Version=3;New=True"); properties.Add("proxyfactory.factory_class", "Castle.ActiveRecord.ByteCode.ProxyFactoryFactory, Castle.ActiveRecord"); foreach (var p in GetProperties()) { properties[p.Key] = p.Value; } var config = new InPlaceConfigurationSource(); config.Add(typeof(ActiveRecordBase), properties); foreach (var type in GetAdditionalBaseClasses()) { config.Add(type, properties); } Configure(config); var types = GetTypes(); var assemblies = GetAssemblies(); if (types == null) { types = new Type[0]; } if (assemblies == null) { assemblies = new Assembly[0]; } ActiveRecordStarter.Initialize(assemblies, config, types); ActiveRecordStarter.CreateSchema(); }
public void SetupFixture() { System.Environment.CurrentDirectory = TestContext.CurrentContext.TestDirectory; ConnectionStringName = ConnectionHelper.GetConnectionName(); ConnectionString = ConnectionHelper.GetConnectionString(); //в тестах не может быть блокировок With.DefaultMaxRepeatCount = 0; var nhibernateParams = new Dictionary <string, string> { { Environment.Dialect, "NHibernate.Dialect.MySQLDialect" }, { Environment.ConnectionDriver, "NHibernate.Driver.MySqlDataDriver" }, { Environment.ConnectionProvider, "NHibernate.Connection.DriverConnectionProvider" }, { Environment.ConnectionStringName, ConnectionStringName }, { Environment.Hbm2ddlKeyWords, "none" }, { Environment.FormatSql, "true" }, { Environment.UseSqlComments, "true" } }; if (!ActiveRecordStarter.IsInitialized) { var config = new InPlaceConfigurationSource(); config.PluralizeTableNames = true; config.Add(typeof(ActiveRecordBase), nhibernateParams); ActiveRecordStarter.Initialize(new[] { typeof(ReportResultLog).Assembly, typeof(ContactGroup).Assembly, Assembly.Load("Test.Support") }, config); HbmSerializer.Default.HbmAutoImport = false; foreach (var cfg in ActiveRecordMediator.GetSessionFactoryHolder().GetAllConfigurations()) { cfg.AddInputStream(HbmSerializer.Default.Serialize(Assembly.Load("Common.Models"))); } GeneralReport.Factory = ActiveRecordMediator.GetSessionFactoryHolder().GetSessionFactory(typeof(ActiveRecordBase)); } }
private ArquivoFiscalRecord GetRecordInformacoesArquivo() { IDictionary <string, string> properties = new Dictionary <string, string>(); properties.Add("connection.driver_class", ConfigurationManager.AppSettings["ActiveRecordDriver"]); properties.Add("dialect", ConfigurationManager.AppSettings["ActiveRecordDialect"]); properties.Add("connection.provider", ConfigurationManager.AppSettings["ActiveRecordConnectionProvider"]); properties.Add("connection.connection_string", ConfigurationManager.ConnectionStrings["DBArquivoSpedFiscal"].ConnectionString); properties.Add("proxyfactory.factory_class", ConfigurationManager.AppSettings["ActiveRecordProxyFactory"]); InPlaceConfigurationSource source = new InPlaceConfigurationSource(); source.Add(typeof(ActiveRecordBase), properties); ActiveRecordStarter.Initialize(source, typeof(ArquivoFiscalRecord)); return(ArquivoFiscalRecord.Find(this._NumeroIdentificacaoArquivo)); }
public static void MainProgress(string serverIP) { string server = serverIP; string port = "3306"; string logId = "root"; string password = "******"; string database = "myobject"; server = ConfigManager.GetStringVal(ConfigManager.enmAppKey.MYSQL, "SERVER", ""); database = ConfigManager.GetStringVal(ConfigManager.enmAppKey.MYSQL, "DATABASE", "myobject"); logId = DES.Decode(ConfigManager.GetStringVal(ConfigManager.enmAppKey.MYSQL, "NAME", "FmKfww+xL4U="), Global.DB_PWDKEY); password = DES.Decode(ConfigManager.GetStringVal(ConfigManager.enmAppKey.MYSQL, "PWD", "FmKfww+xL4U="), Global.DB_PWDKEY); port = ConfigManager.GetStringVal(ConfigManager.enmAppKey.MYSQL, "PORT", "3306"); string connstr = "server=" + server + ";port=" + port + ";user id=" + logId + ";password="******";database=" + database + ";charset=utf8;"; InPlaceConfigurationSource source1 = new InPlaceConfigurationSource(); Hashtable properties = new Hashtable(); properties.Add("hibernate.connection.driver class", "NHibernate.Driver.MySqlDataDriver"); properties.Add("hibernate.dialect", "NHibernate.Dialect.MySQLDialect"); properties.Add("hibernate.connection.provider", "NHibernate.Connection.DriverConnectionProvider"); properties.Add("hibernate.connection.connection_string", connstr); source1.Add(typeof(ActiveRecordBase), properties); Type[] types = { typeof(TB_User), typeof(PTS_TABLE_SRC), typeof(TB_PROJECT), typeof(TB_EXPENSE), typeof(TB_BILL), typeof(PTS_OBJECT_TYPE_SRC), typeof(PTS_EXCEL_PROFILE_SRC), typeof(TB_RATIO), typeof(pts_proj_ratio), typeof(PTS_PROJ_COST), }; Castle.ActiveRecord.ActiveRecordStarter.Initialize(source1, types); WY.Common.Data.DbHelper.Initialize("MySql.Data.MySqlClient", connstr); }
private static void ConfigureDatabase() { ActiveRecordStarter.Initialize( InPlaceConfigurationSource.BuildForMSSqlServer("localhost", "test"), typeof(Customer), typeof(CustomerOperation), typeof(Operation)); ActiveRecordStarter.CreateSchema(); Customer customer = new Customer(); customer.Name = "oren"; ActiveRecordMediator.Save(customer); Operation op = new Operation(); op.Name = "View"; ActiveRecordMediator.Save(op); CustomerOperation co = new CustomerOperation(); co.Customer = customer; co.Operation = op; ActiveRecordMediator.Save(co); }
private void btnConnect_Click(object sender, EventArgs e) { ActiveRecordStarter.ResetInitializationFlag(); IDictionary <string, string> properties = new Dictionary <string, string> { { "connection.driver_class", "NHibernate.Driver.SqlClientDriver" }, { "dialect", "NHibernate.Dialect.MsSql2008Dialect" }, { "connection.provider", "NHibernate.Connection.DriverConnectionProvider" }, //Catalog Name Table. Как создать БД с помощью метода ActiveRecordStarter.CreateSchema(); //пока выяснить не удалось но CreateSchema() прекрасно добавляет таблицы к БД { "connection.connection_string", "Data Source=PC;Initial Catalog=vvv;Integrated Security=True" }, { "proxyfactory.factory_class", @"NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle" } }; try { InPlaceConfigurationSource source = new InPlaceConfigurationSource(); source.Add(typeof(ActiveRecordBase), properties); ActiveRecordStarter.Initialize(source, MainDBHelper.GetTypes()); ActiveRecordStarter.CreateSchema(); } catch (Exception e1) { MessageBox.Show(e1.ToString()); } }
public void IsUniqueDoesNotDeadlockOnAutoflushTransaction() { InPlaceConfigurationSource source = (InPlaceConfigurationSource)GetConfigSource(); DefaultFlushType originalType = source.DefaultFlushType; try { ActiveRecordStarter.Initialize(source, typeof(Blog2)); Recreate(); source.DefaultFlushType = DefaultFlushType.Auto; using (new TransactionScope()) { Blog2.DeleteAll(); Blog2 blog = new Blog2(); blog.Name = "FooBar"; blog.Save(); } } finally { source.DefaultFlushType = originalType; } }
/// <summary> /// Hook for modifying the configuration before initialization /// </summary> /// <param name="config"></param> public virtual void Configure(InPlaceConfigurationSource config) { }
public override void Configure(InPlaceConfigurationSource config) { config.DefaultFlushType = DefaultFlushType.Leave; }