Add .NET8+9 as target frameworks; drop .NET6 support; drop CodeQL Action; run CI on .NET9

Add .NET8+9 as target frameworks; drop .NET6 support; drop CodeQL Action; run CI on .NET9 #188