private static void InsertData() { var cars = ConvertCSV("fuel.csv"); // call to read data in memory var db = new CarDB(); //db.Database.Log = Console.WriteLine; if (!db.Cars.Any()) { foreach (var car in cars) { db.Cars.Add(car); } db.SaveChanges(); } }
private static void QueryData() { var db = new CarDB(); // create a instance of car db db.Database.Log = Console.WriteLine; var query = db.Cars.OrderByDescending(c => c.Combined) .ThenBy(c => c.Name) .Select(c => new { c.Name, c.Manufacturer, c.Id }) .Take(10) ; Console.WriteLine(query.Count()); foreach (var c in query) { Console.WriteLine($"{c.Id,-3} : {c.Name,20} : {c.Manufacturer,30} : "); } var q = db.Cars.GroupBy(C => C.Manufacturer).Select(g => new { ManuName = g.Key, // intellisence not work Cars = g.OrderByDescending(c => c.Combined).ThenBy(c => c.Name).Take(2) }); foreach (var grp in q) { Console.WriteLine(grp.ManuName); foreach (var c in grp.Cars) { Console.WriteLine($"\t{c.Name} : { c.Combined}"); } } }