public List <User> AddUsersFromExcel() { List <User> users = new List <User>(); for (int i = 0; i < listData.Count; i++) { ExelData exelData = listData.ElementAt(i); User user = new User() { Username = exelData.Name + " " + exelData.Surname, MemberID = exelData.UserId + "" }; if (!UserExist(users, user)) { users.Add(user); } } _context.AddRange(users); _context.SaveChanges(); return(users); }