public void Edit(LANDMARK landmark, LANDMARK_KNOWN_AS lka) { var results = from p in dBase.LANDMARKs join q in dBase.LANDMARK_KNOWN_AS on p.Landmark_ID equals q.Landmark_FK select new { p, q }; foreach (var item in results) { item.p.Landmark_Coordinates = landmark.Landmark_Coordinates; item.q.Known_As_Description = lka.Known_As_Description; } dBase.SaveChanges(); }
public void Add(LANDMARK_KNOWN_AS landmark) { dBase.LANDMARK_KNOWN_AS.Add(landmark); dBase.SaveChanges(); }
private void addReference(Placemark placemark, SharpKml.Dom.Point point, DbGeography coordinates) { LANDMARK landmark = new LANDMARK(); LANDMARK_KNOWN_AS knowAsLandmark; knowAsLandmark = new LANDMARK_KNOWN_AS(); knowAsLandmark.Known_As_Description = placemark.Name; landmark.Landmark_Coordinates = coordinates; knowAsLandmark.LANDMARK = landmark; knowAsLandmark.Known_As_ID = count = count + 1; DBLandmarkKnownAs db = new DBLandmarkKnownAs(context); db.Add(knowAsLandmark); if (placemark.Description != null) { string[] description = placemark.Description.Text.Split(';'); for (int i = 0; i < description.Count(); i++) { knowAsLandmark = new LANDMARK_KNOWN_AS(); knowAsLandmark.Known_As_Description = description[i]; landmark.Landmark_Coordinates = coordinates; knowAsLandmark.Known_As_ID = count = count + 1; knowAsLandmark.LANDMARK = landmark; db = new DBLandmarkKnownAs(context); db.Add(knowAsLandmark); } } }