Hello,
it would be great if you could add support for more than one HasFilter() Property. If this is not possible it would also help if ef core generates the HasFilter Properties in the order there are specified (START_TS before END_TS). The current behavior is that the order changes randomly when scaffolding the database.
<img src="https://objectstorage.us-phoenix-1.oraclecloud.com/p/BqK85Rn1zA5MP0vYiqbAdPgs7Z6OmMxw8SD3WCFVm5kY8uReidZ1KPIKkgJ1hCkG/n/axciphqpnohg/b/forums-legacy/o/uploads/W23B9LLQ5EVN/image.png" alt="image.png">create table CONFIRMATIONS (
LOCATION_ID VARCHAR2(40) NOT NULL,
START_TS TIMESTAMP(6) WITH TIME ZONE NOT NULL,
END_TS TIMESTAMP(6) WITH TIME ZONE NOT NULL,
);
create unique index CONFIRMATIONS_U1 on CONFIRMATIONS (LOCATION_ID,SYS_EXTRACT_UTC("START_TS"),SYS_EXTRACT_UTC("END_TS"))
Entity Framework Core .NET Command-line Tools 6.0.0
Oracle.EntityFrameworkCore Version 6.21.4