Get Row Index in a list by using entity framework
c#, entity-framework
Solution
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.
Problem
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 ?