Getting the index number in database using Entity Framework

Question

I have a table with Guid column as primary key.

enter image description here

How can I get the row index of a column using entity framework. For example I want to get the row index of Grapes

possible duplicate of Get Row Index in a list by using entity framework — Jaycee
– Jaycee, Commented May 12, 2014 at 10:13
And you have accounted for a GUID being a poor choice for a primary key? — Jaycee
– Jaycee, Commented May 12, 2014 at 10:14
@Jaycee GUID as primary key is not a poor choice.. see this article blog.codinghorror.com/primary-keys-ids-versus-guids — Ramppy Dumppy
– Ramppy Dumppy, Commented May 12, 2014 at 10:24
I would do a bit more research if I were you, try this stackoverflow.com/questions/897083/… Perhaps the GUIDs fit your scenario who knows — Jaycee
– Jaycee, Commented May 12, 2014 at 11:45

faby · Accepted Answer · 2014-05-12 10:31:33Z

0

You can get the index of the element directly if your list has implemented indexer.

In your case, for example if you want the Grapes index you can do this (I do not recommend using it in tables with many elements because from the point of view of the performance ToList() is bad):

Table test= Table.Where<Table>( x => return x.Name== "Grapes";).Single<Table>();
int index = Table.ToList().IndexOf(test);

edited May 12, 2014 at 10:31

answered May 12, 2014 at 10:05

faby

7,6043 gold badges30 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting the index number in database using Entity Framework

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related