public User GetUserByEmail(string email) { List<User> lstUsers = new List<User>(); UsersTableAdapter usersAdapter = new UsersTableAdapter(); PostAroundMeDataSet.UsersDataTable dtResult = usersAdapter.GetUserByEmail(email); lstUsers = UserTranslator(dtResult); return lstUsers.FirstOrDefault(); }