duckdb数据库-内存数据库

https://duckdb.org/#quickinstall

 

namespace DuckDBDemo
{
    internal class Program
    {
        // 文件数据库：DataSource=train_services.db
        // 内存数据库：DataSource=:memory:
        static IFreeSql fsql = new FreeSql.FreeSqlBuilder()
                        .UseConnectionString(FreeSql.DataType.DuckDB, "DataSource=:memory:")// database=':memory:'
                        .UseMonitorCommand(cmd => Console.WriteLine($"Sql：{cmd.CommandText}"))
                        .UseAutoSyncStructure(true) //自动创建表
                        .Build();

        static void Main(string[] args)
        {
            fsql.CodeFirst.SyncStructure<EquipLog>();

            Test();
        }

        static async Task Test()
        {
            EquipLog model = new EquipLog() { UUId = Guid.NewGuid().ToString(), EquipSN = "111" };
            var ret = await fsql.Insert(model).ExecuteAffrowsAsync() > 0;
            var data = await fsql.Select<EquipLog>().ToListAsync();
        }
    }
}