Compacting A SQL CE Database Programmatically In A ClickOnce Application

I'm trying to compact a SQL CE database programmatically. I've copied the code from MSDN, and it's fine as far as it goes, but there's a problem tying to compact a database in a ClickOnce application because you don't know the path to the database. You have to use the "|DataDirectory|" in your connection string to signify the path to the database. But when I try the file operations to replace the old database with the compacted version, I get an error message that the path "|DataDirectory|" is not valid. Here's the code:


SqlCeEngine engine = new SqlCeEngine("Data Source = " + src + "; Password =" + txtPassword.Text);

try

{


engine.Compact("Data Source = " + dest + "; Password =" + txtPassword.Text);

ShowMsg("Compacting...", MsgType.NoError);

}

catch (Exception ex)

{


MessageBox.Show("There was an error completing the operation: " + ex.Message);

}

engine.Dispose();

File.Delete(src);

File.Move(dest, src);



(dest is = src + ".tmp", i.e., a path to a tmp file to hold the database while compacting).

How do I locate the files to copy if I can't use "|DataDirectory|"?