.net – Transactionscope not working on SQLite in Subsonic

subsonicvb.net

I have trouble using the transactionscope on SQLite, i am using the following code. Changes are still commited to the database while i don't call the ts.Complete() function.

Using ts As New System.Transactions.TransactionScope()  
  Using sharedConnectionScope As New SubSonic.SharedDbConnectionScope()
  ' Do your individual saves here' 
  If all OK      
    ts.Complete()   
  End Using
End Using

Best Answer

If I recall correctly, you're going to need to call BeginTransaction and EndTransaction somewhere in there to tell SQLite that you're entering and subsequently leaving a transaction block--if I recall correctly, wrapping a (using transaction As IDbCommand.BeginTransaction ()) around any transaction-based code is necessary (though I haven't done ADO.NET in a while).

Related Solutions

SQLite and SubSonic 3.0 Not Generating from T4 Template

You also need to add and then 'run custom tool' on the files Structs.tt and Context.tt

R – SubSonic 2.x Batch Query SQLite

SubSonic 2.x does have a method to perform batch saves.

Here is a sample:

var itemsToSaveCollection = new ItemCollection(); // Your collection type here

foreach (var xmlItem in xmlItems)
{
    var item = new Item(); // Your data model type here
    // Set item values from xml
    itemsToSaveCollection.Add(item);
}

itemsToSaveCollection.BatchSave();

Best Answer

Related Solutions

SQLite and SubSonic 3.0 Not Generating from T4 Template

R – SubSonic 2.x Batch Query SQLite

Related Topic