linq et colonne de tri parametrable

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:

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

Dynamic Linq ?

Ca devrait répondre à toutes tes questions ;)

Parfait, merci beaucoup :ccool:

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

Code:

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:

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 :help:

Pourtant, je fais comme la doc:

Citation:

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?

d'après ce que tu dis, tu ne fais pas vraiment comme dans la doc :

Citation:

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

ca prend au choix desc ou descending + teste avec les 2 sans resultat :(