PosInformatique · GillesTourreau · Sep 2, 2024 · Aug 19, 2024 · Aug 19, 2024 · Aug 19, 2024
diff --git a/.editorconfig b/.editorconfig
@@ -0,0 +1,12 @@
+[*.cs]
+
+# StyleCop
+
+# SA1600: Elements should be documented
+dotnet_diagnostic.SA1600.severity = none
+
+# SA1601: Partial elements should be documented
+dotnet_diagnostic.SA1601.severity = none
+
+# SA1602: Enumeration items should be documented
+dotnet_diagnostic.SA1602.severity = none
diff --git a/.github/workflows/github-actions-ci.yaml b/.github/workflows/github-actions-ci.yaml
@@ -0,0 +1,49 @@
+name: Continuous Integration
+
+on:
+  pull_request:
+    branches: [ "main" ]
+  push:
+    branches: [ "releases/**" ]
+
+jobs:
+  build:
+    runs-on: windows-latest
+    steps:
+      - uses: actions/checkout@v4
+
+      - name: Setup NuGet
+        uses: nuget/setup-nuget@v2
+
+      - name: Restore NuGet packages
+        run: nuget restore PosInformatique.UnitTests.Databases.sln
+
+      - name: Add msbuild to PATH
+        uses: microsoft/setup-msbuild@v2
+
+      - name: Build
+        run: msbuild "PosInformatique.UnitTests.Databases.sln" /p:Configuration=Debug
+
+      - name: Restore NuGet packages
+        run: nuget restore "samples/PosInformatique.UnitTests.Databases.Samples.sln"
+
+      - name: Build the samples
+        run: msbuild "samples/PosInformatique.UnitTests.Databases.Samples.sln" /p:Configuration=Debug
+
+      - name: Creates the LocalDB for the unit tests
+        shell: cmd
+        run: SqlLocalDB create posinfo-unit-tests
+
+      - name: Creates the SQL Login service accounts for the unit tests
+        shell: cmd
+        run: sqlcmd -S "(localDB)\posinfo-unit-tests" -Q "IF NOT EXISTS (SELECT 1 FROM [sys].[server_principals] WHERE [Name] = 'ServiceAccountLogin') CREATE LOGIN [ServiceAccountLogin] WITH PASSWORD = 'P@ssw0rd'"
+
+      # Use this fix https://github.com/microsoft/vstest-action/issues/31#issuecomment-2159463764
+      - name: Test with the dotnet CLI
+        uses: rusty-bender/vstest-action@main
+        with:
+          searchFolder: .\
+          testAssembly: |
+            /tests/**/*tests.dll
+            !./**/*TestAdapter.dll
+            !./**/obj/**
diff --git a/.github/workflows/github-actions-release.yml b/.github/workflows/github-actions-release.yml
@@ -0,0 +1,43 @@
+name: Release
+
+on:
+  workflow_dispatch:
+    inputs:
+      VersionPrefix:
+        type: string
+        description: The version of the library
+        required: true
+        default: 1.0.0
+      VersionSuffix:
+        type: string
+        description: The version suffix of the library (for example rc.1)
+
+run-name: ${{ inputs.VersionPrefix }}-${{ inputs.VersionSuffix }}
+
+jobs:
+  build:
+    runs-on: ubuntu-latest
+    steps:
+      - uses: actions/checkout@v4
+
+      - name: Setup .NET 8.x
+        uses: actions/setup-dotnet@v4
+        with:
+          dotnet-version: '8.x'
+
+      - name: Build UnitTests.Databases.SqlServer
+        run: dotnet pack 
+          --property:Configuration=Release
+          --property:VersionPrefix=${{ github.event.inputs.VersionPrefix }}
+          --property:VersionSuffix=${{ github.event.inputs.VersionSuffix }}
+          "src/UnitTests.Databases.SqlServer/UnitTests.Databases.SqlServer.csproj"
+
+      - name: Build UnitTests.Databases.SqlServer.EntityFramework
+        run: dotnet pack 
+          --property:Configuration=Release
+          --property:VersionPrefix=${{ github.event.inputs.VersionPrefix }}
+          --property:VersionSuffix=${{ github.event.inputs.VersionSuffix }}
+          "src/UnitTests.Databases.SqlServer.EntityFramework/UnitTests.Databases.SqlServer.EntityFramework.csproj"
+
+      - name: Publish the package to nuget.org
+        run: dotnet nuget push "src/**/bin/Release/*.nupkg" --api-key "${{ secrets.NUGET_APIKEY }}" --source https://api.nuget.org/v3/index.json
diff --git a/CodeCoverage.runsettings b/CodeCoverage.runsettings
@@ -0,0 +1,51 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- File name extension must be .runsettings -->
+<RunSettings>
+  <DataCollectionRunSettings>
+    <DataCollectors>
+      <DataCollector friendlyName="Code Coverage" uri="datacollector://Microsoft/CodeCoverage/2.0" assemblyQualifiedName="Microsoft.VisualStudio.Coverage.DynamicCoverageDataCollector, Microsoft.VisualStudio.TraceCollector, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
+        <Configuration>
+          <CodeCoverage>
+
+            <!-- Match assembly file paths: -->
+            <ModulePaths>
+              <Include>
+                <ModulePath>.*\.dll$</ModulePath>
+              </Include>
+              <Exclude>
+                <ModulePath>.*xunit.*</ModulePath>
+                <ModulePath>.*webjobs.*</ModulePath>
+                <ModulePath>moq.*</ModulePath>
+                <ModulePath>.*durabletask.*</ModulePath>
+                <ModulePath>microsoft.*</ModulePath>
+                <ModulePath>bouncycastle.*</ModulePath>
+                <ModulePath>.*tests\.dll$</ModulePath>
+              </Exclude>
+            </ModulePaths>
+
+            <Attributes>
+              <Exclude>
+                <!-- Exclude generated code from code coverage -->
+                <Attribute>^System\.CodeDom\.Compiler\.GeneratedCodeAttribute$</Attribute>
+                <Attribute>^System\.Diagnostics\.CodeAnalysis\.ExcludeFromCodeCoverageAttribute$</Attribute>
+              </Exclude>
+            </Attributes>
+
+            <CompanyNames>
+              <Include>
+                <CompanyName>.*PosInformatique.*</CompanyName>
+              </Include>
+            </CompanyNames>
+
+            <!-- We recommend you do not change the following values: -->
+            <UseVerifiableInstrumentation>True</UseVerifiableInstrumentation>
+            <AllowLowIntegrityProcesses>True</AllowLowIntegrityProcesses>
+            <CollectFromChildProcesses>True</CollectFromChildProcesses>
+            <CollectAspDotNet>False</CollectAspDotNet>
+
+          </CodeCoverage>
+        </Configuration>
+      </DataCollector>
+    </DataCollectors>
+  </DataCollectionRunSettings>
+</RunSettings>
diff --git a/Directory.Build.props b/Directory.Build.props
@@ -0,0 +1,49 @@
+<Project>
+
+  <!-- Common properties -->
+  <PropertyGroup>
+    <Authors>Gilles TOURREAU</Authors>
+    <Company>P.O.S Informatique</Company>
+    <Product>P.O.S Informatique</Product>
+    <Copyright>Copyright (c) P.O.S Informatique. All rights reserved.</Copyright>
+    <RepositoryUrl>https://github.com/PosInformatique/PosInformatique.UnitTests.Databases</RepositoryUrl>
+    <RepositoryType>git</RepositoryType>
+
+    <!-- Enable the last version of C# -->
+    <LangVersion>latest</LangVersion>
+
+    <!-- Enable implict usings -->
+    <ImplicitUsings>enable</ImplicitUsings>
+
+    <!-- Disable the Analyzers in Release configuration -->
+    <RunAnalyzers Condition="'$(Configuration)' == 'Release'">false</RunAnalyzers>
+
+    <!-- Disable the StyleCop 'XML comment analysis is disabled due to project configuration' warning. -->
+    <NoWarn>$(NoWarn);SA0001</NoWarn>
+
+    <!-- By default prefix all the assemblies name with ChantierConnect -->
+    <AssemblyName>PosInformatique.$(MSBuildProjectName)</AssemblyName>
+    <RootNamespace>PosInformatique.$(MSBuildProjectName.Replace(" ", "_"))</RootNamespace>
+  </PropertyGroup>
+
+  <ItemGroup>
+    <AdditionalFiles Include="..\..\stylecop.json">
+      <Link>stylecop.json</Link>
+    </AdditionalFiles>
+  </ItemGroup>
+
+  <!-- Common NuGet packages -->
+  <ItemGroup>
+    <PackageReference Include="StyleCop.Analyzers">
+      <PrivateAssets>all</PrivateAssets>
+      <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
+    </PackageReference>
+  </ItemGroup>
+
+  <!-- Add the default using directive for all the code -->
+  <ItemGroup>
+    <Using Include="System" />
+    <Using Include="System.Threading.Tasks" />
+  </ItemGroup>
+
+</Project>
diff --git a/Directory.Packages.props b/Directory.Packages.props
@@ -0,0 +1,17 @@
+<Project>
+  <PropertyGroup>
+    <ManagePackageVersionsCentrally>true</ManagePackageVersionsCentrally>
+  </PropertyGroup>
+  <ItemGroup>
+    <PackageVersion Include="coverlet.collector" Version="6.0.2" />
+    <PackageVersion Include="FluentAssertions" Version="6.12.0" />
+    <PackageVersion Include="Microsoft.EntityFrameworkCore" Version="8.0.8" />
+    <PackageVersion Include="Microsoft.EntityFrameworkCore.SqlServer" Version="8.0.0" />
+    <PackageVersion Include="Microsoft.NET.Test.Sdk" Version="17.11.0" />
+    <PackageVersion Include="Microsoft.SqlServer.DacFx" Version="162.3.566" />
+    <PackageVersion Include="PosInformatique.UnitTests.Databases.SqlServer.EntityFramework" Version="0.9.11" />
+    <PackageVersion Include="StyleCop.Analyzers" Version="1.2.0-beta.556" />
+    <PackageVersion Include="xunit" Version="2.9.0" />
+    <PackageVersion Include="xunit.runner.visualstudio" Version="2.8.2" />
+  </ItemGroup>
+</Project>
diff --git a/PosInformatique.UnitTests.Databases.sln b/PosInformatique.UnitTests.Databases.sln
@@ -0,0 +1,111 @@
+
+Microsoft Visual Studio Solution File, Format Version 12.00
+# Visual Studio Version 17
+VisualStudioVersion = 17.10.35201.131
+MinimumVisualStudioVersion = 10.0.40219.1
+Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "Solution Items", "Solution Items", "{BFE7322A-DFBA-4CE1-A3D8-7EBB4CD6F586}"
+	ProjectSection(SolutionItems) = preProject
+		.editorconfig = .editorconfig
+		.gitignore = .gitignore
+		CodeCoverage.runsettings = CodeCoverage.runsettings
+		Directory.Build.props = Directory.Build.props
+		Directory.Packages.props = Directory.Packages.props
+		LICENSE = LICENSE
+		README.md = README.md
+		stylecop.json = stylecop.json
+	EndProjectSection
+EndProject
+Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "UnitTests.Databases.SqlServer", "src\UnitTests.Databases.SqlServer\UnitTests.Databases.SqlServer.csproj", "{4CE1DA94-B254-45D3-8014-EB8055E38A01}"
+EndProject
+Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "tests", "tests", "{1E437195-1225-443D-BD19-8796F31B1E2B}"
+	ProjectSection(SolutionItems) = preProject
+		tests\.editorconfig = tests\.editorconfig
+		tests\Directory.Build.props = tests\Directory.Build.props
+	EndProjectSection
+EndProject
+Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "UnitTests.Databases.SqlServer.Tests", "tests\UnitTests.Databases.SqlServer.Tests\UnitTests.Databases.SqlServer.Tests.csproj", "{C87E8F0D-D96D-4D77-9713-5564DC2E3597}"
+EndProject
+Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "src", "src", "{49103176-7D08-4386-B445-76E9823503F8}"
+	ProjectSection(SolutionItems) = preProject
+		src\.editorconfig = src\.editorconfig
+		src\Directory.Build.props = src\Directory.Build.props
+	EndProjectSection
+EndProject
+Project("{00D1A9C2-B5F0-4AF3-8072-F6C62B433612}") = "UnitTests.Databases.SqlServer.Tests.DacPac", "tests\UnitTests.Databases.SqlServer.Tests.DacPac\UnitTests.Databases.SqlServer.Tests.DacPac.sqlproj", "{5F618225-0E1C-46A7-BBCC-23A6243D5CEE}"
+EndProject
+Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = ".github", ".github", "{91BFD2B1-6AB6-4B07-9D2E-430C93F150D4}"
+EndProject
+Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "workflows", "workflows", "{F8700AE9-9613-4CFE-B870-FAD786607D53}"
+	ProjectSection(SolutionItems) = preProject
+		.github\workflows\github-actions-ci.yaml = .github\workflows\github-actions-ci.yaml
+		.github\workflows\github-actions-release.yml = .github\workflows\github-actions-release.yml
+	EndProjectSection
+EndProject
+Project("{00D1A9C2-B5F0-4AF3-8072-F6C62B433612}") = "UnitTests.Databases.SqlServer.Tests.Source", "tests\UnitTests.Databases.SqlServer.Tests.Source\UnitTests.Databases.SqlServer.Tests.Source.sqlproj", "{A261D4FF-9BEA-475C-8671-E9BACFDCE960}"
+EndProject
+Project("{00D1A9C2-B5F0-4AF3-8072-F6C62B433612}") = "UnitTests.Databases.SqlServer.Tests.Target", "tests\UnitTests.Databases.SqlServer.Tests.Target\UnitTests.Databases.SqlServer.Tests.Target.sqlproj", "{6CD3F177-053F-4816-A37E-5CA6F293D34C}"
+EndProject
+Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "UnitTests.Databases.SqlServer.EntityFramework", "src\UnitTests.Databases.SqlServer.EntityFramework\UnitTests.Databases.SqlServer.EntityFramework.csproj", "{157DDF0D-9410-4646-94B9-9CEE4C140F5E}"
+EndProject
+Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "UnitTests.Databases.SqlServer.EntityFramework.Tests", "tests\UnitTests.Databases.SqlServer.EntityFramework.Tests\UnitTests.Databases.SqlServer.EntityFramework.Tests.csproj", "{04A7AE8F-FE77-435B-9250-600388BB8065}"
+EndProject
+Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "docs", "docs", "{8500A9B6-CAA0-432C-BABB-DDC86CE08994}"
+	ProjectSection(SolutionItems) = preProject
+		docs\WriteUnitTests.md = docs\WriteUnitTests.md
+	EndProjectSection
+EndProject
+Global
+	GlobalSection(SolutionConfigurationPlatforms) = preSolution
+		Debug|Any CPU = Debug|Any CPU
+		Release|Any CPU = Release|Any CPU
+	EndGlobalSection
+	GlobalSection(ProjectConfigurationPlatforms) = postSolution
+		{4CE1DA94-B254-45D3-8014-EB8055E38A01}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{4CE1DA94-B254-45D3-8014-EB8055E38A01}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{4CE1DA94-B254-45D3-8014-EB8055E38A01}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{4CE1DA94-B254-45D3-8014-EB8055E38A01}.Release|Any CPU.Build.0 = Release|Any CPU
+		{C87E8F0D-D96D-4D77-9713-5564DC2E3597}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{C87E8F0D-D96D-4D77-9713-5564DC2E3597}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{C87E8F0D-D96D-4D77-9713-5564DC2E3597}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{C87E8F0D-D96D-4D77-9713-5564DC2E3597}.Release|Any CPU.Build.0 = Release|Any CPU
+		{5F618225-0E1C-46A7-BBCC-23A6243D5CEE}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{5F618225-0E1C-46A7-BBCC-23A6243D5CEE}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{5F618225-0E1C-46A7-BBCC-23A6243D5CEE}.Debug|Any CPU.Deploy.0 = Debug|Any CPU
+		{5F618225-0E1C-46A7-BBCC-23A6243D5CEE}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{5F618225-0E1C-46A7-BBCC-23A6243D5CEE}.Release|Any CPU.Build.0 = Release|Any CPU
+		{5F618225-0E1C-46A7-BBCC-23A6243D5CEE}.Release|Any CPU.Deploy.0 = Release|Any CPU
+		{A261D4FF-9BEA-475C-8671-E9BACFDCE960}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{A261D4FF-9BEA-475C-8671-E9BACFDCE960}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{A261D4FF-9BEA-475C-8671-E9BACFDCE960}.Debug|Any CPU.Deploy.0 = Debug|Any CPU
+		{A261D4FF-9BEA-475C-8671-E9BACFDCE960}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{A261D4FF-9BEA-475C-8671-E9BACFDCE960}.Release|Any CPU.Build.0 = Release|Any CPU
+		{A261D4FF-9BEA-475C-8671-E9BACFDCE960}.Release|Any CPU.Deploy.0 = Release|Any CPU
+		{6CD3F177-053F-4816-A37E-5CA6F293D34C}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{6CD3F177-053F-4816-A37E-5CA6F293D34C}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{6CD3F177-053F-4816-A37E-5CA6F293D34C}.Debug|Any CPU.Deploy.0 = Debug|Any CPU
+		{6CD3F177-053F-4816-A37E-5CA6F293D34C}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{6CD3F177-053F-4816-A37E-5CA6F293D34C}.Release|Any CPU.Build.0 = Release|Any CPU
+		{6CD3F177-053F-4816-A37E-5CA6F293D34C}.Release|Any CPU.Deploy.0 = Release|Any CPU
+		{157DDF0D-9410-4646-94B9-9CEE4C140F5E}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{157DDF0D-9410-4646-94B9-9CEE4C140F5E}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{157DDF0D-9410-4646-94B9-9CEE4C140F5E}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{157DDF0D-9410-4646-94B9-9CEE4C140F5E}.Release|Any CPU.Build.0 = Release|Any CPU
+		{04A7AE8F-FE77-435B-9250-600388BB8065}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{04A7AE8F-FE77-435B-9250-600388BB8065}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{04A7AE8F-FE77-435B-9250-600388BB8065}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{04A7AE8F-FE77-435B-9250-600388BB8065}.Release|Any CPU.Build.0 = Release|Any CPU
+	EndGlobalSection
+	GlobalSection(SolutionProperties) = preSolution
+		HideSolutionNode = FALSE
+	EndGlobalSection
+	GlobalSection(NestedProjects) = preSolution
+		{1E437195-1225-443D-BD19-8796F31B1E2B} = {BFE7322A-DFBA-4CE1-A3D8-7EBB4CD6F586}
+		{49103176-7D08-4386-B445-76E9823503F8} = {BFE7322A-DFBA-4CE1-A3D8-7EBB4CD6F586}
+		{91BFD2B1-6AB6-4B07-9D2E-430C93F150D4} = {BFE7322A-DFBA-4CE1-A3D8-7EBB4CD6F586}
+		{F8700AE9-9613-4CFE-B870-FAD786607D53} = {91BFD2B1-6AB6-4B07-9D2E-430C93F150D4}
+		{8500A9B6-CAA0-432C-BABB-DDC86CE08994} = {BFE7322A-DFBA-4CE1-A3D8-7EBB4CD6F586}
+	EndGlobalSection
+	GlobalSection(ExtensibilityGlobals) = postSolution
+		SolutionGuid = {FAC64573-D665-48A8-AC75-7B82B692EC9E}
+	EndGlobalSection
+EndGlobal