http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660And now I feel like a total idiot. Thanks guys! http://ayende.com/3240/sql-ce-transaction-handling#comment9http://ayende.com/3240/sql-ce-transaction-handling#comment9Mon, 31 Mar 2008 22:15:18 GMTI have added (see Rick's note) command.Transaction = tx and everything works as expected. Read is waiting for writes to complete until timeout expires. http://ayende.com/3240/sql-ce-transaction-handling#comment8http://ayende.com/3240/sql-ce-transaction-handling#comment8Mon, 31 Mar 2008 22:05:42 GMTThe thread reading shouldn't see the records that are being written until the write transaction is committed, because it's operating on a different connection. http://ayende.com/3240/sql-ce-transaction-handling#comment7http://ayende.com/3240/sql-ce-transaction-handling#comment7Mon, 31 Mar 2008 20:28:23 GMTLet's summarize it as: SqlCE is broken at so many levels. ;) I mean: in 3.5 they introduced named parameter binding, but ... if you now send a query with anonymous parameters ("?") which works in 3.1, it might not work due to wrong order of binding in CE 3.5.... http://ayende.com/3240/sql-ce-transaction-handling#comment6http://ayende.com/3240/sql-ce-transaction-handling#comment6Mon, 31 Mar 2008 20:18:13 GMTWhat!? It doesn't support Serializable? That is really insane... :-O --larsw http://ayende.com/3240/sql-ce-transaction-handling#comment5http://ayende.com/3240/sql-ce-transaction-handling#comment5Mon, 31 Mar 2008 19:38:09 GMTYou are correct, but still, this was surprising. http://ayende.com/3240/sql-ce-transaction-handling#comment4http://ayende.com/3240/sql-ce-transaction-handling#comment4Mon, 31 Mar 2008 18:08:56 GMTIt looks like you have a extra Console.WriteLine("Wrote item") in the ReadReadFromDB function that is misleading. http://ayende.com/3240/sql-ce-transaction-handling#comment3http://ayende.com/3240/sql-ce-transaction-handling#comment3Mon, 31 Mar 2008 18:06:12 GMTNope. I checked, and it looks like SQL CE only supports ReadCommited, yuck! http://ayende.com/3240/sql-ce-transaction-handling#comment2http://ayende.com/3240/sql-ce-transaction-handling#comment2Mon, 31 Mar 2008 17:57:16 GMTYou never set the commands' transactions to the transactions you create. Could that be it? http://ayende.com/3240/sql-ce-transaction-handling#comment1http://ayende.com/3240/sql-ce-transaction-handling#comment1Mon, 31 Mar 2008 17:54:27 GMT