linq et colonne de tri parametrable

**julien_iz** · 23/08/2009, 02h33

Bonjour,

Je souhaiterai créer une méthode qui exécuterai une requête linq en recevant en paramètre la colonne sur laquelle faire un orderby:

Quel serait la signature de la méthode?
Quel allure aurait la requête?

Voici une requête imaginaire pour avoir un exemple de base (paramColum est la colonne en question):

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
 
From u in Datacontext.User
Select u
ORDER BY Datacontext.User.paramColum

**SoBaKa** · 24/08/2009, 09h42

Dynamic Linq ?

Ca devrait répondre à toutes tes questions

**julien_iz** · 24/08/2009, 09h56

Parfait, merci beaucoup

**julien_iz** · 24/08/2009, 18h28

En fait ca ne semble pas fonctionner (je suis en linq to entities):

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
Dim profilesQueryTest As IQueryable(Of PROFILE) = Nothing

        profilesQueryTest = From p In windocContext.PROFILE _
                            Select p

        profilesQueryTest.OrderBy("RES_ID desc, GED_ID")
        Dim test As String = CType(profilesQueryTest, System.Data.Objects.ObjectQuery).ToTraceString()

resultat:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
SELECT 
1 AS [C1], 
[Extent1].[RES_ID] AS [RES_ID], 
[Extent1].[GED_ID] AS [GED_ID], 
[Extent1].[BASE_GED] AS [BASE_GED], 
[Extent1].[TITLE] AS [TITLE], 
[Extent1].[AUTHOR_FULL_NAME] AS [AUTHOR_FULL_NAME], 
[Extent1].[CREATION_DATE] AS [CREATION_DATE], 
[Extent1].[TYPIST_FULL_NAME] AS [TYPIST_FULL_NAME], 
[Extent1].[NATURE_ID] AS [NATURE_ID], 
[Extent1].[NATURE_DESC] AS [NATURE_DESC], 
[Extent1].[CONSERVATION] AS [CONSERVATION], 
[Extent1].[FORMAT] AS [FORMAT], 
[Extent1].[IMPUTATION] AS [IMPUTATION], 
[Extent1].[DELIVERY_DATE] AS [DELIVERY_DATE], 
[Extent1].[F_NUM] AS [F_NUM], 
[Extent1].[NB_PAGES] AS [NB_PAGES], 
[Extent1].[SUPPORT_SUP] AS [SUPPORT_SUP], 
[Extent1].[NB_SUPPORT] AS [NB_SUPPORT], 
[Extent1].[COMMENTS] AS [COMMENTS], 
[Extent1].[A_IMPUTATION] AS [A_IMPUTATION], 
[Extent1].[RECEPTION_DOC] AS [RECEPTION_DOC], 
[Extent1].[STOCKAGE] AS [STOCKAGE], 
[Extent1].[MCDI] AS [MCDI], 
[Extent1].[DS_DESTRUCTION] AS [DS_DESTRUCTION], 
[Extent1].[STATUS] AS [STATUS], 
[Extent1].[DS_FI] AS [DS_FI], 
[Extent1].[DS_WINDOC] AS [DS_WINDOC], 
[Extent1].[DS_NUMERISATION] AS [DS_NUMERISATION], 
[Extent1].[DS_GED] AS [DS_GED], 
[Extent1].[DS_MCDI] AS [DS_MCDI], 
[Extent1].[DS_SAS] AS [DS_SAS], 
[Extent1].[DS_STOCKAGE] AS [DS_STOCKAGE], 
[Extent1].[F_NUM_TIME] AS [F_NUM_TIME], 
[Extent1].[Z_PAGE_COUNT] AS [Z_PAGE_COUNT], 
[Extent1].[Z_SCAN_USER] AS [Z_SCAN_USER], 
[Extent1].[Z_SCAN_WKSTATION] AS [Z_SCAN_WKSTATION], 
[Extent1].[Z_SCAN_DATE] AS [Z_SCAN_DATE], 
[Extent1].[Z_IS_PAPER] AS [Z_IS_PAPER], 
[Extent1].[Z_SCAN_LOCATION] AS [Z_SCAN_LOCATION], 
[Extent1].[Z_SCAN_BATCH] AS [Z_SCAN_BATCH], 
[Extent1].[Z_BURN_BATCH] AS [Z_BURN_BATCH], 
[Extent1].[Z_FINGERPRINT] AS [Z_FINGERPRINT], 
[Extent1].[Z_FILE_NAME] AS [Z_FILE_NAME], 
[Extent1].[Z_FILE_SIZE] AS [Z_FILE_SIZE], 
[Extent1].[ARBOX_ID] AS [ARBOX_ID], 
[Extent1].[AUTHOR_ID] AS [AUTHOR_ID], 
[Extent1].[CORRESPONDANT_ID] AS [CORRESPONDANT_ID], 
[Extent1].[DEMANDEUR] AS [DEMANDEUR], 
[Extent1].[TYPIST_ID] AS [TYPIST_ID], 
[Extent1].[T_PROCESSUS] AS [T_PROCESSUS]
FROM [dbo].[PROFILE] AS [Extent1]

Pas de asc ni de desc en vue

Pourtant, je fais comme la doc:

The OrderBy method permits a sequence of orderings to be specified, separated by commas. Each ordering may optionally be followed by asc or ascending to indicate ascending order, or desc or descending to indicate descending order. The default order is ascending. The example

products.OrderBy("Category.CategoryName, UnitPrice descending")

orders a sequence of products by ascending category name and, within each category, descending unit price.

Une idée?