本文介绍如何在C#中利用SqlBulkCopy进行MySQL数据库的批量插入和更新。通过修改代码中的数据访问层，引入MySql.Data库，并调整相关命名空间，可以实现高效的数据批量处理。
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();
}
}
}
}
}
扫一扫
1329
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
