.netmysql一次插入多条数据库

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;

class Program
{
    static void Main()
    {
        string connectionString = "server=localhost;user=root;database=testdb;port=3306;password=yourpassword";
        using (MySqlConnection connection = new MySqlConnection(connectionString))
        {
            connection.Open();

            string sql = "INSERT INTO users (name, email) VALUES (@name, @email)";
            using (MySqlCommand command = new MySqlCommand(sql, connection))
            {
                command.Parameters.Add("@name", MySqlDbType.VarChar);
                command.Parameters.Add("@email", MySqlDbType.VarChar);

                List<User> users = new List<User>
                {
                    new User { Name = "Alice", Email = "alice@example.com" },
                    new User { Name = "Bob", Email = "bob@example.com" }
                };

                foreach (var user in users)
                {
                    command.Parameters["@name"].Value = user.Name;
                    command.Parameters["@email"].Value = user.Email;
                    command.ExecuteNonQuery();
                }
            }
        }
    }
}

public class User
{
    public string Name { get; set; }
    public string Email { get; set; }
}

using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;

class Program
{
    static void Main()
    {
        using (var context = new ApplicationDbContext())
        {
            context.Database.EnsureCreated();

            List<User> users = new List<User>
            {
                new User { Name = "Alice", Email = "alice@example.com" },
                new User { Name = "Bob", Email = "bob@example.com" }
            };

            context.Users.AddRange(users);
            context.SaveChanges();
        }
    }
}

public class ApplicationDbContext : DbContext
{
    public DbSet<User> Users { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseMySQL("server=localhost;user=root;database=testdb;port=3306;password=yourpassword");
    }
}

public class User
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Email { get; set; }
}