Compatibility with .NET 9

[irvanherz]

The current version of pgvector-dotnet does not support the latest .NET 9. When attempting to use the package with .NET 9, compatibility issues arise, potentially due to outdated dependencies or features that need updating to align with .NET 9.

Expected Behavior:
The library should work seamlessly with .NET 9, leveraging its features and compatibility improvements.

Steps to Reproduce:
Create a new .NET 9 project.
Add the pgvector-dotnet package.
Attempt to use the library (e.g., interact with pgvector functionalities).

Environment Details:
.NET Version: 9
Entity Framework Version: 9+
Pgvector Version: 0.3.0
Pgvector.EntityFrameworkCore: 0.2.1

Additional Notes:
Please provide an update or timeline for .NET 9 compatibility.

[roji]

What exact issues are you seeing? You haven't actually posted any error message or problematic behavior. .NET is generally fully backwards compatible, so a new version of .NET should always be able to run existing libraries without them getting updated etc.

[piotreksda]

Hi, there is problem with ef 9 support

System.TypeInitializationException: The type initializer for 'Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.Mapping.NpgsqlBigIntegerTypeMapping' threw an exception.
---> System.TypeLoadException: Method 'get_ConstructorExpression' in type 'JsonBigIntegerReaderWriter' from assembly 'Npgsql.EntityFrameworkCore.PostgreSQL, Version=8.0.0.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7' does not have an implementation.

[roji]

Please post your full csproj - that error is probably a result of mixing EFCore.PG and Npgsql major versions, and probably has nothing to do with pgvector.