private static void QueryData()
{
var myDB = new MyDbCars();
myDB.Database.Log = Console.WriteLine;
//var query = from car in myDB.MyTableCars
// where car.Manufacturer == "BMW"
// orderby car.Combined descending
// select car;
//foreach (var car in query.Take(10))
//{
// Console.WriteLine($"{car.Manufacturer} : {car.Name} - {car.Combined}");
//}
var query2 = from car in myDB.MyTableCars
group car by car.Manufacturer into groupCar
select groupCar;
foreach (var group in query2)
{
Console.WriteLine($"{group.Key}");
foreach (var car in group.OrderByDescending(c => c.Combined).Take(2))
{
Console.WriteLine($"\t{car.Name} - {car.Combined}");
}
}
}
private static void InsertData(List <Car> cars)
{
var myDB = new MyDbCars();
if (!myDB.MyTableCars.Any())
{
foreach (var car in cars)
{
myDB.MyTableCars.Add(car);
}
}
myDB.SaveChanges();
}
