getting an value representing the number of the record in the result set

Question

User379720387 posted

In my scenario apptDays returns two records. When I hoover over apptDays and navigate the minuscule arrows to Results View it looks like this:

[0] some information about this first record (multiple columns)

[1] some information about this second record (multiple columns)

var apptDays = dbContext.ScheduledSvcVisits
        .Where(s => s.enteredByProviderId == providerId && (s.visitStatus == "Scheduled" || s.visitStatus== "Invited"));

Later in the code I have a foreach loop:

foreach (var apptDay in apptDays)
{
     <div id="@apptDay.?" class="panel-collapse collapse">
}

I need the div id to resolve to 0 and then 1 for the second time. How can I get those values from apptDay, without having a counter that increments on each pass?

Answer 1

User475983607 posted

wavemaster

I need the div id to resolve to 0 and then 1 for the second time. How can I get those values from apptDay, without having a counter that increments on each pass?

I don't see how you can do this without a counter unless the results set has the values 0 and 1.  Maybe change to a for loop rather than a foreach.

You can get the index but that causes a search over the collection by value which is not efficient.

Answer 2

User379720387 posted

Ok, did it with a counter to move things along. Thanks

Just out curiosity how does one get the index? 

Answer 3

User475983607 posted

IndexOf

https://docs.microsoft.com/en-us/dotnet/api/system.array.indexof?view=netcore-3.1