[数据库连接字符串] SQL Server 2005 Compact Edition 连接字符串

OLE DB, OleDbConnection (.NET)
标准
Provider= Microsoft.SQLSERVER.MOBILE.OLEDB.3.0; Data Source= myPath/myData.sdf;
如何指定一个SDF文件
Provider= Microsoft.SQLSERVER.MOBILE.OLEDB.3.0; Data Source= " + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "//MyData.sdf;
指定数据库的最大容量
Provider= Microsoft.SQLSERVER.MOBILE.OLEDB.3.0; Data Source= myPath/myData.sdf; SSCE:Max Database Size= 256;
指定最大缓存容量
Provider= Microsoft.SQLSERVER.MOBILE.OLEDB.3.0; Data Source= myPath/myData.sdf; SSCE:Max Buffer Size= 1024;
开启验证
Provider= Microsoft.SQLSERVER.MOBILE.OLEDB.3.0; Data Source= myPath/myData.sdf; SSCE:Encrypt Database= True;
指定最大的临时文件大小
Provider= Microsoft.SQLSERVER.MOBILE.OLEDB.3.0; Data Source= myPath/myData.sdf; SSCE:Temp File Max Size= 256;
指定零时文件的路径
Provider= Microsoft.SQLSERVER.MOBILE.OLEDB.3.0; Data Source= myPath/myData.sdf; SSCE:Temp File Directory= "/myTempDir/";
指定数据库的密码
Provider= Microsoft.SQLSERVER.MOBILE.OLEDB.3.0; Data Source= myPath/myData.sdf; SSCE:Database Password= 'myPassword';
SqlCeConnection (.NET)
标准
Data Source= MyData.sdf; Persist Security Info= False;
如何指定本地的SDF文件
Data Source= " + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "//MyData.sdf; Persist Security Info= False;
标准
Data Source= MyData.sdf; Persist Security Info= False;
指定最大数据库大小
Data Source= MyData.sdf; Max Database Size= 256; Persist Security Info= False;
指定最大缓存大小
Data Source= MyData.sdf; Max Buffer Size= 1024; Persist Security Info= False;
启用验证
Data Source= MyData.sdf; Encrypt Database= True; Password= myPassword; File Mode= shared read; Persist Security Info= False;
执行权限
Data Source= MyData.sdf; File Mode= Exclusive; Persist Security Info= False;
只读权限
Data Source= MyData.sdf; File Mode= Read Only; Persist Security Info= False;
执行但是可以以共享方式读取
Data Source= MyData.sdf; File Mode= Shared Read; Persist Security Info= False;
指定最大的零时文件大小
Data Source= MyData.sdf; Temp File Max Size= 256; Persist Security Info= False;