Mysql EF 数据录入&批量数据录入

逐条录入数据

/// <summary>
/// 一条条进行数据录入
/// </summary>
/// <param name="tableName"></param>
/// <param name="dt"></param>
/// <returns></returns>
private static int InsertDataTable(string tableName, DataTable dt)
{
	//循环列，循环每行，执行insert sql语句
	string colStr = "";
	List<string> col = new List<string>();
	foreach (DataColumn column in dt.Columns)
	{
		col.Add(column.ColumnName);
		colStr += $"`{column.ColumnName}`,";
	}
	colStr = colStr.TrimEnd(',');
	var totalCount = 0;
	foreach (DataRow dr in dt.Rows)
	{
		string val = "";
		foreach (var columnName in col)
		{
			val += $"\"{dr[columnName]}\",";
		}
		val = val.TrimEnd(',');
		//这里可以使用MySqlParameter
		string sql = $"insert into `{tableName}`({colStr}) values({val})&#