D 2011-09-11T15:37:19.540
J comment When\sa\stransaction\sis\srunning\sand\san\serror\soccurs,\sON\sCONFLICT\sclause\snot\srunning\sdefault.\sFor\sexample\swhen\sa\stransaction\swith\s100\srows\s(inserts)\sis\sexecuted\sand\srow\s50\sraise\sa\scontraint\sexception,\sall\srows\sabove\swill\snot\sbe\sexecuted.\r\n\r\nSQLITE\sdoku\swrites\sthat\s"but\schanges\scaused\sby\sprior\sSQL\sstatements\swithin\sthe\ssame\stransaction\sare\spreserved\sand\sthe\stransaction\sremains\sactive".\n\n<hr\s/><i>mistachkin\sadded\son\s2011-09-11\s13:09:52\sUTC:</i><br\s/>\nThis\sissue\sseems\sto\sinvolve\sthe\s.NET\sEntity\sFramework\sand\sI\sam\snot\san\sexpert\son\sthat\spackage;\showever,\sit\sseems\sthat\sthe\sTransactionScope\sclass\sis\snormally\sunnecessary\sunless\syou\shave\schanges\sthat\sspan\smultiple\sobject\scontexts\s(e.g.\smultiple\sSQLite\sdatabases),\ssee:\r\n\r\nhttp://stackoverflow.com/questions/794707/why-doesnt-transactionscope-work-with-entity-framework\r\n\n\n<hr\s/><i>mistachkin\sadded\son\s2011-09-11\s13:40:00\sUTC:</i><br\s/>\nRelated:\shttp://msdn.microsoft.com/en-us/library/bb738523.aspx\r\n\n\n<hr\s/><i>mistachkin\sadded\son\s2011-09-11\s13:42:27\sUTC:</i><br\s/>\nAlso,\sthere\sseems\sto\sbe\sa\sproblem\swith\sthe\sSQLiteConnection.EnlistTransaction\smethod\sthat\sprevents\sTransactionScope\sfrom\sworking\swith\san\sObjectContext\sif\sthe\scode\sinvolved\stries\sto\saccess\sthe\sdatabase\smore\sthan\sonce\sfrom\sinside\sthe\ssame\stransaction.\n\n<hr\s/><i>mistachkin\sadded\son\s2011-09-11\s15:36:54\sUTC:</i><br\s/>\nAn\sexperimental\sfix\sfor\sthis\sissue\sis\savailable\sin\scheck-in\s[f4e1038098],\swith\sunit\stests.\r\n\r\nWould\sit\sbe\spossible\sfor\syou\sto\stest\sthis\sfix\sin\syour\senvironment\sand\sreport\sback\swith\sthe\soutcome\sof\syour\stesting?
J subsystem Connection
K ccfa69fc3251fb3512e9f17eca7a4c8fab6302e1
U mistachkin
Z 20f40a52985aefb507a39b4571f3f77b
