CODEWITHSUNDEEP
vb.netlinq
Houlahan
Houlahan

Reputation: 783

Linq Query If statement

Ok im trying to do a if statement in Linq and was wondering if it was possible to do something like:

            Dim loadFriends = From p In db.UserRelationships Where p.aspnet_User.UserName = User.Identity.Name _
                          Or p.aspnet_User1.UserName = User.Identity.Name And p.Type = 1 _
                          Select New With {if p.aspnet_user1.user = "a certan username" then .username = _
                                          p.aspnet_user.username else .username = p.aspnet_user1.Username}

Thanks in Advance.

Thanks tyrongower

here is the query if anyone else has this same problem:

Dim loadFriends = From p In db.UserRelationships Where p.aspnet_User.UserName = User.Identity.Name _
                          Or p.aspnet_User1.UserName = User.Identity.Name And p.Type = 1 _
                          Select New With {.username = If((p.aspnet_User1.UserName = User.Identity.Name), p.aspnet_User.UserName, p.aspnet_User1.UserName)}

Upvotes: 0

Views: 3471

Answers (1)

TheRealTy
TheRealTy

Reputation: 2429

I don't know VB but in c# is would be

 username = (p.aspnet_user1.user == "a certan username")? aspnet_user.username:p.aspnet_user1.Username

I assume there would be ternary syntax for VB.NET

Upvotes: 1

Related Questions