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

Вибірка колекції даних


Приклад

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 List<Page> SelectPages(string groupName)
{
    List<Page> listPages = new List<Page>();

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

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

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

        reader.Close();
    }

    return listPages;
}

accounting.org.ua © 2023 рік