Specifying location of temp file using SQLSERVER.MOBILE.OLEDB.3.0

Connection string

This Microsoft.SQLSERVER.MOBILE.OLEDB.3.0 connection string can be used for connections to SQL Server Compact.

Set the directory for the temp file location using this connection string.

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=myPath\myData.sdf;
SSCE:Temp File Directory="\myTempDir\";