v2.8.0

SqlHydra.Query v2.8.0

☀️.NET 9 Support (thanks, @EverybodyKurts!)
☀️Added support for SQL Server output in insert and update builders which allows you to return one or more inserted columns.

open SqlHydra.Query
open SqlHydra.Query.SqlServerExtensions 

let insertPerson (row: Person) =
  task {
    let! createDate, updateDate =
        insertTask openContext {
            for p in dbo.Person do
            entity row
            output (e.CreateDate, e.UpdateDate)
        }

    return updateDate
  }

open SqlHydra.Query
open SqlHydra.Query.SqlServerExtensions 

let updateRaceway (req: SaveRequest) = 
  updateAsync openContext {
      for rw in dbo.RACEWAYS do
      set rw.DRAWING_AREA req.DrawingArea
      set rw.UPDATED_DATE DateTime.Now
      where (rw.JOB_ID = jobId && req.RUN_NUMBER = runNo)
      output rw.UPDATED_DATE
  }

SqlHydra.Cli v2.8.1

☀️.NET 9 Support (thanks, @EverybodyKurts!)
☀️Fixed so that SQL Server HierarchyId column (added in v2.7.0) is not added to the generated primitive types function unless HierarchyId is actually used in the generated schema (since it requires an extra NuGet package).