Вставка даних в таблицю
Приклад
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 InsertPage(Page page)
{
string query = @"
INSERT INTO pages(name, group_name, value)
VALUES(@name, @group_name, @value)
RETURNING id";
using (SqliteCommand command = new SqliteCommand(query, Page.Conn))
{
command.Parameters.AddWithValue("name", page.Name);
command.Parameters.AddWithValue("group_name", page.GroupName);
command.Parameters.AddWithValue("value", page.Value);
object? result = command.ExecuteScalar();
if (result != null)
{
page.ID = (long)result;
page.IsNew = false;
}
}
}
accounting.org.ua © 2023 рік