LINQ / Optimisation

Version imprimable

LINQ / Optimisation

Bonjour à tous,

Est ce que vous voyez un moyen de faire ces 2 requêtes LINQ en 1X ?
La 1ère requête me remonte les points manquants, la 2ème me remonte les points avec une puissance différente.

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
25
26
27
28
29
30
31
32
33
34
35
36
 
 
List<GTMPoint> newListPoint = (from gtmPtInList in listPointWithout25H
                                               join gtmPtInDb in listPointDbWithout25H on gtmPtInList.IIdTypePoint equals gtmPtInDb.IIdTypePoint into sameTypePt
                                               join gtmPtInDb in listPointDbWithout25H on gtmPtInList.LIdCounter equals gtmPtInDb.LIdCounter into sameCptId
                                               join gtmPtInDb in listPointDbWithout25H on gtmPtInList.DtPoint equals gtmPtInDb.DtPoint into sameDatePoint
                                               from t in sameDatePoint.DefaultIfEmpty()
                                               where t == null
                                               select new GTMPoint(
                                                   gtmPtInList.LIdCounter,
                                                   (GTMEnum.GTMTypePt)gtmPtInList.IIdTypePoint,
                                                   1,
                                                   gtmPtInList.DPuissance,
                                                   gtmPtInList.DtPoint,
                                                   gtmPtInList.DtVersion,
                                                   gtmPtInList.CValidation,
                                                   gtmPtInList.GtmGranularite
                                               )).ToList();
 
 
List<GTMPoint> updatedListPoint = (from gtmPtInList in listPointWithout25H
                                                   join gtmPtInDb in listPointDbWithout25H on gtmPtInList.IIdTypePoint equals gtmPtInDb.IIdTypePoint into sameTypePt
                                                   join gtmPtInDb in listPointDbWithout25H on gtmPtInList.LIdCounter equals gtmPtInDb.LIdCounter into sameCptId
                                                   join gtmPtInDb in listPointDbWithout25H on gtmPtInList.DtPoint equals gtmPtInDb.DtPoint into sameDatePoint
                                                   from t in sameDatePoint.DefaultIfEmpty()
                                                   where t != null && (float)gtmPtInList.DPuissance != (float)t.DPuissance
                                                   select new GTMPoint(
                                                       t.LIdCounter,
                                                       (GTMEnum.GTMTypePt)t.IIdTypePoint,
                                                       t.IVersion + 1,
                                                       gtmPtInList.DPuissance,
                                                       gtmPtInList.DtPoint,
                                                       gtmPtInList.DtVersion,
                                                       gtmPtInList.CValidation,
                                                       gtmPtInList.GtmGranularite
                                                   )).ToList();

23/02/2021, 16h57
youtpout978

Pourquoi ne pas faire un union entre les 2 ?
Sinon je pense tu peux peut être faire 2 jointure distincte sur la même table

La solution était dans la question, avec une bonne vieille ternaire ça fonctionne, je partage:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
   newListPoint.AddRange((from gtmPtInList in listPt
                                       join gtmPtInDb in listPtInDB on gtmPtInList.IIdTypePoint equals gtmPtInDb.IIdTypePoint into sameTypePt
                                       join gtmPtInDb in listPtInDB on gtmPtInList.LIdCounter equals gtmPtInDb.LIdCounter into sameCptId
                                       join gtmPtInDb in listPtInDB on gtmPtInList.DtPoint equals gtmPtInDb.DtPoint into sameDatePoint
                                       from t in sameDatePoint.DefaultIfEmpty()
                                       where (t == null) || (t != null && (float)gtmPtInList.DPuissance != (float)t.DPuissance)
                                       select new GTMPoint(
                                           gtmPtInList.LIdCounter,
                                           (GTMEnum.GTMTypePt)gtmPtInList.IIdTypePoint,
                                           t == null ? 1 : t.IVersion + 1,
                                           gtmPtInList.DPuissance,
                                           gtmPtInList.DtPoint,
                                           gtmPtInList.DtVersion,
                                           gtmPtInList.CValidation,
                                           gtmPtInList.GtmGranularite
                                       )).ToList());

25/02/2021, 15h11
youtpout978

Attention l'utilisation d'un Or dans ton where peut affecter les performances de ta requête parfois un union peut être plus perf ...