Q:

How to download existing SqlCe Db and use in Windows phone

understand an existing SQlCe Db which has data in it can be copied into project and used later on. Now , I have a different approach. can I download the SqlCe Db with Data from a website into Wndows phone.
I use this : BackgroundTransferRequest

void Download()
{
    btr = new BackgroundTransferRequest(remoteVideoUri, localDownloadUri);
    btr.TransferPreferences = TransferPreferences.AllowCellularAndBattery;
    BackgroundTransferService.Add(btr);
    btr.TransferProgressChanged += new EventHandler(btr_TransferProgressChanged);
    btr.TransferStatusChanged += new EventHandler(btr_TransferStatusChanged);
}

Questions:

Where do I download it to IsolatedStorage?  to : @isostore?
Will override the existing SqlCe Db with the same name? or create it like  name(copy).sdf ?
I think these insert/Update/Delete SQL operation can be applied to it.
Is there a way to check the Filesize of SqlCe Db BEFORE downloading it?

Thanks

A:

1) All local paths for background transfers must be within the isolated storage for your application within a root directory named “/shared/transfers”.
2) I believe you will get an error if the download file already exists locally.
3) Not sure what your question is.
4) You can check the BackgroundTransferRequest.TotalBytesToReceive property although this relies on the content length header being provided by the server.  Also this isn't actually available until the download begins.  If you want find out the size before you do anything you will have to code that yourself.

