示例#1
0
        //Update existing conatct 
        public void UpdateAccelData(AccelData accelData)
        {
            using (var dbConn = new SQLiteConnection(App.DB_PATH))
            {
                var existing = dbConn.Query<AccelData>("select * from AccelData where Id =" + accelData.Id).FirstOrDefault();
                if (existing != null)
                {
                    existing.X = accelData.X;
                    existing.Y = accelData.Y;
                    existing.Z = accelData.Z;

                    dbConn.RunInTransaction(() =>
                    {
                        dbConn.Update(existing);
                    });
                }
            }
        }
示例#2
0
 // Insert the new contact in the Contacts table. 
 public void Insert(AccelData newAccelData)
 {
     using (var dbConn = new SQLiteConnection(App.DB_PATH))
     {
         dbConn.RunInTransaction(() =>
         {
             dbConn.Insert(newAccelData);
         });
     }
 }