Update simpl-build.sh to work with npgsql 6.0.0 (simplcommerce#1025)

minhhut · web-flow · commit 8c5d01a88996 · 2022-02-08T10:03:10.000+07:00
diff --git a/.gitignore b/.gitignore
@@ -161,4 +161,5 @@ $RECYCLE.BIN/
 src/Modules/**/launchSettings.json
 PublishProfiles/
 logs/
-src/Modules/**/wwwroot/admin/*.min.js
+src/Modules/**/wwwroot/admin/*.min.js
+.vscode
diff --git a/README.md b/README.md
@@ -42,6 +42,7 @@ Continuous deployment: https://ci.simplcommerce.com
 
 - PostgreSQL
 - [.NET Core SDK 6.0](https://www.microsoft.com/net/download/all)
+- Entity Framework Core (`dotnet tool install --global dotnet-ef`)
 
 #### Steps to run
 
diff --git a/simpl-build.sh b/simpl-build.sh
@@ -1,7 +1,8 @@
 #!/bin/bash
 set -e
 
-sed -i'' -e 's|<PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="3.1.0" />|<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="3.1.0" />|' src/SimplCommerce.WebHost/SimplCommerce.WebHost.csproj
+sed -i'' -e 's|<PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="6.0.0" />|<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="6.0.0" />|' src/SimplCommerce.WebHost/SimplCommerce.WebHost.csproj
+sed -i'' -e 's/ConfigureService();/AppContext.SetSwitch("Npgsql.EnableLegacyTimestampBehavior", true);\nConfigureService();/' src/SimplCommerce.WebHost/Program.cs
 sed -i'' -e 's/UseSqlServer/UseNpgsql/' src/SimplCommerce.WebHost/Program.cs
 sed -i'' -e 's/UseSqlServer/UseNpgsql/' src/SimplCommerce.WebHost/Extensions/ServiceCollectionExtensions.cs
 
