Query : Contains can not be translated to "in" clause

[Anas-11]

Am trying to check if any element of a list exists in the DB using the following code :
var results =await _dbContext.Brands.AsNoTracking().AnyAsync(a => brandsHashset.Contains(a.Name));
Expecting that EF will translate it to "in" clause and the list will be sent as parameters , instead am getting an exception that it can not be translated .

[smitpatel]

Duplicate of #17877