Here my code: if (db.PressArticles.Count(pa => pa.Image.width == 255 && pa.ID == ArticleID) > 0) { PressArticle thisArticle = db.PressArticles.Where(pa => pa.Image.width == 255 && pa.ID == ArticleID).First(); Image delImage = db.Images.Where(i => i.ID == thisArticle.imageID).First(); db.Images.DeleteOnSubmit(delImage); db.SubmitChanges(); thisArticle.imageID = null; db.SubmitChanges(); } In my DBML file I have the following: PressArticle Image ID(Primary key) ID(Primary key) heading alt synopsis
Read More...