IStartupTask连接数据库的方法

IStartupTask连接数据库的方法

　　系统启动时执行任务：IStartupTask,启动时执行的任务主要是数据库的初始化和加载。

　　IStartupTask调用IEfDataProvider进行数据库的初始化。

　　IEfDataProvider,SqlCeDataProvider：获取数据连接工厂，不同类型数据库，连接工厂不同。

　　接口IStartupTask的实体类EfStartUpTask的实现如下：

　　public class EfStartUpTask : IStartupTask { public void Execute() { var settings = EngineContext.Current.Resolve(); if (settings != null && settings.IsValid()) { var provider = EngineContext.Current.Resolve(); 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初始化数据库。

　　IDbContext，NopObjectContext系统数据库操作上下文。加载所有数据库映射类：EntityTypeConfiguration。代码如下：

　　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。并在系统启动时调用，建立数据表与实体的对应关系。

　　在类型依赖注册类Nop.Web.Framework.DependencyRegistrar中实现数据库工厂的创建、数据库的加载。如下代码：

　　//data layer var dataSettingsManager = new DataSettingsManager(); var dataProviderSettings = dataSettingsManager.LoadSettings(); builder.Register(c => dataSettingsManager.LoadSettings()).As(); builder.Register(x => new EfDataProviderManager(x.Resolve())).As().InstancePerDependency(); builder.Register(x => (IEfDataProvider)x.Resolve().LoadDataProvider()).As().InstancePerDependency(); builder.Register(x => (IEfDataProvider)x.Resolve().LoadDataProvider()).As().InstancePerDependency(); if (dataProviderSettings != null && dataProviderSettings.IsValid()) { var efDataProviderManager = new EfDataProviderManager(dataSettingsManager.LoadSettings()); var dataProvider = (IEfDataProvider)efDataProviderManager.LoadDataProvider(); dataProvider.InitConnectionFactory(); builder.Register(c => new NopObjectContext(dataProviderSettings.DataConnectionString)).InstancePerHttpRequest(); } else { builder.Register(c => new NopObjectContext(dataSettingsManager.LoadSettings().DataConnectionString)).InstancePerHttpRequest(); } builder.RegisterGeneric(typeof(EfRepository<>)).As(typeof(IRepository<>)).InstancePerHttpRequest();

　　接口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/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(tablesToValidate, customCommands.ToArray()); Database.SetInitializer(initializer); }

　　另外，EntityFramework本事是ORM框架，通过数据库访问上下文建立与数据库的连接及实体与数据表的对应广西。并通过创建IRepository的泛型实体类来实现对每一种数据的处理，也就是所谓的Dao层。业务逻辑层通过每种实体的数据访问仓库Repository来进行数据库操作。

[IStartupTask连接数据库的方法]

【IStartupTask连接数据库的方法】相关文章：

电脑设置宽带拨号连接的方法08-27

ipad无法与电脑连接的解决方法09-06

手机wifi连接电脑上网方法06-24

win7“本地连接未启用DHCP”解决方法09-01

连接电脑步骤06-11

营销的本质是连接用户08-01

英雄联盟连接失败无法连接服务器怎么处理09-13

营销的本质：连接客户11-05

电脑连接网络怎么设置08-05

音响怎么连接电脑06-06