c# - Get Row Index in a list by using entity framework

Question

I have 5 datas in my list.

MyList

So i want to know , how can i get selected Id's Row Number ?

var MyProductId= 135;
var SelectedDataRowNumber = context.SP_MyList.ToList()
                                   .Where(s=>s.Id==MyProductId)
                                   .FirstOrDefault();

As instance, My List has 5 datas like below,

Id-Name

6,Computer

135,KeyBoard

68,Mouse

98,Telephone

213,Laptop,

MyProductId is 135 so it matchs with Keyboard.It is row count number( index )must be "1" because 0 is Computer.

How can i get selected Id's row count(index) number ?

Answer 1

You can get it directly the element by Index if your list has implemented indexer. You can find that How to implement Indexer.

Another way could be as described in Here.

The above link shows it like:

COPIED From Above link:

Person agedTwenty = myList.Where<Person>( x => return x.Age == 20; ).Single<Person>();
int index = myList.IndexOf(agedTwenty);

or alternatively

int index = myList.Where<Person>( x => return x.Age == 20; ).Select<Person,int>( x =>         
myList.IndexOf(x)).Single<int>();

In case there can be more than one result you'd do this:

IEnumerable<Person> allAgedTwenty = myList.Where<Person>( x => return x.Age == 20; );
IEnumerable<int> indices = allAgedTwenty.Select<Person,int>( x => myList.IndexOf(x) );

The first case will get you only one int and the second case will leave you with a list of ints.