+- Hack Forums (https://hackforums.net)
+-- Forum: Tech (https://hackforums.net/forumdisplay.php?fid=444)
+--- Forum: Coding (https://hackforums.net/forumdisplay.php?fid=151)
+---- Forum: Software Development (https://hackforums.net/forumdisplay.php?fid=118)
+---- Thread: [.NET] SQLite.cs with SQLiteConnection and SQLiteDataReader? (/showthread.php?tid=5929720)
SQLite.cs with SQLiteConnection and SQLiteDataReader? - Anon Scripter - Jan 15, 2019
Protable SQLite with SQLiteConnection and SQLiteDataReader?
Im working on a good project, but i cant have dependencies with it.
RE: SQLite.cs with SQLiteConnection and SQLiteDataReader? - +Haze - Jan 15, 2019
Why not use Entity Framework? That way you won't have to constantly worry about the under the hood of SQL for your project.
RE: SQLite.cs with SQLiteConnection and SQLiteDataReader? - itcorp - Jan 15, 2019
(Jan 15, 2019 12:40 AM)Anon Scripter Wrote: Protable SQLite with SQLiteConnection and SQLiteDataReader?Download the files https://www.mediafire.com/file/gn2an6keo9gifh1/SQLite.rar/file and add them as a reference in your project.
Im working on a good project, but i cant have dependencies with it.
And here are some examples of usage
c#
https://pastebin.com/raw/yeDH0JfJ
vb
https://pastebin.com/raw/V1NczE1f
RE: SQLite.cs with SQLiteConnection and SQLiteDataReader? - Delirium™ - Jan 16, 2019
(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.
RE: SQLite.cs with SQLiteConnection and SQLiteDataReader? - +Haze - Jan 16, 2019
(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.
RE: SQLite.cs with SQLiteConnection and SQLiteDataReader? - Delirium™ - Jan 19, 2019
(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.