How to Use SQLite with ADO.NET

In this article I will explain how to use SQLite With ADO.NET.
  • 1891

Introduction

It is a .NET Framework Class Library provided by
SQLite.
 

Standard

Data Source=mydb.db;Version=3;


Create database

Data Source=mydb.db;Version=3;New=True;

 

Database Using compression

Data Source=mydb.db;Version=3;Compress=True;

 

Specifying Cache Size in Database

Data Source=mydb.db;Version=3;Cache Size=3000;


You may also want to read these related articles :
here

Ask Your Question 

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

Programming Answer here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.