NopCommerce架構(gòu)分析之(三)EntityFramework數(shù)據(jù)庫(kù)初試化及數(shù)據(jù)操作
系統(tǒng)啟動(dòng)時(shí)執(zhí)行任務(wù):IStartupTask,啟動(dòng)時(shí)執(zhí)行的任務(wù)主要是數(shù)據(jù)庫(kù)的初始化和加載。
IStartupTask調(diào)用IEfDataProvider進(jìn)行數(shù)據(jù)庫(kù)的初始化。
IEfDataProvider,SqlCeDataProvider:獲取數(shù)據(jù)連接工廠,不同類(lèi)型數(shù)據(jù)庫(kù),連接工廠不同。
接口IStartupTask的實(shí)體類(lèi)EfStartUpTask的實(shí)現(xiàn)如下:
public class EfStartUpTask : IStartupTask { public void Execute() { var settings = EngineContext.Current.Resolve<DataSettings>(); if (settings != null && settings.IsValid()) { var provider = EngineContext.Current.Resolve<IEfDataProvider>(); if (provider == null) throw new NopException("No EfDataProvider found"); provider.SetDatabaseInitializer(); } } public int Order { //ensure that this task is run first get { return -1000; } } }
SqlCeInitializer,CreateCeDatabaseIfNotExists初始化數(shù)據(jù)庫(kù)。
IDbContext,NopObjectContext系統(tǒng)數(shù)據(jù)庫(kù)操作上下文。加載所有數(shù)據(jù)庫(kù)映射類(lèi):EntityTypeConfiguration<TEntityType>。代碼如下:
protected override void OnModelCreating(DbModelBuilder modelBuilder) { //dynamically load all configuration //System.Type configType = typeof(LanguageMap); //any of your configuration classes here //var typesToRegister = Assembly.GetAssembly(configType).GetTypes() var typesToRegister = Assembly.GetExecutingAssembly().GetTypes() .Where(type => !String.IsNullOrEmpty(type.Namespace)) .Where(type => type.BaseType != null && type.BaseType.IsGenericType && type.BaseType.GetGenericTypeDefinition() == typeof(EntityTypeConfiguration<>)); foreach (var type in typesToRegister) { dynamic configurationInstance = Activator.CreateInstance(type); modelBuilder.Configurations.Add(configurationInstance); } //...or do it manually below. For example, //modelBuilder.Configurations.Add(new LanguageMap()); base.OnModelCreating(modelBuilder); }
此方法是繼承自DbContext。并在系統(tǒng)啟動(dòng)時(shí)調(diào)用,建立數(shù)據(jù)表與實(shí)體的對(duì)應(yīng)關(guān)系。
在類(lèi)型依賴(lài)注冊(cè)類(lèi)Nop.Web.Framework.DependencyRegistrar中實(shí)現(xiàn)數(shù)據(jù)庫(kù)工廠的創(chuàng)建、數(shù)據(jù)庫(kù)的加載。如下代碼:
//data layer var dataSettingsManager = new DataSettingsManager(); var dataProviderSettings = dataSettingsManager.LoadSettings(); builder.Register(c => dataSettingsManager.LoadSettings()).As<DataSettings>(); builder.Register(x => new EfDataProviderManager(x.Resolve<DataSettings>())).As<BaseDataProviderManager>().InstancePerDependency(); builder.Register(x => (IEfDataProvider)x.Resolve<BaseDataProviderManager>().LoadDataProvider()).As<IDataProvider>().InstancePerDependency(); builder.Register(x => (IEfDataProvider)x.Resolve<BaseDataProviderManager>().LoadDataProvider()).As<IEfDataProvider>().InstancePerDependency(); if (dataProviderSettings != null && dataProviderSettings.IsValid()) { var efDataProviderManager = new EfDataProviderManager(dataSettingsManager.LoadSettings()); var dataProvider = (IEfDataProvider)efDataProviderManager.LoadDataProvider(); dataProvider.InitConnectionFactory(); builder.Register<IDbContext>(c => new NopObjectContext(dataProviderSettings.DataConnectionString)).InstancePerHttpRequest(); } else { builder.Register<IDbContext>(c => new NopObjectContext(dataSettingsManager.LoadSettings().DataConnectionString)).InstancePerHttpRequest(); } builder.RegisterGeneric(typeof(EfRepository<>)).As(typeof(IRepository<>)).InstancePerHttpRequest();
接口IEfDataProvider 的實(shí)體類(lèi)SqlServerDataProvider的數(shù)據(jù)庫(kù)初始化方法如下:
/// <summary> /// Set database initializer /// </summary> 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<string>(); //use webHelper.MapPath instead of HostingEnvironment.MapPath which is not available in unit tests customCommands.AddRange(ParseCommands(HostingEnvironment.MapPath("~/App_Data/SqlServer.Indexes.sql"), false)); //use webHelper.MapPath instead of HostingEnvironment.MapPath which is not available in unit tests customCommands.AddRange(ParseCommands(HostingEnvironment.MapPath("~/App_Data/SqlServer.StoredProcedures.sql"), false)); var initializer = new CreateTablesIfNotExist<NopObjectContext>(tablesToValidate, customCommands.ToArray()); Database.SetInitializer(initializer); }
另外,EntityFramework本事是ORM框架,通過(guò)數(shù)據(jù)庫(kù)訪(fǎng)問(wèn)上下文建立與數(shù)據(jù)庫(kù)的連接及實(shí)體與數(shù)據(jù)表的對(duì)應(yīng)廣西。并通過(guò)創(chuàng)建IRepository<T>的泛型實(shí)體類(lèi)來(lái)實(shí)現(xiàn)對(duì)每一種數(shù)據(jù)的處理,也就是所謂的Dao層。業(yè)務(wù)邏輯層通過(guò)每種實(shí)體的數(shù)據(jù)訪(fǎng)問(wèn)倉(cāng)庫(kù)Repository<T>來(lái)進(jìn)行數(shù)據(jù)庫(kù)操作。
相關(guān)文章
Mac中體驗(yàn)ASP.NET 5 beta2的K gen代碼生成
這篇文章主要介紹了Mac中體驗(yàn)ASP.NET 5 beta2的K gen代碼生成,需要的朋友可以參考一下。2016-06-06《解剖PetShop》之五:PetShop之業(yè)務(wù)邏輯層設(shè)計(jì)
業(yè)務(wù)邏輯層(Business Logic Layer)無(wú)疑是系統(tǒng)架構(gòu)中體現(xiàn)核心價(jià)值的部分,本文主要講解PetShop4.0的業(yè)務(wù)邏輯層設(shè)計(jì),需要的朋友可以參考下。2016-05-05ASP.NET程序中用Repeater實(shí)現(xiàn)分頁(yè)
ASP.NET程序中用Repeater實(shí)現(xiàn)分頁(yè)...2006-10-10在ASP.NET 2.0中操作數(shù)據(jù)之五十一:從GridView的頁(yè)腳插入新記錄
本文介紹在ASP.NET 2.0中如何在GridView的頁(yè)腳動(dòng)態(tài)插入一行新記錄,要顯示頁(yè)腳行只需要設(shè)置ShowFooter屬性為true。我們可以這樣對(duì)頁(yè)腳行進(jìn)行用戶(hù)定制:將每一列轉(zhuǎn)換成TemplateField,并在其FooterTemplate模板定制插入界面。2016-05-05在ASP.NET 2.0中操作數(shù)據(jù)之三十八:處理BLL和DAL的異常
本文主要介紹如何在BLL和DAL層如何處理異常,以達(dá)到給用戶(hù)顯示友好的錯(cuò)誤信息。2016-05-05.Net?Core服務(wù)治理Consul使用服務(wù)發(fā)現(xiàn)
Consul是HashiCorp公司推出的開(kāi)源工具,Consul由Go語(yǔ)言開(kāi)發(fā),部署起來(lái)非常容易,只需要極少的可執(zhí)行程序和配置文件,具有綠色、輕量級(jí)的特點(diǎn)。Consul是分布式的、高可用的、?可橫向擴(kuò)展的用于實(shí)現(xiàn)分布式系統(tǒng)的服務(wù)發(fā)現(xiàn)與配置2022-01-01NopCommerce架構(gòu)分析之(七)主題Theme皮膚管理器
本文主要介紹NopCommerce的皮膚管理機(jī)制,NopCommerce提供默認(rèn)的皮膚,我們也可以制作自己的皮膚,以實(shí)現(xiàn)個(gè)性化定制。2016-04-04解讀ASP.NET 5 & MVC6系列教程(2):初識(shí)項(xiàng)目
這篇文章主要介紹ASP.NET 5中新建項(xiàng)目的結(jié)構(gòu)和之前的差異,介紹的比較細(xì)致,需要的朋友可以參考下。2016-06-06解讀ASP.NET 5 & MVC6系列教程(1):ASP.NET 5簡(jiǎn)介
這篇文章主要介紹ASP.NET 5簡(jiǎn)介以及對(duì)各個(gè)版本號(hào)進(jìn)行解釋?zhuān)珹SP.NET 5中新的變化,需要的朋友可以參考下。2016-06-06