Search In claims

user_11021933 0
Viewed 107

I am trying to filter users depending on the value of a specific claim.

I use ASP .Net Core 3 and RavenDB.

filteredData = data.Search(d => d.Email, model.search.value)
                   .Search(d => d.LastName, model.search.value)
                   .Search(d => d.FirstName, model.search.value)
                   .Search(d => d.Claims.FirstOrDefault(c => c.ClaimType == "Role"), model.search.value);

This does not work. Here is the error message :

System.InvalidOperationException: 'Cannot understand how to translate d.Claims.FirstOrDefault(c => (c.ClaimType == "Role"))'

Thank you for your help.

asp.net-core ravendb linq .net c#
1 Answers

Replace the Search with Where.

filteredData = data.Search(d => d.Email, model.search.value)
                   .Search(d => d.LastName, model.search.value)
                   .Search(d => d.FirstName, model.search.value)
                   .Where(d => d.Claims.FirstOrDefault(c => c.ClaimType == "Role"));
user_72132540
Related