SQL CE write operation

Question

Hi,

I am using MS SQL CE in a .NET desktop application. My application contains multiple threads which write to the database.

I am having some issues in the write operations from these multiple threads. I am sure this is due to a synchronization issue and am looking at two solutions - Mutex or separate Process but do not know which one is better.

Am I right by saying that write operations in SQL CE are transactional only if they occur in separate processes and not within threads in the same process?

Is is better to mutex the write operation or start any write operation on a separate process using the "Process" class provided by .NET?

Please advise.

Thanks in advance,

Subbu