Skip to main content

Posts

Showing posts from February, 2015

Using SQLite in .NET with Visual Studio 2013

SQLite is a software library that implements a self-contained, serverless, zero- configuration, transactional SQL database engine. SQLite is a popular choice as embedded database for local/client storage. In order to use SQLite in your .NET application, you can run following command in Visual Studio 2013 Package Manager Console. PM> Install-Package System.Data.SQLite  Once the package has been successfully installed, your project will have proper reference to SQLite dll. In the class you would like to use SQLite, add following "using" statement. using System.Data.SQLite; Here is the sample code that uses SQLite: using System; using System.Collections.Generic; using System.Data; using System.Data.SQLite; using System.Linq; using System.Text; namespace DataAccessLayer {     public class SqlLiteHelper     {         public static int ExecuteNonQuery( string strConnectionString, string strSqlCommand, SQLiteParameter [] sqlParams)         {