blocks|key|341346|text|这是我不太完美的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|341347|SQLiteConnection+connection+=+new+SQLiteConnection("Data+Source="+%2B+file);
connection.Open();
using+(var+command+=+new+SQLiteCommand(sqliteConnection))
{
++++command.CommandText+=+"PRAGMA+journal_mode=WAL";
++++command.ExecuteNonQuery();
}
//+(Perform+my+query)|code-block|syntax|javascript|341348|如果你知道一些不那么冗长的东西，我会很高兴听到的！|341349|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Here is my less-than-perfect solution:

<pre><code>SQLiteConnection connection = new SQLiteConnection("Data Source=" + file);
connection.Open();
using (var command = new SQLiteCommand(sqliteConnection))
{
 command.CommandText = "PRAGMA journal_mode=WAL";
 command.ExecuteNonQuery();
}
// (Perform my query)
</code></pre>

If you know something less verbose, I would be happy to hear about it!

blocks|key|123479|text|在SQLiteConnection连接字符串中指定的工厂方法如何？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|123480|例如，用于|123481|public+static+class+Connection
{
++++public+abstract+SQLiteConnection+NewConnection(String+file);
}

public+class+NormalConnection+:+Connection+
{
++public+override+SQLiteConnection+NewConnection(String+file)
++{
+++++return+new+SQLiteConnection("Data+Source="+%2B+file);
++}
}

public+class+WALConnection+:+Connection+
{
++public+override+SQLiteConnection+NewConnection(String+file)
++{
++++return+new+SQLiteConnection("Data+Source="+%2B+file+%2B+";PRAGMA+journal_mode=WAL;"
++}
}|code-block|syntax|javascript|123482|代码没有经过测试，但我希望你能理解，所以当你使用它的时候，你可以这样做。|123483|+++SQLiteConnection+conWal+=+new+WALConnection(file);
++++conWAL.Open();

++++SQLiteConnection+conNormal+=+new+NormalConnection(file);
++++conNormal.Open();|123484|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

how about a factory approach to specify in the SQLiteConnection connetion string ?

for e.g

<pre><code>public static class Connection
{
 public abstract SQLiteConnection NewConnection(String file);
}

public class NormalConnection : Connection 
{
 public override SQLiteConnection NewConnection(String file)
 {
 return new SQLiteConnection("Data Source=" + file);
 }
}

public class WALConnection : Connection 
{
 public override SQLiteConnection NewConnection(String file)
 {
 return new SQLiteConnection("Data Source=" + file + ";PRAGMA journal_mode=WAL;"
 }
}
</code></pre>

The code is not tested, but I hope you can get the idea, so when you use it you can do like that.

<pre><code> SQLiteConnection conWal = new WALConnection(file);
 conWAL.Open();

 SQLiteConnection conNormal = new NormalConnection(file);
 conNormal.Open();
</code></pre>

blocks|key|123498|text|下面这行就是我要找的，非常感谢Turbot，它的答案包括了它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|123499|new+SQLiteConnection("Data+Source="+%2B+file+%2B+";PRAGMA+journal_mode=WAL;")|code-block|syntax|javascript|123500|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The line below is what I was looking for, many thanks to Turbot whose answer includes it:

<pre><code>new SQLiteConnection("Data Source=" + file + ";PRAGMA journal_mode=WAL;")
</code></pre>

blocks|key|123516|text|WAL模式的持久性|type|unstyled|depth|inlineStyleRanges|entityRanges|data|123517|与其他日志记录模式不同，PRAGMA+journal_mode=WAL是持久的。如果进程设置了WAL模式，然后关闭并重新打开数据库，则数据库将返回WAL模式。|123518|http://www.sqlite.org/wal.html|offset|length|123519|如果我理解正确的话，这意味着您可以为数据库设置一次WAL模式，不需要在每个连接上都设置它。|123520|您可以使用SQLite的命令行外壳来完成此操作：http://www.sqlite.org/sqlite.html|123521|entityMap|0|LINK|mutability|MUTABLE|url|1|http://www.sqlite.org/sqlite.html^0|0|0|0|U|0|0|0|O|X|1|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@$F|X|G|Y|1|Z]]|A|$]]|$1|H|3|I|5|6|7|10|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|11|8|@]|9|@$F|12|G|13|1|14]]|A|$]]|$1|L|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|E]]|S|$5|O|P|Q|A|$R|T]]]]

Persistence of WAL mode

"Unlike the other journaling modes, PRAGMA journal_mode=WAL is persistent. If a process sets WAL mode, then closes and reopens the database, the database will come back in WAL mode."

<a href="http://www.sqlite.org/wal.html" rel="nofollow">http://www.sqlite.org/wal.html</a>

If I understand it correctly, this means that you can set WAL mode for a database once, there's no need to set it on every connection.

You can do it with the command line shell for SQLite:
<a href="http://www.sqlite.org/sqlite.html" rel="nofollow">http://www.sqlite.org/sqlite.html</a>

In C#, how to open an SQLite connection <a href="http://www.sqlite.org/wal.html" rel="noreferrer">in WAL mode</a>?

Here is how I open in normal mode:

<pre><code>SQLiteConnection connection = new SQLiteConnection("Data Source=" + file);
connection.Open();
// (Perform my query)
</code></pre>

How to open SQLite connection in WAL mode

数据库

SQLite

在C#中，如何打开SQLite connection 下面是我如何在正常模式下打开：SQLiteConnection connection = new SQLiteConnection("Data Source=" + file);connection.Open();// (Perform my query)

问如何在WAL模式下打开SQLite连接
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在WAL模式下打开SQLite连接EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在WAL模式下打开SQLite连接
EN