Hi,
I'm hoping doing all right to get technical support. :)
I have a question to the System.Data.SQLite in action with the .Net
TransactionScope.
In the SQLite documentation is written that the default behavior of a
transaction in case of an error is
"ABORT". In documentation is also writen that "prior SQL statements within the
same transaction are preserved and the transaction remains active".
In my case using a transaction does not show this behaves. To be little more
clear here some example code:
using (dataGroupDBEntities context = new
dataGroupDBEntities(this.GetDataGroupConnection(cachedSensor.Logger.DataStorage
as FileBasedDataStorage)))
{
using (TransactionScope transaction = new
TransactionScope())
{
foreach (SensorValuePair data in sensorData)
{
// create sensor data
SensorData newSensorData = new SensorData
{
TimeStamp = data.Timestamp,
SensorID = cachedSensor.SensorID,
};
// save to DB
context.AddObject("SensorData", newSensorData);
}
try
{
context.SaveChanges(SaveOptions.None);
}
catch (Exception)
{
throw;
}
finally
{
transaction.Complete();
context.AcceptAllChanges();
}
}
}
In this example I added 10 objects to the context and I know that object #5
raises a PrimaryKey (or unique) Exception.
What I read from the SQLite documentation I understand that object #6 till
object #10 will be also add to the database.
But this never happens. :( Can you help me?
Regards
Steffen Mangold
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
