What is the difference if any between these two Lambda Expressions ? And the second one seems more compact should I always go for that ?
DataContext.Employee.Where(c=>c.id==check_id && c.username==user_name).Select(c=>c.Name).FirstOrDefault();
and
DataContext.Employee.FirstOrDefault(c=>c.id==check_id && c.username==user_name).Name;