SQLite in C#? [Part 2]

Building off the previous tutorial  SQLite in C# [Part 1] we are going to get a little more in detail with SQLite and populate our database with some information that we can pull back out later.

Lets start off with inserting information into our database.  We will do this in a similar fashion as we did creating our database table.  By creating a query string, passing it to a SQLiteCommand, and then executing the command.

Continue reading “SQLite in C#? [Part 2]”

SQLite in C#? [Part 1]

I can’t tell you how many times I am working on an application that I want to store data in an organized fashion but I don’t want the dependency of an external server.  Maybe I want to be able to use the application offline?  Or maybe the device I am running it on doesn’t have the ability to hold a database server.

Enter the realm of SQLite.  I have used it extensively in the past with simple Python and PHP applications, but now I figured I’d give a good overview of using it with C# and .NET.

Continue reading “SQLite in C#? [Part 1]”