SQLite multiple threads
2018-01-11 15:07 Dorisoy 阅读(376) 评论(0) 编辑 收藏 举报const int loops = 1000; public void DatabaseThreadSafetyTest() { var backgroundThread = new Thread(new System.Threading.ThreadStart(() => { for (int i = 1; i <= loops; i++) { Console.WriteLine("Background thread loop " + i); using (var db = new SQLiteConnection(DbPath, SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.Create | SQLiteOpenFlags.SharedCache)) { db.Insert (new MyClass()); } } })); backgroundThread.Start(); for (int i = 1; i <= loops; i++) { Console.WriteLine("Main thread loop " + i); using (var db = new SQLiteConnection(DbPath, SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.Create | SQLiteOpenFlags.SharedCache)) { db.Insert (new MyClass()); } } }
using System; using System.Data.SQLite; using System.Threading.Tasks; namespace SQLiteTest { class Program { static void Main(string[] args) { var tasks = new Task[100]; for (int i = 0; i < 100; i++) { tasks[i] = new Task(new Program().WriteToDB); tasks[i].Start(); } foreach (var task in tasks) task.Wait(); } public void WriteToDB() { try { using (SQLiteConnection myconnection = new SQLiteConnection(@"Data Source=c:\123.db")) { myconnection.Open(); using (SQLiteTransaction mytransaction = myconnection.BeginTransaction()) { using (SQLiteCommand mycommand = new SQLiteCommand(myconnection)) { Guid id = Guid.NewGuid(); mycommand.CommandText = "INSERT INTO Categories(ID, Name) VALUES ('" + id.ToString() + "', '111')"; mycommand.ExecuteNonQuery(); mycommand.CommandText = "UPDATE Categories SET Name='222' WHERE ID='" + id.ToString() + "'"; mycommand.ExecuteNonQuery(); mycommand.CommandText = "DELETE FROM Categories WHERE ID='" + id.ToString() + "'"; mycommand.ExecuteNonQuery(); } mytransaction.Commit(); } } } catch (SQLiteException ex) { if (ex.ReturnCode == SQLiteErrorCode.Busy) Console.WriteLine("Database is locked by another process!"); } } } }
Xamarin