Thanks for asking. Yes this is possible. We use our adapters in our office like this on a few of our servers needing to connect to multiple subnets.
There will be some manual configuration required and the configuration will depend on the OS the system is running. Typically connecting to multiple subnets for LAN access is possible using multiple Ethernet adapters but if you’re trying to connect to multiple Internet gateways that will be more problematic.
In Windows you will want to leave one adapter without a DNS server assigned. This connection can have LAN access to a different subnet but not have Internet access (as that will come from the other adapter).