从.Net核心中日期范围的数据库中查询

DateTime startDate = new DateTime(2022, 1, 1);
DateTime endDate = new DateTime(2022, 12, 31);

string query = "SELECT * FROM TableName WHERE DateColumn >= @StartDate AND DateColumn <= @EndDate";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand(query, connection);
    command.Parameters.AddWithValue("@StartDate", startDate);
    command.Parameters.AddWithValue("@EndDate", endDate);

    connection.Open();
    SqlDataReader reader = command.ExecuteReader();

    while (reader.Read())
    {
        // 处理查询结果
    }

    reader.Close();
}