Mobile

super.setID("bla_bla_bla");

SELECT last_insert_rowid

string query = "select last_insert_rowid() as id from myTable";

using (var db = new SQLite.SQLiteConnection(System.IO.Path.Combine(ApplicationData.Current.LocalFolder.Path, "SM.db"), true))
{
               
                
   SQLite.SQLiteCommand cmd = new SQLite.SQLiteCommand(db);
   var result = cmd.ExecuteNonQuery();
}

SQLite.SQLiteException: Misuse

private int GetLastRowId(SQLLite.SQLLiteConnection connection)
{
  SQLLite.SQLLiteCommand cmd = new (connection);
  cmd.CommandText = "SELECT last_insert_rowid";
  object rowId = cmd.ExecuteScalar();
  return Convert.ToInt32(rowId);
}

Cursor cursor = getReadableDatabase().
  rawQuery("select * from todo where _id = ?", new String[] { id });

public partial class App : Application
   {
       public static IsolatedStorageSettings myappsettings = IsolatedStorageSettings.ApplicationSettings;
       private string dbName = "SM.db";
       public const string ConnectionString = @"isostore:/SM.db";
       private string dBPath = string.Empty;
       public static SQLiteAsyncConnection Connection { get; set; }
       public string DBPath
       {
           get
           { return dBPath; }

           set
           {
               if (dBPath == value)
               { return; }

               dBPath = value;
           }
       }