public User GetUser(string email) { using (var entities = new EazyWizyEntities()) { var result = entities.GetUser(email); return (from item in result select new User() { CreateDate = item.CreateDate, CreatedBy = item.CreatedBy, EmailID = item.EmailID, FirstName = item.FirstName, HashId = item.HashId, IsActive = item.IsActive, LastName = item.LastName, ModifiedBy = item.ModifiedBy, Password = item.Password, ModifiedDate = item.ModifiedDate, RoleID = item.RoleID, RoleName = item.RoleName, UserID = item.UserID }).SingleOrDefault(); } }