I hate these three tables that. Two tables have a many to many relationship and as such it generates a third table.
I'm using Linq-to-SQL and in the .dbml file I've dragged all the folder there to the graphic surface.
Here is the method I'm using to delete an Area safely. Remember that documents are associated to an Area, so I can't just delete it and leave documents hanging.
ScansDataContext db = new ScansDataContext();
/// <summary>
/// Deletes an Area
object from the database along with all associations in the database.
/// </summary>
/// <param name="area">Area
object to save</param>
public void Delete(Area area)
{
db.DocumentAreaRelations.DeleteAllOnSubmit(area.DocumentAreaRelations);
db.Areas.DeleteOnSubmit(area);
db.SubmitChanges(System.Data.Linq.ConflictMode.FailOnFirstConflict);
}
