//add a city public void add(string city) { var db = new CloudAssignDBLinqDataContext(); if (db.Places.FirstOrDefault(x => x.CityCountry == city) == null) { db.Places.InsertOnSubmit(new Place() { CityCountry = city }); db.SubmitChanges(); } }
//remove a city public void remove(string city) { var db = new CloudAssignDBLinqDataContext(); db.Places.DeleteOnSubmit(db.Places.FirstOrDefault(x=>x.CityCountry==city)); db.SubmitChanges(); }