Comment ajouter une relation

Je rajoute un peu plus d'information voici ce que je faisais avec mes datasets

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
            var sourceDataSet = new DataSet();
 
 
            var myDataAdapterResources = new Devart.Data.MySql.MySqlDataAdapter(            
            "SELECT id_hum,alias FROM machine.numero_hum where actif=TRUE order by alias"
            , (Devart.Data.MySql.MySqlConnection)(Devart.Common.GlobalComponentsCache.GetObjectByName("FormPrincipale.mySqlConnection")));
 
            myDataAdapterResources.Fill(sourceDataSet, "Resources");
 
 
            var myDataAdapterScheduler = new Devart.Data.MySql.MySqlDataAdapter(
            "SELECT ap.*,min(ap.datedeb) as date_deb,max(ap.Datefin) as date_fin,lp.id_lot from machine.numero_hum as nh,shoporder.avancement_part as ap,shoporder.lot_part as lp "+
            "where nh.Actif=TRUE and ap.id_hum=nh.id_hum and lp.id_part_lot=ap.id_part_lot group by lp.id_lot,ap.sequence"
            , (Devart.Data.MySql.MySqlConnection)(Devart.Common.GlobalComponentsCache.GetObjectByName("FormPrincipale.mySqlConnection")));
 
            myDataAdapterScheduler.Fill(sourceDataSet, "Scheduler");
 
            var relationResourcesScheduler = new System.Data.DataRelation("RelationResourcesScheduler",
            sourceDataSet.Tables["Resources"].Columns["id_hum"],
            sourceDataSet.Tables["Scheduler"].Columns["id_hum"]);
 
            sourceDataSet.Relations.Add(relationResourcesScheduler);

Et aprés je connecte mon dataSet comme ceci :

Code:

1
2
3
 
           schedulerStorage1.Resources.DataSource = sourceDataSet.Tables["Resources"];
            schedulerStorage1.Appointments.DataSource = sourceDataSet.Tables["Scheduler"];

Je viens de faire ceci pour faire une jointure entre mes deux contexts

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
        public IEnumerable<Equipment> getEquipments()
        {
            var objEquipment = new EquipmentEntities();
            return (from c in objEquipment.Equipment orderby c.alias ascending select c).AsQueryable();
        }
 
 
        public IEnumerable<avancement_part> getEtapes()
        {
            var objShopOrder = new ShopOrderEntities();
 
            return (from etape in objShopOrder.avancement_part
                   select etape).AsQueryable();
        }
 
        public IEnumerable<avancement_part> getEtapes(IEnumerable<Equipment> Equipments)
        {
 
            return from etape in getEtapes()
                        join equipment in Equipments
                        on etape.id_hum equals equipment.id_hum
                        select etape;
 
        }

Et aprés je connecte mes requetes comme cela:

Code:

1
2
3
4
5
6
7
8
9
 
            var objEquipmentManager = new EquipmentManager();
            var objShoporderManager = new ShoporderManager();
 
 
                var Equipments = objEquipmentManager.getEquipments();
                schedulerStorage1.Resources.DataSource = Equipments;
 
                schedulerStorage1.Appointments.DataSource = objShoporderManager.getEtapes(Equipments);

Et là les deux codes ne provoquent pas le même résultat.
Le premier fonctionne tandis que le second ne remplir pas mon scheduler