User-Profile-Image
hankin
  • 5
  • 首页
  • 技术-Study
    • Java
    • Php
    • WordPress
  • Enjoy-Life
  • 随拍-Photo
  • 分享-Share
  • 关于我
  • 分类
    • 随拍-Photo
    • Enjoy-Life
    • 技术-Study
    • 所有
    • 分享-Share
    • Java
    • Wordpress
    • Php
    • SQL Server
    • Linux
  • 页面
    • 首页
    • 学习日志
    • 生活日记
    • 随手拍拍
    • 关于我
  • 友链
    • 百度一下
    • 我爱水煮鱼
    • Jay's Notes
    • 淮城一只猫
    • 雨林寒舍
    • 不败君
    • 广告联盟
    • hankin
    • Tengine
    • 寥寥尘事 尘事固已矣,秉意终不迁。
    • 友人C
    • Typecho
    • jokeWorld
    • 蓝洛水深
    • 身边的大佬
    • Duilib
    • Runoob
    • Hank
Help?

Please contact us on our email for need any support

Support
    首页   ›   技术-Study   ›   SQL Server   ›   正文
SQL Server

SQLite数据库连接方式

2018-10-11 16:53:37
650  0 1

SQLite数据库连接方式

 

SQLite.NET

Type:    .NET Framework Class Library

Usage:  System.Data.SQLite.SQLiteConnection

Basic

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

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

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

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;

 

https://blog.csdn.net/ZF101201/article/details/5626365

评论 (0)

点击这里取消回复。

欢迎您 游客  

近期文章
  • Docsify 3分钟搭建博客
  • electron -v 全局安装,报错到晕厥
  • Electron-vue初始化项目时候报错:Command vue init requires a global addon to be installed.
  • 电脑重启后Visual Studio Code的快捷方式不存在?
  • 搜狗浏览器提示:您要访问的网站包含大量违法或违规内容
标签
0x800706be 18456 Apache bbr CDN CentOS command not found Dubbo GCE GCP google Google Cloud Platform IDEA K2 Memcached microsoft sql native client Mysql nano ODBC PB PHP phpstudy Powerbuilder Python shiro SQL2008 SQL Server Sqlite sqlite_master Sql server 2008 R2 sqlstate=08001 SSL ssr SyncPragma table thymeleaf Wordpress zookeeper 中石化,加油卡,百度地图 字段 客户端不支持加密 幽默 数据库 正则表达式 登录失败 腾讯CDN
Copyright © 2023 网站备案号: 苏ICP备18047535号
smarty_hankin 主题. Designed by hankin
主页
页面
  • 首页
  • 学习日志
  • 生活日记
  • 随手拍拍
  • 关于我
博主
_陈默默 管理员
人生就是:定性,知事,选梦,遇人,择城,终老。
125 文章 1 评论 74594 浏览
测试
测试