using System;

using LinqToDB;

using LinqToDB.Data;

using LinqToDB.Mapping;

using LinqToDB.Configuration;

public class Program

{

    class TestClass

    {

        public Guid Id { get; set; }

        public Guid TagId { get; set; }

        public decimal Value { get; set; }

        public DateTime ModifiedTimeStamp { get; set; }

    }

    public static void Main()

    {

        Console.WriteLine("Linq2db SqlServer Example");

        var ms = new MappingSchema();

        ms.GetFluentMappingBuilder()

            .Entity<TestClass>()

            .HasTableName("TestTable")

            .Property(e => e.Id).IsPrimaryKey()

            .Property(e => e.TagId)

            .Property(e => e.ModifiedTimeStamp).HasDataType(DataType.DateTime2)

            .Property(e => e.Value).HasDataType(DataType.Decimal);

        //SqlServer

        //var cs = FiddleHelper.GetConnectionStringSqlServer();

        //var options = new LinqToDbConnectionOptionsBuilder().UseSqlServer(cs).UseMappingSchema(ms).Build();

        //SQLite

        var cs = "Data Source=sqlite.db;journal_mode=WAL;synchronous=0;Flags=BindUInt32AsInt64;DateTimeKind=Utc;";

        var options = new LinqToDbConnectionOptionsBuilder().UseConnectionString("SQLite", cs).UseMappingSchema(ms).Build();

        using (DataConnection db = new DataConnection(options))

        {

            db.CreateTable<TestClass>();

            TestClass item = new TestClass() { Id = Guid.NewGuid() };

            db.Insert(item);

            Console.WriteLine("item.Id: " + item.Id);

        }

        //FiddleHelper.WriteTable("Product", list); 

    }

}