Connection error in Server Explorer in Visual Studio 2022 w/SQLite 1.0.118.0

[davecove]

Connection error in Server Explorer in Visual Studio 2022 w/SQLite 1.0.118.0

[ErikEJ]

Please share the error and the steps to get it and your VS version

[davecove]

Thank you for being so responsive!

The steps to reproduce are to follow the instructions in the EF6 workflow with SQLite DDEX provider guide.

[ErikEJ]

Looks like you missed the step to ensure the EF6 DbProvider is in GAC...

[davecove]

I saw that it wasn't in there and followed the special VS2022 special instructions from the guide:

VS 2022 Copy the entry to the 64 bit machince.config located in C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319\Config
and
Some users report that adding this to app.config solves some runtime issues.

One thing I noticed is that in the installer for 1.0.118.0, the dialog that offers the option to install the assemblies into the GAC is no longer shown in either the Full or Custom installation paths. I could use gacutil if I knew what dlls to install to the GAC.

[ErikEJ]

Maybe the SQLite team broke VS 2022 completely then.

[davecove]

Maybe... do you know what files I should add to the GAC manually?

[ErikEJ]

No, I do not, and you should never install stuff manually in the GAC.

Did you run sqlite-netFx46-setup-bundle-x64-2015-1.0.xxx.0.exe ??

[ErikEJ]

Maybe consider installing VS 2019 Community instead of all this pain?

[davecove]

Yes : sqlite-netFx46-setup-bundle-x64-2015-1.0.118.0.exe

I went back to VS2019 and it is working after running the setup bundle... not ideal, but hey, it works.