I'm trying to convert an old .NET Framework/EF query into .NET Core/EFCore.
Old code:
var results = context.Appointments
.Any(x => DbFunctions.AddYears(x.ChildGeneral.DateOfBirth,12) \<= DbFunctions.TruncateTime(x.BookingDate));
Basically, get all the appointments where the child over 12 years, on the date of the booking.
EF Core uses EF.Functions, but it appears that the methods are supplied by the driver, and the only ones available for Oracle are
The documentation for MS-SQL give other methods like DateDiffYears, but these aren't available for Oracle.
How can I translate this query to EF core?