public static void LoadFakesForPeople(MySqlConnection connection, IEnumerable <TVTPerson> people) { var command = connection.CreateCommand(); command.CommandText = "SELECT * FROM tvt_convert WHERE type = 'actor'"; var Reader = command.ExecuteReader(); try { while (Reader.Read()) { var oldValue = Reader.GetString("old"); var newValue = Reader.GetString("new"); var foundPeople = people.Where(x => x.FullName == oldValue); foreach (var person in foundPeople) { PersonConverter.ConvertFakeFullname(person, newValue); } foundPeople = people.Where(x => x.FakeFullName == " " && x.FullName.Contains(oldValue)); foreach (var person in foundPeople) { PersonConverter.ConvertFakeFullname(person, newValue); } } } finally { if (Reader != null && !Reader.IsClosed) { Reader.Close(); } } }