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.
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.








