public async Task<GeoLocationItem> InsertAsync(GeoLocationItem item) { var asyncConnect = new SQLiteAsyncConnection(DB_PATH); int insertedId = await asyncConnect.InsertAsync(item); item.Id = insertedId; return item; /*using (var dbConn = new SQLite.SQLiteConnection(DB_PATH)) { int insertedId = dbConn.Insert(item); item.Id = insertedId; return item; }*/ }
public GeoLocationItem Insert(GeoLocationItem item) { using (var dbConn = new SQLite.SQLiteConnection(DB_PATH)) { int insertedId = dbConn.Insert(item); item.Id = insertedId; return item; } }
public GeoLocationItem Update(GeoLocationItem item) { if( GetGeoLocationItem(item.Id) == null) throw new Exception("GeoLocation not found"); using (dbConn = new SQLiteConnection(DB_PATH)) { dbConn.Update(item); } return item; }