Specifying the maximum temp file size using SqlCeConnection
Connection string
This .NET Compact Framework Data Provider for SQL Server Mobile connection string can be used for connections to SQL Server Compact.
The maximum size of the temporary database file is by default 128 MB. Override this by using the following connection string.
Data Source=MyData.sdf;Temp File Max Size=256;Persist Security Info=False;