using Microsoft.Data.Sqlite;

using MuchAdo.Sqlite;

using System;

​

using var connector = new SqliteDbConnector(

    new SqliteConnection("Data Source=:memory:"));

​

connector

    .Command("""

        create table widgets (

            id integer primary key autoincrement,

            name text not null,

            height real not null)

        """)

    .Execute();

​

var widgets = new[]

{

    new Widget("First", 6.875),

    new Widget("Second", 1.414),

    new Widget("Third", 3.1415),

};

​

connector.BeginTransaction();

​

foreach (var widget in widgets)

{

    connector

        .CommandFormat($"""

            insert into widgets (name, height)

            values ({widget.Name}, {widget.Height})

            """)

        .Execute();

}

​

connector.CommitTransaction();

​

var maxHeight = 5.0;

foreach (var widget in connector

    .CommandFormat($"""

        select name, height

        from widgets

        where height <= {maxHeight}

        """)

    .Query<Widget>())

{

    Console.WriteLine($"short: {widget}");

}

​

var (min, max) = connector

    .Command("select min(height), max(height) from widgets")

    .QuerySingle<(double, double)>();

Console.WriteLine($"min height {min}, max height {max}");

​

record Widget(string Name, double Height);

​