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

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 void UpdatePage(Page page)
{
    string query = @"
    UPDATE pages 
    SET 
    name = @name, 
    group_name = @group_name, 
    value = @value
    WHERE id = @id
    ";

    using (SqliteCommand command = new SqliteCommand(query, Page.Conn))
    {
        command.Parameters.AddWithValue("id", page.ID);
        command.Parameters.AddWithValue("name", page.Name);
        command.Parameters.AddWithValue("group_name", page.GroupName);
        command.Parameters.AddWithValue("value", page.Value);
        command.ExecuteNonQuery();
    }
}