/// <summary> /// Afficher tous les clients /// </summary> private static void Exercice1() { LocationsContext context = new LocationsContext(); foreach (var client in context.Clients) { Console.WriteLine($"{client.Nom} {client.Prenom} - {client.DateNaissance}"); } }
/// <summary> /// Les 10 premiers clients dont le nom commence par 'A' /// </summary> private static void Exercice4() { LocationsContext context = new LocationsContext(); var clients = context.Clients.Where(c => c.Ville.StartsWith("A")).Take(10); foreach (var client in clients) { Console.WriteLine($"{client.Nom} {client.Prenom}"); } }
/// <summary> /// Le nombre de client par ville /// </summary> private static void Exercice3() { LocationsContext context = new LocationsContext(); var clients = context.Clients.GroupBy(c => c.Ville).Select(group => new { Ville = group.Key, Total = group.Count() }).OrderBy(group => group.Ville); foreach (var client in clients) { Console.WriteLine($"{client.Ville} : {client.Total}"); } }
/// <summary> /// Le nom et l’âge de tous les clients /// </summary> private static void Exercice2() { LocationsContext context = new LocationsContext(); var clients = context.Clients.Select(c => new { c.Nom, Age = DateTime.Now.Year - c.DateNaissance.Year }); foreach (var client in clients) { Console.WriteLine($"{client.Nom} : {client.Age} ans"); } }
/// <summary> /// La liste des villes (distincte) /// </summary> private static void Exercice5() { LocationsContext context = new LocationsContext(); var villes = context.Clients.Select(c => c.Ville).Distinct(); foreach (var ville in villes) { Console.WriteLine(ville); } }