ASP.NET Linq To SQL and Nested Selects

Question

I'm using .NET 4 and I'm just wondering if there is an optimized way of achieving the following.

    Public Function GetUserByOpenID(ByVal claimedidentifier As String) As User Implements IUserRepository.GetUserByOpenID
        Dim user = (From u In dc.Users
                    Where u.ID = (From o In dc.OpenIDs
                                  Where o.ClaimedIdentifier = claimedidentifier
                                  Select o.UserID).FirstOrDefault
                    Select u)
        Return user
    End Function

Justin Niessner · Accepted Answer · 2010-06-24 16:10:13Z

1

Assuming that all users have a matching ID in OpenIDs:

Dim user = (From u in dc.Users
            Join o in dc.OpenIDs On u.ID Equals o.UserId
            Where o.ClaimedIdentifier = claimedidentifier
            Select u).FirstOrDefault()

edited Jun 24, 2010 at 16:10

answered Jun 24, 2010 at 16:01

Justin Niessner

246k40 gold badges416 silver badges546 bronze badges

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

2 Comments

Chase Florell Over a year ago

All I had to add to your example was .FirstOrDefault so that I could get a single record returned. Thank you for the help.

Justin Niessner Over a year ago

@rockinthesixstring - Added it to the example. Glad it worked.

Neil T. · Accepted Answer · 2010-06-24 16:17:52Z

0

Dim user = dc.OpenIDs
    .Where(o => o.ClaimedIdentifier == claimedidentifier)
    .Select(o => o.User)

I'm partial to lambdas, myself...

answered Jun 24, 2010 at 16:17

Neil T.

3,3201 gold badge28 silver badges31 bronze badges

1 Comment

Justin Niessner Over a year ago

I'm with you there...but this example is VB.NET. No Lambdas for them.

Collectives™ on Stack Overflow

ASP.NET Linq To SQL and Nested Selects

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related