返回下一个可用日期的SQLite实体框架查询

using System;
using System.Data.SQLite;

public class Program
{
    public static void Main()
    {
        string connectionString = "Data Source=database.db;Version=3;";

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

            string query = "SELECT MIN(date) FROM availability WHERE date > @currentDate";
            using (SQLiteCommand command = new SQLiteCommand(query, connection))
            {
                command.Parameters.AddWithValue("@currentDate", DateTime.Now);

                object result = command.ExecuteScalar();
                DateTime nextAvailableDate = Convert.ToDateTime(result);

                Console.WriteLine("Next available date: " + nextAvailableDate);
            }
        }
    }
}