How to set multiple PRAGMAs using SQLite.Net?
<p>After opening a connection to the database, I can set one PRAGMA, but the second one always fails.  How do I set these two PRAGMA's using SQLite.Net-PCL 3.1.1?  This is for a Universal Windows Platform app.</p>

<pre><code>    public static SQLiteConnection Open()
    {
        if (db == null)
        {
            var dbPath = Path.Combine(ApplicationData.Current.LocalFolder.Path, DatabaseFileName);
            db = new SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), dbPath);
            db.Execute("PRAGMA foreign_keys = ON");
            db.Execute("PRAGMA journal_mode = WAL");
        }
        return db;
    }
</code></pre>

<p>I get a "Row" exception from SQLite immediately after the second execute statement.</p>

<p><em>Requested Stack Trace:</em></p>

<ul>
<li>at SQLite.Net.SQLiteCommand.ExecuteNonQuery()</li>
<li>at SQLite.Net.SQLiteConnection.Execute(String query, Object[] args)</li>
<li>at SceneLocker.Models.DBConnection.Open()</li>
</ul>

<p>Edit: Adding a screenshot of the trapped exception:</p>

<p><a href="https://i.stack.imgur.com/v7EYL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/v7EYL.png" alt="Trapped Exception"></a></p>