转载 2010年05月26日 20:05:00




Type:    .NET Framework Class Library

Usage:  System.Data.SQLite.SQLiteConnection


Data Source=filename;Version=3;

Version 2 is not supported by this class library.

 Using UTF16

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

Connection pooling is not enabled by default. Use the following parameters to control the connection pooling mechanism.

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;

The default value is ISO8601 which activates the use of the ISO8601 datetime format


Store GUID as text

Normally, GUIDs are stored in a binary format. Use this connection string to store GUIDs as text.

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

Note that storing GUIDs as text uses more space in the database.


Specify cache size

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

The Cache Size value measured in bytes


Specify page size

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

The Page Size value measured in bytes


Disable enlistment in distributed transactions

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


 Disable enlistment in distributed transactions

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


Disable create database behaviour

If the database file doesn't exist, the default behaviour is to create a new file. Use the following parameter to raise an error instead of creating a new database file.

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

  Limit the size of database

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

The Max Page Count is measured in pages. This parameter limits the maximum number of pages of the database.


Disable the Journal File

This one disables the rollback journal entirely.

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


Persist the Journal File

This one blanks and leaves the journal file on disk after a commit. Default behaviour is to delete the Journal File after each commit.

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


 Controling file flushing

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

Full specifies a full flush to take action after each write. Normal is the default value. Off means that the underlying OS flushes I/O's.

2.Finisar.SQLite ADO.NET Data Provider


Data Source=mydb.db;Version=3;

The "Version" key can take value "2" for SQLite 2.x (default) or value "3" for SQLite 3.x

 Create a new database

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

  Using compression

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

 Specifying Cache Size

The Cache Size value represents the amount of data pages that are held in memory. Try increase this value for speed improvements but don't forget to keep track of the applications memory usage.

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


3.SQLite3 ODBC Driver


DRIVER=SQLite3 ODBC Driver;Database=mydb.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;


.NET Framework Data Provider for ODBC

Bridging to SQLite3 ODBC Driver

This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.

DRIVER=SQLite3 ODBC Driver;Database=mydb.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;


        经过一段时间的调试,C/S架构的ODBC 驱动程序终于调试成功。现在,在Windows上可以使用该驱动连接Linux或windows上的sqlite server。在linux上也可以...
  • lbs_263
  • lbs_263
  • 2008年06月21日 21:11
  • 8156


  • xuzhimin1991
  • xuzhimin1991
  • 2017年03月09日 10:50
  • 865


报错Note: Some input files use or override a deprecated API. Note: Recompile with -Xlint:deprecation f...
  • zhongchongwen_001
  • zhongchongwen_001
  • 2016年03月16日 10:54
  • 687


  • 2012年01月03日 18:44
  • 16.07MB
  • 下载

C# 使用SQLite数据库 之 读写数据库

读写数据库并在窗体(Form)中显示其数据,其方式为: 读: Database(SQLite) -> DataAdapter -> DataSet -> DataGridView ...
  • zhenyongyuan123
  • zhenyongyuan123
  • 2012年04月12日 09:13
  • 7970


  • mimi00x
  • mimi00x
  • 2010年02月05日 17:56
  • 1001

powerbuilder 与sqlite3数据库

今天要使用powerbuilder 读取医保日志 ,于是写了一个database.dll文件,用于访问sqlite3数据库。 database.dll这个文件使用万能vc++2005编绎,源码:w...
  • aasmfox
  • aasmfox
  • 2015年08月01日 23:00
  • 1402

PowerBuilder9.0 调用sqlite3数据库

  • 2012年09月20日 21:38
  • 9KB
  • 下载

PowerBuilder9.0 调用sqlite3数据库

SQLite3数据库是一个好东东。在C语言下调用很方便。 PB在数据库操作方面是非常强的。效率高。实在是上班混工资的必备工具。 现在想学学PB方面的知识,在PB方面,由于不熟悉,不知道函数如何声明...
  • aasmfox
  • aasmfox
  • 2012年09月20日 21:32
  • 3043


  • 2010年10月13日 16:26
  • 6.89MB
  • 下载