示例#1
0
        public UsersViewModel()

        {
            this.ListF = new ObservableCollection <FiliereCount>();

            var filCount = from etudiant in cl.etudiants
                           join filiere in cl.filieres
                           on etudiant.id_filiere equals filiere.id_filiere
                           group new { etudiant, filiere } by filiere.nom_filiere
            into grouping
                select new
            {
                grouping.Key,
                nbEtudiant = grouping.Count()
            };

            foreach (var gr in filCount)
            {
                ListF.Add(new FiliereCount {
                    Filiere = gr.Key, nbEtudiant = gr.nbEtudiant
                });
            }
        }