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);
}
