Вибірка колекції даних
Приклад
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 рік