nopcommerce mysql_nopCommerce如何支持MySQL

最新推荐文章于 2021-08-08 12:28:13 发布

weixin_39684495

最新推荐文章于 2021-08-08 12:28:13 发布

阅读量157

点赞数

文章标签： nopcommerce mysql

本文链接：https://blog.csdn.net/weixin_39684495/article/details/113279300

版权

本文档详细介绍了如何使nopCommerce支持MySQL数据库，包括在Easy.Data中添加MySqlConnectionFactory和MySqlDataProvider类，修改EfDataProviderManager加载数据提供程序的代码，调整初始化数据库的函数，更改领域模型的映射，并在安装界面添加MySQL配置选项。

摘要由CSDN通过智能技术生成

此方法支持nopCommerce2.4以上版本(缺少的代码，可参照nopCommerce2.6源码)

在工程Easy.Data中：

1、添加MySqlConnectionFactory和MySqlDataProvider

在Easy.Data目录下添加两个Class,MySqlConnectionFactory和MySqlDataProvider，

MySqlConnectionFactory：

usingMySql.Data.MySqlClient;usingSystem;usingSystem.Collections.Generic;usingSystem.Data.Common;usingSystem.Data.Entity.Infrastructure;usingSystem.Linq;usingSystem.Text;namespaceEasy.Data

{public classMySqlConnectionFactory : IDbConnectionFactory

{private readonly string_baseConnectionString;private Func_providerFactoryCreator;publicMySqlConnectionFactory()

{

}public MySqlConnectionFactory(stringbaseConnectionString)

{this._baseConnectionString =baseConnectionString;

}public DbConnection CreateConnection(stringnameOrConnectionString)

{string connectionString =nameOrConnectionString;bool treatAsConnectionString = nameOrConnectionString.IndexOf('=') >= 0;if (!treatAsConnectionString)

{

MySqlConnectionStringBuilder builder= new MySqlConnectionStringBuilder(this.BaseConnectionString);

builder.Server=nameOrConnectionString;

connectionString=builder.ConnectionString;

}

DbConnection connection= null;try{

connection= this.ProviderFactory("MySql.Data.MySqlClient").CreateConnection();

connection.ConnectionString=connectionString;

}catch{

connection= newMySqlConnection(connectionString);

}returnconnection;

}public stringBaseConnectionString

{get{return this._baseConnectionString;

}

}internal FuncProviderFactory

{get{

Func func1 = this._providerFactoryCreator;return delegate(stringname)

{returnDbProviderFactories.GetFactory(name);

};

}set{this._providerFactoryCreator =value;

}

View Code

MySqlDataProvider：

usingEasy.Data.Initializers;usingMySql.Data.MySqlClient;usingSystem;usingSystem.Collections.Generic;usingSystem.Data.Common;usingSystem.Data.Entity;usingSystem.Data.Entity.Infrastructure;usingSystem.IO;usingSystem.Linq;usingSystem.Text;usingSystem.Web.Hosting;namespaceEasy.Data

{public classMySqlDataPro

最低0.47元/天解锁文章