Install-Package Microsoft.Data.Sqlite

using Microsoft.Data.Sqlite;

public class SQLiteExample
{
    public void CreateDatabase()
    {
        var connectionString = "Data Source=example.db";  // Путь к базе данных
        using (var connection = new SqliteConnection(connectionString))
        {
            connection.Open();
            var command = connection.CreateCommand();
            command.CommandText =
            @"
                CREATE TABLE IF NOT EXISTS users (
                    id INTEGER PRIMARY KEY AUTOINCREMENT,
                    name TEXT NOT NULL,
                    email TEXT NOT NULL
                );
            ";
            command.ExecuteNonQuery();
        }
    }
}

public void InsertData()
{
    var connectionString = "Data Source=example.db";
    using (var connection = new SqliteConnection(connectionString))
    {
        connection.Open();
        var command = connection.CreateCommand();
        command.CommandText =
        @"
            INSERT INTO users (name, email)
            VALUES ('John Doe', '[email protected]');
        ";
        command.ExecuteNonQuery();
    }
}

public void ReadData()
{
    var connectionString = "Data Source=example.db";
    using (var connection = new SqliteConnection(connectionString))
    {
        connection.Open();
        var command = connection.CreateCommand();
        command.CommandText =
        "SELECT id, name, email FROM users;";

        using (var reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                Console.WriteLine($"ID: {reader.GetInt32(0)}, Name: {reader.GetString(1)}, Email: {reader.GetString(2)}");
            }
        }
    }
}

public void InsertDataWithParameters(string name, string email)
{
    var connectionString = "Data Source=example.db";
    using (var connection = new SqliteConnection(connectionString))
    {
        connection.Open();
        var command = connection.CreateCommand();
        command.CommandText =
        @"
            INSERT INTO users (name, email)
            VALUES (@name, @email);
        ";

        command.Parameters.AddWithValue("@name", name);
        command.Parameters.AddWithValue("@email", email);

        command.ExecuteNonQuery();
    }
}

git pull --rebase origin release/1.2.0

Почему SOAP считается устаревшим, а REST стал стандартом?