sqlbulkcopy mysql_使用SqlBulkCopy批量插入/更新数据

usingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;namespaceSqlBulkCopyHelper

{public classsqlHelper

{///

///数据库操作帮助类///此段基础代码为SQLServer数据库帮助类///如需操作MySQL///1.将代码中Sql改为MySql///2.添加MySql.Data.dll引用(可通过官网或NuGet)///3.using System.Data.SqlClient;替换为using MySql.Data.MySqlClient;///

///

///数据库连接字符串///

private static string connectionStr =System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionName"].ConnectionString;publicsqlHelper() { }public sqlHelper(stringconnectionStr)

{

sqlHelper.connectionStr=connectionStr;

}///

///得到连接对象///

///

public staticSqlConnection GetConn()

{

SqlConnection sqlconn= null;

sqlconn= newSqlConnection(connectionStr);returnsqlconn;

}///

///查询操作///

///

///

public static DataTable GetDataTable(string sql, paramsSqlParameter[] sp)

{using (SqlConnection conn =GetConn())

{

conn.Open();using (SqlDataAdapter sda = newSqlDataAdapter(sql, conn))

{

sda.SelectCommand.Parameters.AddRange(sp);

DataTable dt= newDataTable();

sda.Fill(dt);returndt;

}

}

}///

///增删改操作///

/// sql语句

/// 执行后的条数

public static int ExecuteNonQuery(string sql, paramsSqlParameter[] sp)

{using (SqlConnection conn =GetConn())

{

conn.Open();using (SqlCommand cmd = newSqlCommand(sql, conn))

{

cmd.Parameters.AddRange(sp);int i =cmd.ExecuteNonQuery();returni;

}

}

}///

///执行一条SQL语句,返回首行首列///

/// sql语句

/// 首行首列

public static object ExecuteScalar(string sql, paramsSqlParameter[] sp)

{using (SqlConnection conn =GetConn())

{

conn.Open();using (SqlCommand cmd = newSqlCommand(sql, conn))

{

cmd.Parameters.AddRange(sp);returncmd.ExecuteScalar();

}

}

}

}

}