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...
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...