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();
}
