How to Use Basics Of Sqlite.Net

In this article I explain you Basics About Sqlite.
  • 1876

Introduction

SQLite is a small, fast and embeddable database where the database engine and the interface are combined into a single library. It also has the ability to store all the data in a single file.

Code in VB.NET

Imports System.Data.SQLite
Dim myConnection As SQLiteConnection = New SQLiteConnection;();
myConnection.ConnectionString = myConnectionString
myConnection.Open()
//execute queries, etc
myConnection.Close()

Code in c#

using System.Data.SQLite;
SQLiteConnection myConnection = new SQLiteConnection;();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
//execute queries, etc
myConnection.Close();


Basic

Data Source=filename;Version=3;

Note-Version 2 is not supported by this class library.

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.