I'm using a device that has android v2.2 in it. Is the following code
supported on it?
I need sqlite3 support on it (basically database transactions). 

I'm badly stuck. Please help!!!

using (SqliteConnection conn = new SqliteConnection("Data Source="   dbPath  
";Version=3"))            
{                
    using (SqliteTransaction txn = conn.BeginTransaction())                
    {                    
        try                    
        {                        
            executeInsertWithContext(txn);                        
            executeUpdateWithContext(txn);                        
            txn.Commit();                    
        }                    
        catch (Exception e)                    
        {                        
            txn.Rollback();                        
            string x = e.Message;                    
        }                
    }                
    conn.Close();            
}

{System.InvalidOperationException: Operation is not valid due to the current
state of the object
  at Mono.Data.Sqlite.SqliteConnection.BeginDbTransaction (IsolationLevel
isolationLevel) [0x0000c] in
/home/jon/Development/xamarin/mono/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/SQLiteConnection.cs:427
 
  at Mono.Data.Sqlite.SqliteConnection.BeginTransaction () [0x00000] in
/home/jon/Development/xamarin/mono/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/SQLiteConnection.cs:416
 
  at (wrapper remoting-invoke-with-check)
Mono.Data.Sqlite.SqliteConnection:BeginTransaction ()
  at Pearson.MonoAndroid.Prototype.SqliteApp.Registration.executeWithContext
(System.String dbPath) [0x00018] in
D:\Venkwork\myTests\MonoSqliteApp\Registration.cs:195 
  at
Pearson.MonoAndroid.Prototype.SqliteApp.Registration+<>c__DisplayClass1.<OnCreate>b__0
(System.Object , System.EventArgs ) [0x000c1] in
D:\Venkwork\myTests\MonoSqliteApp\Registration.cs:62 }

--
View this message in context: 
http://mono-for-android.1047100.n5.nabble.com/SqliteTransaction-tp5088668p5088668.html
Sent from the Mono for Android mailing list archive at Nabble.com.
_______________________________________________
Monodroid mailing list
[email protected]

UNSUBSCRIBE INFORMATION:
http://lists.ximian.com/mailman/listinfo/monodroid

Reply via email to