Basic standards of SQLite.NET

In this article I will explain basic standards of SQLite.NET.
  • 1708

Introduction

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

Basic

Data Source=filename;Version=3;


Using UTF-16

Data Source=filename;Version=3;UseUTF16Encoding=True;

 

With password

Data Source=filename;Version=3;Password=myPassword;

 

Using the pre 3.3x database format

Data Source=filename;Version=3;Legacy Format=True;

 

With connection pooling

Data Source=filename;Version=3;Pooling=False;Max Pool Size=100;

 

Read only connection

Data Source=filename;Version=3;Read Only=True;

 

Using DateTime.Ticks as datetime format

Data Source=filename;Version=3;DateTimeFormat=Ticks;

 

Store GUID as text

Data Source=filename;Version=3;BinaryGUID=False;

 

Specify cache size

Data Source=filename;Version=3;Cache Size=2000;

 

Specify page size

Data Source=filename;Version=3;Page Size=1024;

 

Disable enlistment in distributed transactions

Data Source=filename;Version=3;Enlist=N;

 

Disable create database behaviour

Data Source=filename;Version=3;FailIfMissing=True;

 

Limit the size of database

Data Source=filename;Version=3;Max Page Count=5000;

 

Disable the Journal File

Data Source=filename;Version=3;Journal Mode=Off;

 

Persist the Journal File

Data Source=filename;Version=3;Journal Mode=Persist;


Controling file flushing

Data Source=filename;Version=3;Synchronous=Full;


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

© 2019 DotNetHeaven. All rights reserved.