参数化SQL查询中使用的对象类型参数数组

using System;
using System.Data.SqlClient;

public class Employee
{
    public int Id { get; set; }
    public string Name { get; set; }
    public decimal Salary { get; set; }
}

public void InsertEmployees(Employee[] employees)
{
    string connectionString = "your_connection_string_here";
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        string sql = "INSERT INTO Employees (Id, Name, Salary) VALUES (@Id, @Name, @Salary)";

        using (SqlCommand command = new SqlCommand(sql, connection))
        {
            foreach (var employee in employees)
            {
                command.Parameters.Clear();
                command.Parameters.AddWithValue("@Id", employee.Id);
                command.Parameters.AddWithValue("@Name", employee.Name);
                command.Parameters.AddWithValue("@Salary", employee.Salary);
                command.ExecuteNonQuery();
            }
        }
    }
}