public EmployeSession() { db = new AirAtlantiqueDBContext(); InitializeComponent(); var recup = MainWindow.envoi; var reqES = from es in db.Employes_Sessions where es.idSession == recup orderby es.Employe.nom select new { es.Employe.nom, es.Employe.prenom }; var reqID = from es in db.Employes_Sessions where es.idSession == recup orderby es.Employe.nom select es.idEmploye; var reqE = from e in db.Employes where !reqID.Contains(e.id) select new { e.nom, e.prenom }; foreach (var item in reqES) { LBoxEmployeSession.Items.Add(new Employe { nom = item.nom, prenom = item.prenom }); } foreach (var item in reqE) { LBoxEmploye.Items.Add(new Employe { nom = item.nom, prenom = item.prenom }); } }
public MainWindow() { db = new AirAtlantiqueDBContext(); InitializeComponent(); var req = from f in db.Formations select f.nom; foreach (var item in req) { LBFormation.Items.Add(item); } }