Order Linq Join

Question

i try any thing you sayed but i cant do my job its my code

    Func<Dead, Object> orderByFunc = null;
    orderByFunc = Dead => Dead.Last_Name;
    var query = from ded in searchDead
                    join ask in Asker on ded.Family_Number equals ask.Family_Number
                    orderby orderByFunc
                    select ask;
    Functions.searchAsker = query.AsQueryable<Asker>();

What *exactly* have you tried and in what way did it not work for you? By not specifying, you're leaving yourself open to receiving the same suggestions again, which wastes everyone's time. — Jon Skeet, Jul 15 '14 at 08:27
possible duplicate of [How can I do an OrderBy with a dynamic string parameter?](http://stackoverflow.com/questions/2728340/how-can-i-do-an-orderby-with-a-dynamic-string-parameter) — , Jul 15 '14 at 08:28
@JonSkeet - I'm assuming he'd like `...orderby("Last_Name")` — , Jul 15 '14 at 08:29
@DeeMac: Yes, but that doesn't give us any indication of what has already been tried or what the result was. — Jon Skeet, Jul 15 '14 at 08:32
no this samples not work cause of i select table ask only work when use (ded.Last_Name) — Hd.Mahmoodi, Jul 15 '14 at 08:33
i tried like this orderFild = "Last_Name"; var query = from ded in Functions.searchDead join ask in dataBase.Asker on ded.Family_Number equals ask.Family_Number orderby (orderFild) select ask; — Hd.Mahmoodi, Jul 15 '14 at 08:35
and `orderFild = "ded.Last_Name"; var query = from ded in Functions.searchDead join ask in dataBase.Asker on ded.Family_Number equals ask.Family_Number orderby (orderFild) select ask;` — Hd.Mahmoodi, Jul 15 '14 at 08:36

score 0 · Answer 1 · answered Jul 15 '14 at 08:37

string order = "Last Name";
var propertyorder = null
switch (order)
{
    case "Last Name":
        propertyorder = ded.Last_Name;
        break;
    case "First Name":
        propertyorder = ded.First_Name
        break;
    default:
        propertyorder = ded.Last_Name;
        break;
}

   var query = from ded in Dead
    join ask in Asker on ded.Family_Number equals ask.Family_Number
    orderby (propertyorder)
    select ask;

Order Linq Join

1 Answers1