using LinqToDB;

using LinqToDB.AspNet.Logging;

using LinqToDB.Data;

using LinqToDB.DataProvider.SQLite;

using LinqToDB.Mapping;

using Microsoft.Data.Sqlite;

using Microsoft.Extensions.DependencyInjection;

using Microsoft.Extensions.Logging;

using System;

using System.Linq;

using System.Data;

​

using System.Threading.Tasks;

public class Program

{

    public static async Task Main()

    {

        Console.WriteLine("Hello World");

        // https://learn.microsoft.com/en-us/dotnet/standard/data/sqlite/custom-versions?tabs=netcore-cli

        // Microsoft.Data.Sqlite is built on top of SQLitePCLRaw.

        // Ensuring the SQLite provider is "e_sqlite3" so we get a consistent version on all platforms

        SQLitePCL.raw.SetProvider(new SQLitePCL.SQLite3Provider_e_sqlite3());

        using var sp = new ServiceCollection()

            .AddLogging(x => x.AddConsole())

            .AddSingleton(serviceProvider => {

                var connection = new SqliteConnection("Data Source=dbname;Mode=Memory;Cache=Shared");

                var provider = SQLiteTools.GetDataProvider();

                var options = new DataOptions()

                    .UseConnection(provider, connection)

                    .UseLoggerFactory(serviceProvider.GetService<ILoggerFactory>())

                    ;

                return new DataConnection(options);

            })

            .BuildServiceProvider();

        using var connection = sp.GetService<DataConnection>();

        await connection.CreateTableAsync<TestTable>();

        var myDecimal = 5m;

        await connection.InsertAsync(new TestTable() 

        {

            Id = 1,

            DecimalProp = 2m,

        });

        var query = connection.GetTable<TestTable>()

            .Where(x => x.DecimalProp < myDecimal);

        var result = await query.ToArrayAsync();

        Console.WriteLine("No crash? Found " + result.Length);

    }

}

​

[Table("testTable")]

public class TestTable

{

    [Column]

    public int Id { get; set; }

    [Column]

    public decimal DecimalProp { get; set; }

}