How to change the order by a result using linq based on the generic list values.

Question

5.00/5 (1 vote)

See more:

I need to change the order of a result of the linq query based on the integer type generic list.
ex :

Linq i am using

var result= contect.tablename.where(somecondition).Tolist();
This result contains one code id which is an integer value.

I have another list

List<int> sororder=new list<int>();
sortorder.add(7);
sortOrder.add(9);

Now i need to sort result based on the above integer list.

Any help?

Posted 4-Dec-13 1:41am

Sowjanya49183

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Moumit Mondal · Answer 1 · 2013-12-04T02:33:00

Solution 1

Use simply

var result = contect.tablename.where(somecondition).orderby(i=>i).Tolist();

Posted 4-Dec-13 2:33am

Moumit Mondal

Comments

Sowjanya49183 4-Dec-13 8:54am

If i implement the above code then , the orderby is working only for the first item in the integer list.
Suppose my query result is {7,12}

Integer list is {7,3,4,12}
This case it is orders as expected.

If my query result is {3,12}
then the order by is not working .Based the integer list after 3 only 12 should get display.

Moumit Mondal 5-Dec-13 0:31am

If your list is {5,8,13,1,7,90,3} then the result will be {1,3,5,7,8,13,90} ... did this you want(??) or give me your expected result on my example ...

Sowjanya49183 5-Dec-13 1:13am

No.My Resulr is {1,3,5,7,8,13,90} and the list is {5,8,13,1,7,90,3} so based on the list result should sort in order {5,8,13,1,7,90,3} .

Moumit Mondal 5-Dec-13 6:07am

Then why you want it orderby ... You already have ur desire result
"the list is {5,8,13,1,7,90,3} so based on the list result should sort in order {5,8,13,1,7,90,3} ."

Sowjanya49183 5-Dec-13 8:42am

No i don't have the desire result. My expected result is that, now my problem how to do that sort after the linq.

BillWoodruff · Answer 2 · 2013-12-04T16:47:00

My opinion is that this is a case where using Linq ... while perhaps possible ... is probably "over-kill" because: what you are really doing is quite arbitrary. If I understand your goal, it is to move entries in a query result that match entries in another list to the front of the query result.

For the case that your query result doesn't contain duplicate values, you can use something like this:

C#

private List<int> queryList = new List<int> {11, 42, 65, 33, 3, 5, 65, 5, 8};
        
private List<int>sortByList = new List<int> {65, 123, 42, 11};

int sortByInt;
int matchAt;

// somewhere in a method ...

// traverse the sortByList from back to front
// based on the assumption the desired result
// is a sort based on magnitude
for (int i = sortByList.Count - 1; i >= 0; i--)
{
    sortByInt = sortByList[i];

    if (queryList.Contains(sortByInt))
    {
        matchAt = queryList.IndexOf(sortByInt);
        queryList.RemoveAt(matchAt);
        queryList.Insert(0, sortByInt);
    }
}

That would handle the case of having entries in the sort-by list that do not occur in the query list.

Sowjanya49183 · Answer 3 · 2013-12-08T21:46:00

Solution 3

By comparing the Integer list with Linq result set (with key element) added the data to the new list and used this new list for further process. This resolved my problem.

Posted 8-Dec-13 21:46pm