[mono-android] SqliteTransaction

[Jonathan Pryor]

On Dec 20, 2011, at 7:01 AM, Venky wrote:
> I'm using a device that has android v2.2 in it. Is the following code supported on it?

It should....

> using (SqliteConnection conn = new SqliteConnection("Data Source="   dbPath  ";Version=3"))            
> {                
>    using (SqliteTransaction txn = conn.BeginTransaction())

...

> {System.InvalidOperationException: Operation is not valid due to the current state of the object
>  at Mono.Data.Sqlite.SqliteConnection.BeginDbTransaction (IsolationLevel isolationLevel)


https://github.com/mono/mono/blob/mono-2-10/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/SQLiteConnection.cs#L426

It looks like you're forgetting a Open() call before you call BeginTransaction(). :-)

 - Jon