Visualstudio2019 UWP C# Microsoft.Data.Sqlite (Error code Sqlite 14 on open)

  • Thread starter Thread starter David.Nelson
  • Start date Start date
D

David.Nelson

Guest
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?

Continue reading...
 
Back
Top