Open amit-srivastava-007 opened 5 months ago
Unfortunately, I think the short answer is that you can't currently. I'm not aware of a mechanism in EF Core to allow this currently. I'm certainly interested if someone can show how to make it work, but the IDs generally are intended to be opaque IDs.
You could take a look at this: https://learn.microsoft.com/en-us/ef/core/querying/user-defined-function-mapping#mapping-a-method-to-a-custom-sql
I used it once to make an important business calculation available in EFCore queries, it was easier than I expected.
Hello, I'm having a situation where a
StronglyTypedIdBackingType.String
ids need to be used in a ef core query withStartsWith
. Currently, I'm not seeing any string function available for such ids. Please guide me how to use it.I'm using v1.0.0-beta06 of the package
Example:
let's say
abc/efg/mnpxyz
is a value of an Id field stored as hierarchy forcity/ward/building
forOffice
entity.I want to write query