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