I'm thinking about using SQLite as my database for my winform projects (and possibly web projects as well). Does anyone have any experience with using these two technologies together that would care to share your experience? I've been using serialization but my apps break when I have a record set with more than 10,000 records.
SQLite and C# WinForms
- Thread starter DesignPattern
- Start date
There is an ADO adapter to use SQLite with C#, but the about page mentions it's had no updates since 2010, and that the creator is no longer an active contributor.
Also, you mention you're using serialization...I assume this means that key/value pair style retrieval is all you need? There are C# clients for Redis. Also, can't vouch for it, but there's a c# specific nosql project on Github called BinaryRage. The readme seems to indicate it's in use in large commercial environments.
Also, you mention you're using serialization...I assume this means that key/value pair style retrieval is all you need? There are C# clients for Redis. Also, can't vouch for it, but there's a c# specific nosql project on Github called BinaryRage. The readme seems to indicate it's in use in large commercial environments.
Using SQLite With C# - C# Tutorials | Dream.In.Code
I've been using this, it looks very promising and so far it's been very stable. Seems like this is the DB of choice for mobile apps. I'll report back what I find.
I've been using this, it looks very promising and so far it's been very stable. Seems like this is the DB of choice for mobile apps. I'll report back what I find.
Great to know, so far it's very robust and easy to use. It seems to be able to handle big datasets very well too.
I've made this transition over time and for 'Applications' that are distributed, I've been using SQLite 3. For me it's about the compatibility across devices without needing to install lots of extra DB stuff (that's intimidating to beginners).
Here's the library I use:
System.Data.SQLite: About
gtownfunk