I've created a .NET Standard 2.0 class library project that works fine when referenced by a WPF App (.NET Framework 4.8) project. But when the same library is referenced by a MS Office VSTO Project (also using .NET Framework 4.8), I get the following error on the code line shown below:
Remarks:
VS2019, Windows20 Pro, Microsoft.Data.Sqlite and following example from same link.WPF app.SQLitePCLRaw.core package (as mentioned in the error) but still the same error. Although, I think I should not have to install this package since I did not have to do it with WPF app.MySQLiteDb.db file reside in the bin\Debug folder of VSTO as well as WPF folder. So, that should probably not be an issueError:
FileLoadException: Could not load file or assembly 'SQLitePCLRaw.core, Version=2.0.2.669, Culture=neutral, PublicKeyToken=1488e028ca7ab535' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
Code [error occurs at line using (SqliteConnection db = ....):
string SQLiteDbpath = System.IO.Path.Combine(GetAppInstalPath, "MySQLiteDb.db");
using (SqliteConnection db = new SqliteConnection($"Filename={SQLiteDbpath}"))
{
db.Open();
using (SqliteCommand insertCommand = new SqliteCommand())
{
......
insertCommand.ExecuteNonQuery();
}
}
FileLoadException: Could not load file or assembly 'SQLitePCLRaw.core, Version=2.0.2.669, Culture=neutral, PublicKeyToken=1488e028ca7ab535' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
You need to include the missed file (SQLitePCLRaw.core) to the folder with the add-in files.
User contributions licensed under CC BY-SA 3.0