Ownsight

?找回密码
?立即注册
搜索
热搜: 活动 交友 discuz
查看: 1286|回复: 1
打印 上一主题 下一主题

SQLite 连接 字符

[复制链接]

803

主题

903

帖子

3201

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
3201
跳转到指定楼层
楼主
发表于 2015-5-30 15:35:21 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
转自:http://www.connectionstrings.com/sqlite/
Basic
Data Source=c:\mydb.db;Version=3;
Version 2 is not supported by this class library.? ? ? ? SQLite
In-Memory Database
An SQLite database is normally stored on disk but the database can also be stored in memory. Read more about SQLite in-memory databases here.
Data Source=:memory:;Version=3;New=True;
SQLite
Using UTF16
Data Source=c:\mydb.db;Version=3;UseUTF16Encoding=True;
SQLite
With password
Data Source=c:\mydb.db;Version=3;Password=myPassword;
SQLite
Using the pre 3.3x database format
Data Source=c:\mydb.db;Version=3;Legacy Format=True;
SQLite
With connection pooling
Connection pooling is not enabled by default. Use the following parameters to control the connection pooling mechanism.
Data Source=c:\mydb.db;Version=3;Pooling=True;Max Pool Size=100;
SQLite
Read only connection
Data Source=c:\mydb.db;Version=3;Read Only=True;
SQLite
Using DateTime.Ticks as datetime format
Data Source=c:\mydb.db;Version=3;DateTimeFormat=Ticks;
The default value is ISO8601 which activates the use of the ISO8601 datetime format? ? ? ? SQLite
Store GUID as text
Normally, GUIDs are stored in a binary format. Use this connection string to store GUIDs as text.
Data Source=c:\mydb.db;Version=3;BinaryGUID=False;
Note that storing GUIDs as text uses more space in the database.? ? ? ? SQLite
Specify cache size
Data Source=c:\mydb.db;Version=3;Cache Size=2000;
The Cache Size value measured in bytes? ? ? ? SQLite
Specify page size
Data Source=c:\mydb.db;Version=3;Page Size=1024;
The Page Size value measured in bytes? ? ? ? SQLite
Disable enlistment in distributed transactions
Data Source=c:\mydb.db;Version=3;Enlist=N;
SQLite
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=c:\mydb.db;Version=3;FailIfMissing=True;
SQLite
Limit the size of database
Data Source=c:\mydb.db;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.? ? ? ? SQLite
Disable the Journal File
This one disables the rollback journal entirely.
Data Source=c:\mydb.db;Version=3;Journal Mode=Off;
SQLite
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=c:\mydb.db;Version=3;Journal Mode=Persist;
SQLite
Controling file flushing
Data Source=c:\mydb.db;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.? ? ? ? SQLite
? Problems connecting?? ?Get answer in the SQLite Q & A forum →
Finisar.SQLite ADO.NET Data Provider
Standard
Data Source=c:\mydb.db;Version=3;
The "Version" key can take value "2" for SQLite 2.x (default) or value "3" for SQLite 3.x? ? ? ? SQLite
SQLite Version 2.X
Data Source=c:\mydb.db;Version=2;
SQLite
Create a new database
Data Source=c:\mydb.db;Version=3;New=True;
SQLite
Using compression
Data Source=c:\mydb.db;Version=3;Compress=True;
SQLite
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=c:\mydb.db;Version=3;Cache Size=3000;
SQLite
UTF 8
Data Source=c:\mydb.db;Version=3;UTF8Encoding=True;
SQLite
UTF 16
Data Source=c:\mydb.db;Version=3;UTF16Encoding=True;
SQLite
SQLite3 ODBC Driver
Standard
DRIVER=SQLite3 ODBC Driver;Database=c:\mydb.db;LongNames=0;Timeout=1000;NoTXN=0;
SyncPragma=NORMAL;StepAPI=0;
SQLite
.NET Framework Data Provider for ODBC
Use an ODBC driver from .NET
Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;
See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.

803

主题

903

帖子

3201

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
3201
沙发
?楼主| 发表于 2015-5-30 16:54:22 | 只看该作者
转自:http://www.jb51.net/article/20707.htm
Sqlite是最近比较流行的数据库了,拥有比Access高效快速,易操作易实施。完全不需要在客户端进行任何的配置,只需要在站点中引用入DLL文件即可使用了。
实际运用中当我用SqliteAdmin以及SQLite Expert Professional 2软件新建Sqlite数据库的时候在ASP.NET中是无法运用的,老是报错:文件不是一个合法的数据库。后来采用一种方法,就是直接在ASP.NET里面利用引用入的DLL新建数据库就可以用了。

string datasource = "d:\\test.db"; //数据库文件的地址

System.Data.SQLite.SQLiteConnection.CreateFile(datasource); //产生文件

这样产生出的test.db就可以在asp.net中运用了,此时你即使用SqliteAdmin以及SQLite Expert Professional 2软件打开它在里面建表都不影响它的使用了。

对Sqlite的操作其实跟Access非常像的,只不过OleDB开头的都变成了SQLite而已…


.NET Framework Data Provider for ODBC

DRIVER=SQLite3 ODBC Driver; Database=mydb.db; LongNames=0; Timeout=1000; NoTXN=0;SyncPragma=NORMAL; StepAPI=0;
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.

SQLite3 ODBC Driver

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

SQLite.NET

Basic(基本的)
? ?? ?Data Source=filename;Version=3;
Using UTF16(使用UTF16编码)
? ?? ?Data Source=filename;Version=3;UseUTF16Encoding=True;
With password(带密码的)
? ?? ?Data Source=filename;Version=3;Password=myPassword;
Using the pre 3.3x database format(使用3.3x前数据库格式)
? ?? ?Data Source=filename;Version=3;Legacy Format=True;
Read only connection(只读连接)
? ?? ?Data Source=filename;Version=3;Read Only=True;
With connection pooling(设置连接池)
? ?? ?Data Source=filename;Version=3;Pooling=False;Max Pool Size=100;
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(把Guid作为文本存储,默认是Binary)
? ???Data Source=filename;Version=3;BinaryGUID=False;
? ?? ?如果把Guid作为文本存储需要更多的存储空间
Specify cache size(指定Cache大小)
? ?? ?Data Source=filename;Version=3;Cache Size=2000;
? ?? ?Cache Size 单位是字节
Specify page size(指定页大小)
? ?? ?Data Source=filename;Version=3;Page Size=1024;
? ?? ?Page Size 单位是字节
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;
? ?? ?The Max Page Count is measured in pages. This parameter limits the maximum number of pages of the database.
Disable the Journal File (禁用日志回滚)
? ?? ?Data Source=filename;Version=3;Journal Mode=Off;
? ?? ?This one disables the rollback journal entirely.
Persist the Journal File(持久)
? ?? ?Data Source=filename;Version=3;Journal Mode=Persist;
? ?? ?This one blanks and leaves the journal file on disk after a commit. Default behaviour is to delete the Journal File after each commit.
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.


您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表