private static void InsertCarsintoSQL_UsingEntityFramework(List <Car> cars, List <Manufacturer> manufacturers) { Database.SetInitializer(new DropCreateDatabaseIfModelChanges <CarDB>()); var db = new CarDB(); //db.Database.Log = Console.WriteLine; if (!db.cars.Any()) { foreach (var car in cars) { db.cars.Add(car); } db.SaveChanges(); } Console.WriteLine("Cars DB created and cars are populated"); var db_M = new ManufacturersDB(); if (!db_M.Manufacturers.Any()) { foreach (var manufacturer in manufacturers) { db_M.Manufacturers.Add(manufacturer); } db_M.SaveChanges(); } Console.WriteLine("Manufacturers DB created and Manufacturers are populated"); Console.ReadLine(); }
private static void InsertData() { var cars = ProcessCars("fuel.csv"); var db = new CarDB(); db.Database.Log = Console.WriteLine; if (!db.Cars.Any()) { foreach (var car in cars) { db.Cars.Add(car); } } db.SaveChanges(); }