Which library for .Net Framework 4.8?
(1.1) Originally by Fletch (FBumpus) with edits by Stephan Beal (stephan) on 2022-06-14 21:37:29 from 1.0 [link] [source]
Everyone,
I'm brand new to SQLite, for the most part. I'm trying to get it working in an existing project I have that's written using .Net Framework 4.8.
The NuGet packages I'm finding seem to only target .Net standard. My question is, what package should I use for .Net 4.8, in order to perform ADO.Net-style commands similar to OleDbConnection, OleDbCommand, etc?
Or, should I be looking at a different way to accomplish this?
Thank you, Fletch
(2) By Simon Slavin (slavin) on 2022-06-14 21:19:01 in reply to 1.0 [source]
Please post again referring to your development chain in the title. The information you want is not basic, few of us use that platform, and you need specialists in it.
Something like "Which library for .Net Framework 4.8 ?" should attract the right kind of attention.
(3.1) By Stephan Beal (stephan) on 2022-06-14 21:38:21 edited from 3.0 in reply to 2 [link] [source]
Please post again referring to your development chain in the title.
No need to repost - the title has been changed.
(4) By Fletch (FBumpus) on 2022-06-16 12:27:39 in reply to 2 [link] [source]
Thank you!
Yeah, I'm guessing at this point that the answer is, "use something else." XD
(5) By mistachkin on 2022-06-16 14:37:15 in reply to 4 [link] [source]
Have you tried using the System.Data.SQLite NuGet package?
(6.2) By Chris Locke (chrisjlocke1) on 2022-06-20 18:03:53 edited from 6.1 in reply to 1.1 [link] [source]
I create VB.Net applications in both Framework 4.8 and .Net 6, and for both have had no issues using system.data.sqlite from here: https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
I've never come across a more confusing download link page, and always have to double-check which one I'm downloading.
About halfway down, download the "Precompiled Binaries for 64-bit Windows (.NET Framework 4.6)" (non bundle) and the 32bit flavour.
Then just plop three files with your application.
<bin>\App.dll (optional, managed-only application library assembly)
<bin>\System.Data.SQLite.dll (required, managed-only core assembly)
<bin>\x86\SQLite.Interop.dll (required, x86 native interop assembly)
<bin>\x64\SQLite.Interop.dll (required, x64 native interop assembly)Add a reference to the sqlite.dll and you're good to go. I think the nuget adds a bit more fluff and noise to the project, so I can give step-by-step example on a test project if that'll help.
(10) By Fletch (FBumpus) on 2022-06-20 17:42:01 in reply to 6.0 [link] [source]
This, indeed, worked well for me. Thank you!
(7) By Chris Locke (chrisjlocke1) on 2022-06-18 14:48:45 in reply to 1.1 [link] [source]
The directory structure bit hasn't displayed right. If you click 'source' then it shows a bit better.
(8) By Stephan Beal (stephan) on 2022-06-18 14:55:20 in reply to 7 [link] [source]
The directory structure bit hasn't displayed right. If you click 'source' then it shows a bit better.
Just FYI, you can now edit your own posts, so if you'll go back and wrap that block in triple-backticks it will display okay.
(9) By Chris Locke (chrisjlocke1) on 2022-06-18 15:32:35 in reply to 8 [link] [source]
Ooh, you're right. When I posted, it originally only showed 'delete' as an option - no edit. Thanks for the info. :)