mce
April 18th, 2008, 03:47 AM
Anybody use sqlite for multiple write access? SQLite doesn't support multiple write access by itself, but according to sqlite web site, it is possible to do our own write sync using mutex. However i am not able to get this to work..., the database is throwing exception "Concurrent violation:..." whenever i try to do Update..
I am using sqlite ADO.net
m_mutex.WaitOne();
m_sqliteAdapter.Update(m_Dataset, "TableAnalog");
m_mutex.ReleaseMutex();
I am using sqlite ADO.net
m_mutex.WaitOne();
m_sqliteAdapter.Update(m_Dataset, "TableAnalog");
m_mutex.ReleaseMutex();