开发者

Iterate through linq query results from multiple tables

开发者 https://www.devze.com 2023-01-29 23:17 出处:网络
I have a VB .Net linq query that I want to return values from two tables. I currently h开发者_Go百科ave this:

I have a VB .Net linq query that I want to return values from two tables. I currently h开发者_Go百科ave this:

Dim query = (From c In db.Client _
                            Join u In db.Users _
                            On u.UserID Equals c.UserID _
                            Where (c.ClientID = 1)
                            Select c, u).ToList

query (System.Collections.Generic.List(Of )) returns several rows as expected each item containing a c and a u.

How do I iterate through the queries collection? Cheers


You need to turn on Option Infer then you can iterate over it in a foreach loop. However since it's an anonymous type you can only do it in the scope of the method you're in.

0

精彩评论

暂无评论...
验证码 换一张
取 消