public static void AddFromTest() { List <Developer> devs = RandomThings.GetDevelopers().ToList(); var sqlSever = new SqlServerDbContext(); var rng = new Random(); foreach (var dev in devs) { if (sqlSever.Developers.Any(d => d.UserName == dev.UserName)) { } else { var devToAdd = new Developer(); devToAdd.UserName = dev.UserName; devToAdd.FirstName = dev.FirstName; devToAdd.LastName = dev.LastName; devToAdd.Age = dev.Age; devToAdd.isTeamLeader = dev.isTeamLeader; devToAdd.SpecialityId = rng.Next(1, 10); devToAdd.TeamId = rng.Next(1, 6); sqlSever.Developers.Add(devToAdd); } } sqlSever.SaveChanges(); }