public class TodoList
{
public static void AddTaskCommand(SqliteConnection connection)
{
connection.Execute("INSERT INTO tasks(title) VALUES (@Title)", new
{
Title = "Адская задача888",
});
}
public static void RemoveTaskCommand(SqliteConnection connection)
{
connection.Execute("DELETE FROM tasks WHERE id = (SELECT id FROM tasks ORDER BY id DESC LIMIT 1)");
}
public static void SetFinishedTaskCommand(SqliteConnection connection)
{
connection.Execute("UPDATE tasks SET finished = NOT finished WHERE id = @Id", new
{
Id = 2,
});
}
}