Bump dependencies (npgsql#3316)

roji · WhatzGames · commit c122231f7270 · 2024-12-18T21:21:40.000+01:00
* EF 9.0.0-rc.2.24474.1
* Npgsql 8.0.5
* dotnet SDK 9.0.100-rc.2
diff --git a/.github/workflows/build.yml b/.github/workflows/build.yml
@@ -11,7 +11,7 @@ on:
   pull_request:
 
 env:
-  dotnet_sdk_version: '9.0.100-rc.1.24452.12'
+  dotnet_sdk_version: '9.0.100-rc.2.24474.11'
   postgis_version: 3
   DOTNET_SKIP_FIRST_TIME_EXPERIENCE: true
 
diff --git a/.github/workflows/codeql-analysis.yml b/.github/workflows/codeql-analysis.yml
@@ -27,7 +27,7 @@ on:
     - cron: '30 22 * * 6'
 
 env:
-  dotnet_sdk_version: '9.0.100-rc.1.24452.12'
+  dotnet_sdk_version: '9.0.100-rc.2.24474.11'
 
 jobs:
   analyze:
diff --git a/Directory.Packages.props b/Directory.Packages.props
@@ -1,8 +1,8 @@
   <Project>
   <PropertyGroup>
-    <EFCoreVersion>[9.0.0-rc.2.24460.3]</EFCoreVersion>
-    <MicrosoftExtensionsVersion>9.0.0-rc.2.24456.9</MicrosoftExtensionsVersion>
-    <NpgsqlVersion>8.0.4</NpgsqlVersion>
+    <EFCoreVersion>[9.0.0-rc.2.24474.1]</EFCoreVersion>
+    <MicrosoftExtensionsVersion>9.0.0-rc.2.24473.5</MicrosoftExtensionsVersion>
+    <NpgsqlVersion>8.0.5</NpgsqlVersion>
   </PropertyGroup>
 
   <ItemGroup>
@@ -21,10 +21,6 @@
     <PackageVersion Include="Npgsql.NetTopologySuite" Version="$(NpgsqlVersion)" />
     <PackageVersion Include="Npgsql.DependencyInjection" Version="$(NpgsqlVersion)" />
 
-    <!-- Workaround for unsecure dependencies in EF -->
-    <PackageVersion Include="System.Formats.Asn1" Version="8.0.1" />
-    <PackageVersion Include="System.Text.Json" Version="8.0.4" />
-
     <PackageVersion Include="Microsoft.SourceLink.GitHub" Version="8.0.0" />
     <PackageVersion Include="Microsoft.NET.Test.Sdk" Version="17.8.0" />
     <PackageVersion Include="xunit" Version="2.9.0" />
diff --git a/global.json b/global.json
@@ -1,6 +1,6 @@
 {
   "sdk": {
-    "version": "9.0.100-rc.1.24452.12",
+    "version": "9.0.100-rc.2.24474.11",
     "rollForward": "latestMajor",
     "allowPrerelease": true
   }
diff --git a/test/EFCore.PG.FunctionalTests/EFCore.PG.FunctionalTests.csproj b/test/EFCore.PG.FunctionalTests/EFCore.PG.FunctionalTests.csproj
@@ -19,10 +19,6 @@
     <PackageReference Include="Microsoft.Extensions.Configuration.Json" />
     <PackageReference Include="Microsoft.Extensions.Configuration.EnvironmentVariables" />
 
-    <!-- Workaround for unsecure dependency on EF.Specification.Tests -->
-    <PackageReference Include="System.Formats.Asn1" />
-    <PackageReference Include="System.Text.Json" />
-
     <!-- Needed to override xunit dependencies from EFCore projects on versions which aren't available on nuget.org -->
     <PackageReference Include="xunit.assert" />
     <PackageReference Include="xunit.core" />
diff --git a/test/EFCore.PG.FunctionalTests/Query/PrimitiveCollectionsQueryNpgsqlTest.cs b/test/EFCore.PG.FunctionalTests/Query/PrimitiveCollectionsQueryNpgsqlTest.cs
@@ -1418,6 +1418,22 @@ WHERE cardinality(@__ints_0 || p."Ints") = 2
 """);
     }
 
+    public override async Task Parameter_collection_with_type_inference_for_JsonScalarExpression(bool async)
+    {
+        await base.Parameter_collection_with_type_inference_for_JsonScalarExpression(async);
+
+        AssertSql(
+            """
+@__values_0={ 'one', 'two' } (DbType = Object)
+
+SELECT CASE
+    WHEN p."Id" <> 0 THEN @__values_0[p."Int" % 2 + 1]
+    ELSE 'foo'
+END
+FROM "PrimitiveCollectionsEntity" AS p
+""");
+    }
+
     public override async Task Column_collection_Union_parameter_collection(bool async)
     {
         await base.Column_collection_Union_parameter_collection(async);

Original file line number	Diff line number	Diff line change
`@@ -1,6 +1,6 @@`
`1`	`1`	`{`
`2`	`2`	`"sdk": {`
`3`		`- "version": "9.0.100-rc.1.24452.12",`
	`3`	`+ "version": "9.0.100-rc.2.24474.11",`
`4`	`4`	`"rollForward": "latestMajor",`
`5`	`5`	`"allowPrerelease": true`
`6`	`6`	`}`