private static void InsertData() { var cars = ProcessCars("fuel.csv"); var context = new CarDb(); //context.Database.Log = Console.WriteLine; if (!context.Cars.Any()) { context.Cars.AddRange(cars); context.SaveChanges(); } }
private static void InsertData() { var cars = ProcessCars("fuel.csv"); var db = new CarDb(); if (!db.Cars.Any()) { foreach (var car in cars) { db.Cars.Add(car); } db.SaveChanges(); } }
private static void InsertData() { var cars = ProcessCars("fuel.csv"); var db = new CarDb(); if (!db.Cars.Any()) //anything there? { foreach (var car in cars) { db.Cars.Add(car); //note to insert car } db.SaveChanges(); //actually insert cars } }
public static void InsertCarsDb() { var cars = ProcessCsv("fuel.csv"); var db = new CarDb(); if (!db.Cars.Any()) { foreach (var car in cars) { db.Cars.Add(car); } db.SaveChanges(); } }
public static void InsertData() { var cars = Cars("fuel.csv"); using var db = new CarDb(); if (!db.Cars.Any()) { foreach (var car in cars) { db.Cars.Add(car); } } db.SaveChanges(); }
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(); } }
public void InsertData() { Database.SetInitializer(new DropCreateDatabaseIfModelChanges <CarDb>()); var cars = Processor.ProcessCarsFromCsv("fuel.csv"); var db = new CarDb(); if (!db.Cars.Any()) { foreach (var car in cars) { db.Cars.Add(car); } db.SaveChanges(); } }
private static void InsertData() { var cars = ProcessCars("fuel.csv"); var db = new CarDb(); //Entity Framework will assume that I want to connect to a database that has the same name as my DbContext derived class, including the namespace, so in this case, if I instantiate CarDb the Entity Framework will try to connect to a Cars.CarDb database on the localdb instance on this machine. db.Database.Log = Console.WriteLine; if (!db.Cars.Any()) { foreach (var car in cars) { db.Cars.Add(car); } db.SaveChanges(); } }
private static void InsertData() { var cars = ProcessCars("fuel.csv"); var db = new CarDb(); //this will log the SQL query that has been sent to the db db.Database.Log = Console.WriteLine; if (!db.Cars.Any()) { foreach (var car in cars) { db.Cars.Add(car); } db.SaveChanges(); } }