Click here to Skip to main content
15,887,746 members
Articles / Programming Languages / T-SQL

Using SQLite in C#/VB.Net

Rate me:
Please Sign up or sign in to vote.
4.93/5 (94 votes)
25 Jun 2018CPOL14 min read 284.3K   42.5K   242  
A quick guide to managing 100000'ish records efficiently with SQLite and C#/.Net.
In this article I'm doing this side-step to explain the basics of SQLite. I Create a Table in the SQLite File, Insert a Record into a Table, Read a Record from a Table. We'll also be looking at a SQLite Wrapper Class, Overwriting an existing Database File, Accessing a SQLite Database from Multiple Threads. The article also provides a sample application that describes a solution that can be used to write XML files from data stored in a relational database.

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Germany Germany
The Windows Presentation Foundation (WPF) and C# are among my favorites and so I developed Edi

and a few other projects on GitHub. I am normally an algorithms and structure type but WPF has such interesting UI sides that I cannot help myself but get into it.

https://de.linkedin.com/in/dirkbahle

Comments and Discussions