Hi,
First off: Thanks for doing this and making it available for free. I appreciate it.
I get a failure when I try to execute context.SaveChanges() (using Entity Framework)
A little bit of background:
- I create a database
- connect to it via entity framework and sqlite ado.net provider.
- I cause a failure via a trigger (to work around the foreign key constraints issue)
- then try to execute an operation that would otherwise succeed (in this case, creating a new entity)
This is the failure:
Test method Tests.PrioritiesTests.PriorityBadProjectTest threw exception: System.Data.SQLite.SQLiteException: SQLite error
cannot rollback - no transaction is active.
Here is the stack trace:
System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
System.Data.SQLite.SQLiteDataReader.NextResult()
System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
System.Data.SQLite.SQLiteTransaction.IssueRollback(SQLiteConnection cnn)
System.Data.SQLite.SQLiteTransaction.Rollback()
System.Data.SQLite.SQLiteTransaction.Dispose(Boolean disposing)
System.Data.Common.DbTransaction.Dispose()
System.Data.EntityClient.EntityTransaction.Dispose(Boolean disposing)
System.Data.Common.DbTransaction.Dispose()
System.Data.Objects.ObjectContext.SaveChanges(Boolean acceptChangesDuringSave)
System.Data.Objects.ObjectContext.SaveChanges()
...