Mixing Database Functions and Value Conversions

[ghost]

Is there a way to use database functions and value conversions together in the way described in this question https://stackoverflow.com/questions/56261258/mixing-ef-core-convensions-and-dbfunction-for-a-jobject-property or is this feature is planned for a future release ?

[ajcvickers]

Triage: putting this on the backlog as a more specific case of #10434

[smitpatel]

For the original question posted in stackoverflow
Since 3.1, you can specify the store type for the parameter as follows

modelBuilder.HasDbFunction( typeof(MyDbContext).GetMethod(nameof(JsonValue)))
                      .HasName("JSON_VALUE")
                      .HasParameter("column")
                      .HasStoreType("nvarchar(max)")

This will configure the store type for the parameter. It will pass the validation and also treat the value being used there as of type nvarchar on server.