範文齋

IStartupTask連接數據庫的方法

系統啓動時執行任務:IStartupTask,啓動時執行的任務主要是數據庫的初始化和加載。

IStartupTask連接數據庫的方法

IStartupTask調用IEfDataProvider進行數據庫的初始化。

IEfDataProvider,SqlCeDataProvider:獲取數據連接工廠,不同類型數據庫,連接工廠不同。

接口IStartupTask的.實體類EfStartUpTask的實現如下:

public class EfStartUpTask : IStartupTask { public void Execute() { var settings = lve(); if (settings != null && lid()) { var provider = lve(); if (provider == null) throw new NopException("No EfDataProvider found"); atabaseInitializer(); } } public int Order { //ensure that this task is run first get { return -1000; } } }

SqlCeInitializer,CreateCeDatabaseIfNotExists初始化數據庫。

IDbContext,NopObjectContext系統數據庫操作上下文。加載所有數據庫映射類:EntityTypeConfiguration。代碼如下:

protected override void OnModelCreating(DbModelBuilder modelBuilder) { //dynamically load all configuration // configType = typeof(LanguageMap); //any of your configuration classes here //var typesToRegister = ssembly(configType)ypes() var typesToRegister = xecutingAssembly()ypes() e(type => !llOrEmpty(space)) e(type => Type != null && nericType && enericTypeDefinition() == typeof(EntityTypeConfiguration<>)); foreach (var type in typesToRegister) { dynamic configurationInstance = teInstance(type); (configurationInstance); } // do it manually below. For example, //(new LanguageMap()); delCreating(modelBuilder); }

此方法是繼承自DbContext。並在系統啓動時調用,建立數據表與實體的對應關係。

在類型依賴註冊類ndencyRegistrar中實現數據庫工廠的創建、數據庫的加載。如下代碼:

//data layer var dataSettingsManager = new DataSettingsManager(); var dataProviderSettings = Settings(); ster(c => Settings())(); ster(x => new EfDataProviderManager(lve()))()ancePerDependency(); ster(x => (IEfDataProvider)lve()DataProvider())()ancePerDependency(); ster(x => (IEfDataProvider)lve()DataProvider())()ancePerDependency(); if (dataProviderSettings != null && lid()) { var efDataProviderManager = new EfDataProviderManager(Settings()); var dataProvider = (IEfDataProvider)DataProvider(); ConnectionFactory(); ster(c => new NopObjectContext(ConnectionString))ancePerHttpRequest(); } else { ster(c => new NopObjectContext(Settings()ConnectionString))ancePerHttpRequest(); } sterGeneric(typeof(EfRepository<>))(typeof(IRepository<>))ancePerHttpRequest();

接口IEfDataProvider 的實體類SqlServerDataProvider的數據庫初始化方法如下

///

/// Set database initializer ///

public override void SetDatabaseInitializer() { //pass some table names to ensure that we have nopCommerce 2.X installed var tablesToValidate = new[] {"Customer", "Discount", "Order", "Product", "ShoppingCartItem"}; //custom commands (stored proedures, indexes) var customCommands = new List

(); //use webHelper.MapPath instead of HostingEnvironment.MapPath which is not available in unit tests customCommands.AddRange(ParseCommands(HostingEnvironment.MapPath("~/App_Data/"), false)); //use webHelper.MapPath instead of HostingEnvironment.MapPath which is not available in unit tests customCommands.AddRange(ParseCommands(HostingEnvironment.MapPath("~/App_Data/"), false)); var initializer = new CreateTablesIfNotExist(tablesToValidate, ray()); nitializer(initializer); }

另外,EntityFramework本事是ORM框架,通過數據庫訪問上下文建立與數據庫的連接及實體與數據表的對應廣西。並通過創建IRepository的泛型實體類來實現對每一種數據的處理,也就是所謂的Dao層。業務邏輯層通過每種實體的數據訪問倉庫Repository來進行數據庫操作。