return001 / sqlite.helper

A simple tool to help you manage SQLite databases using C#

SQLite.Helper

####Do you use SQLite with your C# projects?#### If yes then don't worry, SQLite.Helper is a class that aims to help you to manage a SQLite database.

####How to use?#### First, make sure that System.Data.SQLite.dll is on you system.

Add the DLL to your project references and use the code

using SQLite.Helper;

Then call the class to use it

SQLiteHelper sqlite = new SQLiteHelper("C:\database.db");

where C:\database.db is the path to your database.

Then just call the method that you need, like get a string

string StrValue = Convert.ToString(sqlite.Get("SELECT `something` FROM `thattable` WHERE `otherthing` = 10"));
int IntValue = Convert.ToInt32(sqlite.Get("SELECT `somethingelse` FROM `anothertable` WHERE `otherthing` = 10"));

You can check more information on the wiki.