static void InitData()
{
List <Car> cars = new List <Car>();
cars.Add(new Car()
{
name = "BMW", year = 2000
});
cars.Add(new Car()
{
name = "Mersedes", year = 2010
});
cars.Add(new Car()
{
name = "Hondai", year = 2012
});
cars.Add(new Car()
{
name = "Nissan", year = 2006
});
CarsDB db = new CarsDB();
foreach (var item in cars)
{
db.Cars.Add(item);
}
db.SaveChanges();
}
static void Main(string[] args)
{
using (var db = new CarsDB())
{
if (!db.Database.Exists())
{
InitData();
}
}
QueryData();
Console.ReadKey();
}
static void QueryData()
{
CarsDB dbContext = new CarsDB();
var cars = dbContext.Cars;
dbContext.Database.Log = Console.WriteLine;
var query = cars.Select(x => x.name);
foreach (var item in query)
{
Console.WriteLine(item);
}
}
