IN Clause with Vogen (ValueObjects) types #852

Activity

1. mkalinski93 commented on Nov 8, 2024

   

   mkalinski93

   on Nov 8, 2024

   Last edited by mkalinski93

   Author

   More actions

   I´ve tested a few more scenarios and it seems that I have to explicitely use a typed collection for this case:

   //This works, as the List is of type RoleId
   List<RoleId> ids = new List<RoleId> { RoleId.Administrator, RoleId.Manager, RoleId.User };
   var test = await customQuery.Where("Id in @0", ids).ToListAsync();

   //This does not work
   List<string> stringIds = ids.Select(x => x.Value.ToString()).ToList();
   var test = await customQuery.Where("Id in @0", stringIds).ToListAsync();

   System.InvalidOperationException: No generic method 'Contains' on type 'System.Linq.Enumerable' is compatible with the supplied type arguments and arguments. No type arguments should be provided if the method is non-generic. 
   

   //This does not work
   List<Guid> guidIds = ids.Select(x => x.Value).ToList();
   var test = await customQuery.Where("Id in @0", guidIds).ToListAsync();

   System.InvalidOperationException: No generic method 'Contains' on type 'System.Linq.Enumerable' is compatible with the supplied type arguments and arguments. No type arguments should be provided if the method is non-generic. 
   

   //This does not work
   List<object> objectIds = ids.Select(x => (object)x.Value).ToList();
   var test = await customQuery.Where("Id in @0", objectIds).ToListAsync();

   System.InvalidOperationException: No generic method 'Contains' on type 'System.Linq.Enumerable' is compatible with the supplied type arguments and arguments. No type arguments should be provided if the method is non-generic. 
   

   //This does not work
   string testString = string.Join(", ", ids.Select(x => $"Guid(\"{x.Value}\")"));
   var test = await customQuery.Where("Id in @0", testString).ToListAsync();

   System.InvalidOperationException: No generic method 'Contains' on type 'System.Linq.Enumerable' is compatible with the supplied type arguments and arguments. No type arguments should be provided if the method is non-generic. 
   

   Since I´m using this library in order to filter my BackEnd from FrontEnd values, I don´t have any explicit type to set for the specify for the collection. But I´m struggling to find an answer that "Id eq 'key'" works, but "@0.Contains(Id) or Id IN (@0)" does not.
2. StefH

   changed the title [-]IN Claus with Vogen (ValueObjects) types[/-] [+]IN Clause with Vogen (ValueObjects) types[/+] on Feb 15, 2025