Installing in Visual Studio 2022
(1) By anonymous on 2022-03-14 19:11:44 [link] [source]
I understand that SQLite is mostly unsupported for Visual Studio. But obviously its still being developed to support new .Net platforms and other fixes. With that said, I am hoping that there is some information on how to install the .dll's in Visual Studio 2022. I actually got the System.Data.SQLite.dll working, but was not able to get the SQLite.Interop.dll to be recognized by VS. I understand that VS2022 is strictly 64bit, and that there are other changes in the use of a private registry. But has anyone made any headway with installing to the platform? Any plans to release a functioning solution, even if its officially unsupported?
(2) By Larry Brasfield (larrybr) on 2022-03-14 19:35:48 in reply to 1 [link] [source]
You can compile the SQLite library or its CLI shell in Visual Studio, as well as applications that use the library. If you want to see what compile and link options you might set in the IDE, consult the project's Makefile.msc file.
I am familiar with both Visual Studio and SQLite, yet I have no idea what "install the .dll's in Visual Studio" even means, let alone how to accomplish it.
Your understanding regarding "VS2022 is strictly 64bit" is contrary to mine. The 32-bit toolset works perfectly well. However, I do not know what would be the effect of "installing to the platform".
Any plans to release a functioning solution, even if its officially unsupported?
The SQLite releases are quite functional when built with Microsoft's compiler and associated tools, and have been for years. So there are no plans such as you suggest beyond continuing that past practice.
If you mean to ask about plans to publish VS IDE specific build files, there are none, nor are any needed. Just add the sources to your application project in the same way you add your own. It's not hard.
(3) By Keith Medcalf (kmedcalf) on 2022-03-14 20:01:16 in reply to 2 [link] [source]
I believe the OP was referring to the ADO implementation of SQLite3 ... not SQLite3 itself. The clue is in the mention of the use of shims to fit SQLite3 into the Mocrosoft Deprecation System.
(5) By anonymous on 2022-03-16 16:07:05 in reply to 2 [link] [source]
Thank you for the reply, I am referring to adding references into visual studio, to SQLite. The process is explained here....https://www.webucator.com/article/how-to-add-references-to-your-visual-studio-projec/
As I stated I was able to successfully add one reference, but the SQLiteInterop.dll would not load for some reason. I am not sure if it is a compatibility issue with VS2022 or I somehow have the wrong the file.
(4) By mistachkin on 2022-03-14 21:22:24 in reply to 1 [link] [source]
Please use the NuGet packages, e.g.:
https://www.nuget.org/packages/System.Data.SQLite.Core/
(6) By anonymous on 2022-03-16 16:24:58 in reply to 4 [link] [source]
Hello, I tried the nuget install, same issue as described.
(7) By mistachkin on 2022-03-16 18:04:55 in reply to 6 [link] [source]
I'm not clear on what issue you are experiencing. Maybe you are talking about the design-time components for Visual Studio? If that is the case, they are completely unsupported and are completely non-functional for any version of Visual Studio after 2015.
(8) By anonymous on 2022-03-16 18:21:19 in reply to 6 [link] [source]
FYI, after the Nuget install this is the error I am receiving... (Fully-specified)LOG: Appbase = file:///C:/Users/#@$%^@#$&^^/source/repos/#@$%^@#$&^^/bin/Debug/LOG: Initial PrivatePath = NULLCalling assembly : #@$%^@#$&^^Version=1.0.0.0, Culture=neutral, PublicKeyToken=null.===LOG: This bind starts in default load context.LOG: Using application configuration file: C:Users#@$%^@#$&^^sourcerepos#@$%^@#$&^^binDebug#@$%^@#$&^^.exe.ConfigLOG: Using host configuration file: LOG: Using machine configuration file from C:WindowsMicrosoft.NETFrameworkv4.0.30319configmachine.config.LOG: Post-policy reference: System.Data.SQLite, Version=1.0.115.5, Culture=neutral, PublicKeyToken=db937bc2d44ff139LOG: Attempting download of new URL file:///C:/Users/#@$%^@#$&^^/source/repos/#@$%^@#$&^^/bin/Debug/System.Data.SQLite.DLL.ERR: Failed to complete setup of assembly (hr = 0x8007000b). Probing terminated.
(9) By mistachkin on 2022-03-16 19:04:56 in reply to 8 [link] [source]
Is the sub-string "#@$%^@#$&^^" something you added here? Which NuGet package are you trying to install?
(10) By anonymous on 2022-03-18 17:04:50 in reply to 9 [link] [source]
I installed this Nuget package: System.Data.SQLite.x64 The VS project platform is set to x64 only.
This string "#@$%^@#$&^^", can be replaced the word "redacted".
(11) By mistachkin on 2022-03-18 17:52:48 in reply to 10 [link] [source]
Please don’t use that NuGet package, it’s deprecated. Instead, you should use the “System.Data.SQLite.Core” NuGet package.
(12) By anonymous on 2022-03-18 18:38:34 in reply to 9 [link] [source]
New error: Could not load file or assembly 'System.Data.SQLite.SEE.License, Version=1.0.115.5, Culture=neutral, PublicKeyToken=433d9874d0bb98c5' or one of its dependencies. The system cannot find the file specified.
(13) By mistachkin on 2022-03-19 17:13:50 in reply to 12 [link] [source]
Are you still using the “Password” connection string property?
(14) By anonymous on 2022-09-04 19:20:51 in reply to 13 [source]
Why are we getting this error can you elaborate, I'm also stuck here. Any solutions? Yes I'm also using password parameter, Shall I need to use encryption password provided by them?
(15) By mistachkin on 2022-09-05 15:58:39 in reply to 14 [link] [source]
Password provided by whom?