using System;

using System.Threading.Tasks;

using Dapper;

using Dapper.Contrib.Extensions;

using Microsoft.Data.Sqlite;

​

namespace DapperSqlLite

{

    class Program

    {

        static async Task Main(string[] args)

        {

            var testEntity = new TestEntity{Name = "dapper contrib"};

​

            var connectionStringBuilder = new SqliteConnectionStringBuilder(){DataSource = @"testdb.db3" };

            await using var connection = new SqliteConnection(connectionStringBuilder.ConnectionString);

            await connection.ExecuteAsync(@$"CREATE TABLE IF NOT EXISTS [TESTENTITYS] (

                        [ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,

                        [NAME] NVARCHAR(254)  NOT NULL,

                        [INSERTDATE] DATETIME  NOT NULL

                        )");

​

            for (int i = 0; i < 100; i++)

            {

                var newid = await connection.InsertAsync(new TestEntity { Name = $"dapper entity {++i}" });

                var entity = await connection.GetAsync<TestEntity>(newid);

                Console.WriteLine($"{entity.Id} {entity.Name} {entity.InsertDate:s}");

            }

        }

    }

​

    public class TestEntity

    {

        public int Id { get; set; }

        public string Name { get; set; }

        public DateTime InsertDate { get; set; }=DateTime.Now;

    }

}

​