NopCommerce架构分析之(三)EntityFramework数据库初试化及数据操作

2025-05-29 0 27

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

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

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

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

?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20
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初始化数据库

IDbContext,NopObjectContext系统数据库操作上下文。加载所有数据库映射类:EntityTypeConfiguration<TEntityType>。代码如下:

?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21
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中实现数据库工厂的创建、数据库的加载。如下代码:

?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25
//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 的实体类SqlServerDataProvider的数据库初始化方法如下:

?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19
/// <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框架,通过数据库访问上下文建立与数据库的连接及实体与数据表的对应广西。并通过创建IRepository<T>的泛型实体类来实现对每一种数据的处理,也就是所谓的Dao层。业务逻辑层通过每种实体的数据访问仓库Repository<T>来进行数据库操作。

收藏 (0) 打赏

感谢您的支持,我会继续努力的!

打开微信/支付宝扫一扫,即可进行扫码打赏哦,分享从这里开始,精彩与您同在
点赞 (0)

声明:本站所有文章,如无特殊说明或标注,均为本站原创发布。任何个人或组织,在未征得本站同意时,禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益,可联系我们进行处理。

快网idc优惠网 建站教程 NopCommerce架构分析之(三)EntityFramework数据库初试化及数据操作 https://www.kuaiidc.com/101815.html

相关文章

发表评论
暂无评论