question

DavidNelson-7870 avatar image
0 Votes"
DavidNelson-7870 asked ·

Microsoft.Data.Sqlite Error SQLITE 14

Error SQLITE 14
connection contains only "BBMP.db" and not the address-of

Working version uses({SqlitePCL.sqlite3}Server Version"3.26.0")

Non-Working version uses({SqlitePCL.sqlite3}Server Version"3.28.0")

     protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
     {
         var connectionStringBuilder = new SqliteConnectionStringBuilder { DataSource = "BBMP.db" };

         var connectionString = connectionStringBuilder.ToString();
         var connection = new SqliteConnection(connectionString);

         optionsBuilder.UseSqlite("Data Source=BBMP.db");

         connection.Open();
         string bbmcCommand = "CREATE TABLE IF NOT EXISTS " +
                 "BBMPCommands(Id INTEGER PRIMARY KEY AUTOINCREMENT, " +
                 "CommandId Integer NOT NULL, " +
                 "CommandImage NVARCHAR(50) NOT NULL, " +
                 "CommandName NVARCHAR(50) NOT NULL)";
         SqliteCommand createCmd = new SqliteCommand(bbmpCommand, connection);
         createCmd.ExecuteReader();

}
How do I get sqlite 3.26.0 into Non-Working program version?

windows-uwp-xaml
· 2
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, Did you create a UWP application? If so, please provide the minimum system version of the app you created. Also, please resubmit your code block, some characters are hard to read after being encoded

0 Votes 0 · ·

Hello, if you have other questions, please feel free to ask.

0 Votes 0 · ·

0 Answers