VB.NET :For each loops with Resultset from LINQ 2 SQL

Question

The below code will fill User Records in "users".

    Dim users= From p In oDbUser.USERs Where p.STATE= "MI" And p.STATUS = 1

Can anyone tell me how can i use a foreaach loop in the result and take each indidual row items ?

msdn.microsoft.com/en-us/library/bb425822.aspx#linqtosql_topic1 — Geoffrey
– Geoffrey, Commented Jun 15, 2010 at 14:00

Henk Holterman · Accepted Answer · 2010-06-15 14:01:51Z

2

I think you also need a Select clause in that linq query.

And that is the most relevant part, assuming a simple Select p you can do

For Each user In users 

Next user

(you may want to check the VB syntax)

answered Jun 15, 2010 at 13:45

Henk Holterman

276k33 gold badges353 silver badges540 bronze badges

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

1 Comment

@Geoffrey, Thanks, I will edit. I did warn about my VB skills.