您可以通过使用 SQL Server Compact 3.5 的 Microsoft .NET Compact Framework 数据提供程序，显式指定临时数据库的位置和大小。若要进行此操作，请将 temp file directory 和 temp file max size 属性添加到连接字符串中，如下所示：
"temp file directory = temp_database_location; temp file max size=128;"
.gif) 注意 |
|---|
为临时数据库指定的位置必须已经存在。 |
示例
下面的示例显示如何将临时数据库位置传递到 SqlCeConnection 对象的连接字符串中：
SqlCeConnection conn = new SqlCeConnection();
conn.ConnectionString = @"Persist Security Info = False;
Temp File Directory = '\TempDB\'; Temp File Max Size = 256;
Data Source = 'SalesData.sdf';
Password = '<enterStrongPasswordHere>'; File Mode = 'shared read';
Max Database Size = 256; Max Buffer Size = 1024";
conn.Open();
Dim conn As New SqlCeConnection()
conn.ConnectionString = "Persist Security Info = False;" & _
"Temp File Directory = '\TempDB\'; Temp File Max Size = 256;" & _
"Data Source = 'SalesData.sdf';" & _
"Password = '<enterStrongPasswordHere>'; File Mode = 'shared read';" & _
"Max Database Size = 256; Max Buffer Size = 1024"
conn.Open()