Home Upgrade Search Memberlist Extras Hacker Tools Award Goals Help Wiki Contact

.NET 

SQLite.cs with SQLiteConnection and SQLiteDataReader?

Protable SQLite with SQLiteConnection and SQLiteDataReader?

Im working on a good project, but i cant have dependencies with it.
Why not use Entity Framework? That way you won't have to constantly worry about the under the hood of SQL for your project.
(Jan 15, 2019 12:40 AM)Anon Scripter Wrote:  Protable SQLite with SQLiteConnection and SQLiteDataReader?

Im working on a good project, but i cant have dependencies with it.
Download the files https://www.mediafire.com/file/gn2an6keo...e.rar/file and add them as a reference in your project.

And here are some examples of usage
c#
https://pastebin.com/raw/yeDH0JfJ

vb
https://pastebin.com/raw/V1NczE1f
buy me a coffee eth:0x88621A52aa5Eb3b6503628369687111810186c58
(Jan 15, 2019 03:00 PM)+Haze Wrote:  Why not use Entity Framework? That way you won't have to constantly worry about the under the hood of SQL for your project.

I'd go for Dapper or OrmLite instead. Quite better in terms of performance and as far as I am concerned, it's easier to setup for people to ORMs.

(Jan 15, 2019 12:40 AM)Anon Scripter Wrote:  Protable SQLite with SQLiteConnection and SQLiteDataReader?

Im working on a good project, but i cant have dependencies with it.

What do you mean can't have dependencies with it? The moment you include some portable SQLite library in your project, you have a dependency on it. If by no dependencies you meant you don't want to ship any DLLs with it, then you can either find some open source project and include the source code in yours (which I wouldn't recommend) or you can add the dependencies on your resources and load them dynamically on runtime.
(Jan 16, 2019 11:57 AM)Delirium™ Wrote:  I'd go for Dapper or OrmLite instead. Quite better in terms of performance and as far as I am concerned, it's easier to setup for people to ORMs.

Yeah, any ORM would be fine. I'm just against manually interacting with the database when ORMs exist.
(Jan 16, 2019 02:54 PM)+Haze Wrote:  Yeah, any ORM would be fine. I'm just against manually interacting with the database when ORMs exist.

I agree with you. I personally don't like Entity Framework due to its poor performance when compared to other ORMs (as various sources online say). However, Entity Framework Core looks like a huge improvement over the standard one.


Possibly Related Threads...
Thread / Author Replies Views Last Post
by iconiaSep 14, 2026 10:37 AM 4 136 Sep 14, 2026 10:37 AM
Last Post: iconia
[C] by 0x0SH3Aug 2, 2021 06:44 AM 1 153 Aug 2, 2021 06:44 AM
Last Post: NtCreateLife
[Shell] by LayersOSImodelOct 6, 2019 06:37 AM 9 325 Oct 6, 2019 06:37 AM
Last Post: is_nimda