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