Документація

using Microsoft.Data.Sqlite;

public class Page
{
    public bool IsNew { get; set; }
    public long ID { get; set; } = 0;
    public string GroupName { get; set; } = "";
    public string Name { get; set; } = "";
    public string Value { get; set; } = "";

    public static SqliteConnection? Conn { get; set; } = null;
}

public static Page? SelectPage(long id)
{
    Page? page = null;

    string query = @"
    SELECT id, name, group_name, value
    FROM pages
    WHERE id = @id
    ";

    using (SqliteCommand command = new SqliteCommand(query, Page.Conn))
    {
        command.Parameters.AddWithValue("id", id);
        SqliteDataReader reader = command.ExecuteReader();

        while (reader.Read())
        {
            page = new Page
            {
                ID = (long)reader["id"],
                Name = (string)reader["name"],
                GroupName = (string)reader["group_name"],
                Value = (string)reader["value"]
            };
        }

        reader.Close();
    }

    return page;
}