public void ImportCSV(string file) { LINQtoSQLDataContext db = new LINQtoSQLDataContext(); var imported = ReadCSV(file); foreach (var input in imported) { Animal animal = new Animal(); Trait traits = new Trait(); Health health = new Health(); animal.name = input[0]; animal.breed = input[1]; animal.age = int.Parse(input[2]); animal.price = double.Parse(input[3]); animal.entryDate = DateTime.Now; animal.adopted = false; animal.type = input[4]; animal.gender = input[5]; traits.size = input[6]; traits.activityLevel = input[7]; traits.color = input[8]; health.receivedShots = true; health.foodConsumptionPerWeek = decimal.Parse(input[9]); db.Animals.InsertOnSubmit(animal); db.SubmitChanges(); traits.animalId = animal.animalId; health.animalId = animal.animalId; db.Traits.InsertOnSubmit(traits); db.Healths.InsertOnSubmit(health); Room roomForTransferAnimal = LocateCorrectRoomToAssignToNewAnimal(); UpdateRoomVariables(roomForTransferAnimal, animal.animalId, traits.size); db.SubmitChanges(); } Console.WriteLine("The file of new animals was successfully added to the database.\n\n\n"); }