Convert from Entity Collection to List and Vice Versa

Nagarajaswamy

Hello Everyone,

[1]. After getting data into EntityCollection I want to perform Custom Sorting operation. I feel custom sorting is not possible with EntityCollection (If possible, please suggest me).

Now the alternative I found is converting from EntityCollection to List and perform Sorting operation, then store it back to EntityCollection.

but I dont know how to perform this operation. Please help me.

[2]. If it is possible to do Custom sorting with Entity Collection, please help me for the below query.

If EntityCollection I have is => {1,2,3,4,5,6,7,8,9}

when I click on column header,

Result expected is => {1,2,3,9,8,7,6,5,4}

if I click on column header again, it should sort back to => {1,2,3,4,5,6,7,8,9}

Thank you.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Chanakya Jayabalan8y ago
Accepted answer
Hi Nagaraj,

Did you try below code

List entityList = new List(myEntityCollection);

From the list you can use the sort method to have your list sorted. Check below link.

https://msdn.microsoft.com/en-us/library/b0zbh7b6(v=vs.110).aspx
Chanakya Jayabalan8y ago
Hi Nagaraj, Quick way is to split your liat in to two. Sort the second one and merge them both. And since yours is an array of int, why dont you have it as an array instead of list??
Nagarajaswamy8y ago
Hi Chanakya,

Thank you. That helped me a lot. I am able to acheive converted from List to EntityCollection and vice versa.

In my WPF application I am performing sorting, but I want to exclude first three rows of columns. Could you please help me with that.

eg:
If EntityCollection I have is => {1,2,3,4,5,6,7,8,9}
when I click on column header,
Result expected is => {1,2,3,9,8,7,6,5,4}

if I click on column header again, it should sort back to => {1,2,3,4,5,6,7,8,9}

-Nagaraj