.Net 5 内存数据库（共享式）Sqlite

ゝ一纸荒年。 2022-08-29 10:25 207阅读 0赞

引用的Nuget包有

Install-Package  Microsoft.Data.Sqlite.Core
    Install-Package  SQLitePCLRaw.bundle_winsqlite3

示例代码有

SQLitePCL.raw.SetProvider(new SQLitePCL.SQLite3Provider_winsqlite3());
                // Using a name and a shared cache allows multiple connections to access the same
                // in-memory database
                const string connectionString = "Data Source=InMemorySample;Mode=Memory;Cache=Shared";
    
                // The in-memory database only persists while a connection is open to it. To manage
                // its lifetime, keep one open connection around for as long as you need it.
                var masterConnection = new SqliteConnection(connectionString);
                masterConnection.Open();
    
                var createCommand = masterConnection.CreateCommand();
                createCommand.CommandText =
                @"
                    CREATE TABLE data (
                        value TEXT
                    )
                ";
                createCommand.ExecuteNonQuery();
    
                using (var firstConnection = new SqliteConnection(connectionString))
                {
                    firstConnection.Open();
    
                    var updateCommand = firstConnection.CreateCommand();
                    updateCommand.CommandText =
                    @"
                        INSERT INTO data
                        VALUES ('Hello, memory!')
                    ";
                    updateCommand.ExecuteNonQuery();
                }
    
                using (var secondConnection = new SqliteConnection(connectionString))
                {
                    secondConnection.Open();
                    var queryCommand = secondConnection.CreateCommand();
                    queryCommand.CommandText =
                    @"
                        SELECT *
                        FROM data
                    ";
                    var value = (string)queryCommand.ExecuteScalar();
                    Console.WriteLine(value);
                }
    
                // After all the connections are closed, the database is deleted.
                masterConnection.Close();
                Console.ReadLine();

结果如下

![20210802094432619.png][]

效果很不错。

[20210802094432619.png]: /images/20220829/f1ff588498b74642a36c512dbde78851.png