Find Something in List of Objects, where object value is equal to string

Question

My classes

public class User
{
    [Key]
    public long Id {get;set;}
    public ICollection<AuthToken> Tokens { get; set; } = new List<AuthToken>();
}

public class AuthToken
{
    [Key]
    public long id { get; set; }
    public string Token { get; set; }
    public long Created { get; set; }
    public long Dispose { get; set; }
    public string Ip { get; set; }
    public string LocalisationInfo { get; set; }
    public string MachineInfo { get; set; }
}

I want to select AuthToken object, which string Token is equal to ``` 123 `

var user = cnx._Users
              .Where(x => x.Tokens.Contains(/*Tokens.Token object equal to 123 */))

In simply Where condition I can only compare two AuthToken objects. I need to compare AuthToken.Token strings.

Finally I want to select User who has Token I used. In this case its 123.

Kamil · Accepted Answer · 2020-02-12 13:44:51Z

4

You can 'chain' multiple linq calls to get the result you want...

var user = cnx._Users.Where(u => u.Tokens.Any(atoken => atoken.Token == "123")).FirstOrDefault();

edited Feb 12, 2020 at 13:44

Kamil

8921 gold badge11 silver badges25 bronze badges

answered Feb 12, 2020 at 13:30

Fortega

19.7k15 gold badges78 silver badges115 bronze badges

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

Comments

Nguyễn Văn Phong · Accepted Answer · 2020-02-12 13:49:05Z

1

You can also achieve it like below

var user = cnx._Users.Where(x => x.Tokens.FirstOrDefault(t => t.Token == "123") != null);

answered Feb 12, 2020 at 13:49

Nguyễn Văn Phong

14.2k19 gold badges47 silver badges65 bronze badges

Collectives™ on Stack Overflow

Find Something in List of Objects, where object value is equal to string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related