从数据库中获取两个日期之间的所有记录C#

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Your_Connection_String";
        string startDate = "2022-01-01";
        string endDate = "2022-12-31";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            string query = $"SELECT * FROM YourTable WHERE DateColumn >= '{startDate}' AND DateColumn <= '{endDate}'";

            SqlCommand command = new SqlCommand(query, connection);
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                // 处理每一条记录
                // 例如：Console.WriteLine(reader["ColumnName"]);
            }

            reader.Close();
        }
    }
}