Query filter for property with conversion

[xperiandri]

entity.Property(application => application.AllowedTenants)
      .HasConversion(set => JArray.FromObject(set).ToString(Formatting.None),
                     s => !string.IsNullOrWhiteSpace(s)
                        ? JArray.Parse(s)
                                .Values<string>()
                                .ToHashSet(StringComparer.OrdinalIgnoreCase)
                        : new HashSet<string>(StringComparer.OrdinalIgnoreCase));

//entity.HasQueryFilter(a => a.AllowedTenants.Contains(httpContextAccessor.GetAuthorizedTenant()));
entity.HasQueryFilter(a => EF.Functions.Like(EF.Property<ISet<string>>(a, nameof(a.AllowedTenants)), $"%{httpContextAccessor.GetAuthorizedTenant()}%"));

How to make such a query for a property of ISet<string> which is saved as a string in a database?
And force to be executed in the database.

Of course, I would better execute filter using raw SQL which invokes JSON functions of SQL Server.
But it is impossible as I understand.

[smitpatel]

@xperiandri - What is specific issue you are hitting? Is query throwing or giving incorrect results or not compiling?
You could use JSON_VALUE function on SQL with user defined functions as described in detail here #11295 (comment)

[ajcvickers]

EF Team Triage: Closing this issue as the requested additional details have not been provided and we have been unable to reproduce it.

BTW this is a canned response and may have info or details that do not directly apply to this particular issue. While we'd like to spend the time to uniquely address every incoming issue, we get a lot traffic on the EF projects and that is not practical. To ensure we maximize the time we have to work on fixing bugs, implementing new features, etc. we use canned responses for common triage decisions.

[xperiandri]

Thanks @smitpatel, I will try that.

---

@ajcvickers which additional details?
It is a general question that you have not covered in documentation!

Property that uses conversions cannot be used in EF.Functions using database store type.
So that I cannot force query condition to be evaluated in a database.

[xperiandri]

@rowanmiller, could you evaluate this, please.
I haven't found any mention of my case in docs. Have you thought of this case? I mean using EF.Functions with converted property targeting database type for filtering.