EF Core 9 support

[ChrisJollyAU]

Opening this issue for any questions on the EF Core 9 support.

Work has begun and the master branch is now targeting EF Core 9 (dependent on preview 7).

EF Core 9 does work on .Net 8 so you can update the EF Core part without changing the .Net version.

Currently it is only available on the daily build feed with myget, with hopefully an alpha 1 on nuget before the end of the month

[ChrisJollyAU]

EFCore.Jet Alpha 1

Welcome to the first release of EFCore.Jet 9. This is targeting EF Core 9 preview 7 and will run on .Net 8+.

New Features

• Updated to EF Core 9 Update to EF Core 9 #251
• Create sequential GUID following the UUID Version 7 definition Create a new sequential guid generator based on the UUID version 7 #254
• Guids for the primary key are generated client-side now. There is only a way to get a numerical primary key last inserted value in Jet. Hence anything depending on that would never work as it couldn't query the last inserted Guid. Generate guid's for primary key client side #257
• TimeOnly.FromDateTime and TimeOnly.FromTimeSpan is now translated Translate TimeOnly.FromDateTime and TimeOnly.FromTimeSpan #259
• SearchConditionExpressionVisitor: From improvements made to the SQL Server version, add them to here. Update SearchCondition visitor with improvements from SQL Server version #255
  • <> TRUE becomes = FALSE
  • Use bitwise XOR (BXOR in Jet) for multiple optimizations with nullable boolean expressions
• The sort order for Indexes is now added. Part of Improvements to migrations #256
  • We now generate SQL code to create the indexes with the respective sort order for each index column.
  • The Database Model is now set properly when reading the details of the database into the model

Bug fixes

• Tests: Multiple fixes due to optimization improvements made by EF Core itself
• Fix shared column validating when using view splitting Fix View splitting #258
• Improvements to the migrations sql Improvements to migrations #256
  • Updating a column has the following improvements
    • Don't generate an unnecessary ALTER TABLE
    • If the column is being made non-nullable (when originally null), create an UPDATE statement to set the value of that column to the default value for those where the current value is NULL
• Null Semantics Tests: A test used the parent BoolTypeMapping and true was translated as 1. Jet uses -1 for true so override default behaviour to produce the sql literal of TRUE. Also adds some further tests to the overrides so we can test the sql Improve Null Semantics tests #260
• Use the lowest possible value of DateTime (1 Jan 100) when using a FirstOrDefault. A 0 in Jet/OLE Automation is not actually the lowest possible value
• The type mapping for the translation of TimeOfDay was returning a DateTime and not TimeSpan
• When reading a value for the TimeSpan and TimeOnly don't convert the default 0 to the c# 0 like we do for DateTime
• A primary key with type of short can also be mapped to a counter type if it needs to be an auto incrementing key