Is there any different in performance for the following 2 queries. I'm just wondering what is the better of the two:
var res1 = (from a in _ctx.DataContext.Actions
join e in _ctx.DataContext.Events on a.EventId equals e.EventId
select a).Single(a => a.ActionId == actionId);
or
var res2 = (from a in _ctx.DataContext.Actions
join e in _ctx.DataContext.Events on a.EventId equals e.EventId
where a.ActionId == actionId
select a).Single();