CloudWave 的使用

1、在项目中新建Config文件夹

  1.1、新建 Web配置文件，文件名 Data.Objects.config 文件,这里是多数据库配置 如不需要 删除其它两个

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <!--数据库配置开始-->
  <dbfactory>
    <!--多数据库连接配置  修改server 地址 user id 账号 password 密码  database 数据库名称-->
    <property name="connection.string">
      server=127.0.0.1;user id=test;password=123456;database=test;pooling=true;Min Pool Size=0;Max Pool Size=512;
    </property>
    <property name="connection.string.user">
      server=127.0.0.1;user id=test;password=123456;database=test;pooling=true;Min Pool Size=0;Max Pool Size=512;
    </property>
    <property name="connection.string.statstics">
      server=127.0.0.1;user id=test;password=123456;database=test;pooling=true;Min Pool Size=0;Max Pool Size=512;
    </property>
    <property name="connection.showsql">true</property>
    <property name="connection.provider.mysql">MySql.Data.MySqlClient</property>
    <property name="connection.timeout">10</property>
  </dbfactory>
  <!--数据库配置结束-->
</configuration>

注：多数据库配置时默认使用第一个，使用其他数据库时需在执行sql时指定数据库

2、在web.config文件中加入

 <!--MySql使用-->
  <system.data>
    <DbProviderFactories>
      <remove invariant="MySql.Data.MySqlClient" />
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL"
        type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>
  </system.data>

3、引用服务

   下载地址：https://files.cnblogs.com/files/miskis/CloudWave--dll.zip

 

查询sql执行

 string sql = "select * from Video ";
 DataTable list = DataHelper.Fill2(sql);

添加/修改

 string insertSql= "insert into staff_info(name,email)values(@name,@email)";
 Dictionary<string, object> dic = new Dictionary<string, object>();
 dic.Add("name", "test");
 dic.Add("email","test@qq.com");
 int sum= DataHelper.ExcuteNonQuery2(insertSql, dic);

 string updateSql = "update staff_info set name=@name,email=@email where id=1";
 Dictionary<string, object> dic1 = new Dictionary<string, object>();
 dic1.Add("name", "test1");
 dic1.Add("email", "test1@qq.com");
 int sum1 = DataHelper.ExcuteNonQuery2(updateSql, dic1);