SQLite数据库连接字串
来源:互联网 发布:sql 查询表中重复记录 编辑:程序博客网 时间:2024/05/29 12:03
SQLite数据库连接方式
http://blog.sina.com.cn/s/blog_5758bd010101k1wb.html
SQLite.NET
Type:
Usage:
Basic
Data Source=filename;Version=3;
Version 2 is not supported by this class library.
Data Source=filename;Version=3;UseUTF16Encoding=True;
Data Source=filename;Version=3;Password=myPassword;
Data Source=filename;Version=3;Legacy Format=True;
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;
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;
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;
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;
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
Standard
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
Data Source=mydb.db;Version=3;New=True;
Data Source=mydb.db;Version=3;Compress=True;
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
Standard
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;
- SQLite数据库连接字串
- 数据库连接字串
- sybase 数据库连接字串
- 数据库连接字串详解
- 数据库连接字串大全
- 快速获取数据库连接字串
- 快速获取数据库连接字串
- sqlite数据库连接
- 利用VS2008生成数据库连接字串
- SQLite数据库连接方式
- SQLite数据库连接字符串.net
- SQLite数据库连接字符串
- SQLite数据库连接字符串
- 关于Sqlite数据库连接Android
- sqlite关闭数据库连接
- sqlite关闭数据库连接
- C#下Sqlite数据库连接类
- VB.net+SQLite 轻量级数据库连接
- Pat(Advanced Level)Practice--1024(Palindromic Number)
- Google首席软件工程师Joshua Bloch谈如何设计一款优秀的API【转载】
- Linux下Weblogic集群配置初步 -----此文为转载过来的
- android资源网址大全
- memset函数使用详解
- SQLite数据库连接字串
- 动态添加css
- 锁存器和自旋锁(Latch&Spinlock)----Latch类型及模式
- android获得图的总结!!
- linux下如何用c语言调用shell命令
- 解决android大型项目的 Java heap space的问题
- 由硬盘故障引起的一系列血案
- strstr与strch区别
- 学习Javascript闭包(Closure)