I'm having problems with data loss on power failure. I already tried different methods to do a faster commit but there seems<br/> to be no sollution for this problem (data is written few times per second). The data has to be written within 200ms to harddisk. If this is<br/>impossible, may there be an option to get a response from SQL CE whenever the data has been written?
Here is a code sample which i use to write data into database:
using (DbTransaction tran = db.BeginTransaction())
using (DbCommand dc = db.GetCommand("InsertOption"))
DbParameter value = db.G
View Complete Post