Given a set of entity ids, how can you efficiently delete the entities to which to ids represent, without first selecting the entity?
Here is some code, I am using now, but EF profiler is complaining at me for running N+1 queries:
var ids = GetSelectedIds();
foreach (var id in ids)
db.Workshops.DeleteObject(db.Workshops.Single(x => x.Id == id));
db.SaveChanges();
BindWorkshops();