Recommendations for publishing the application

[MrDave1999]

No description provided.

[MrDave1999]

It is recommended to publish the application in a directory other than the project folder (where the project file is located).

Example:

dotnet publish -o /home/admin/out/PublishedApp -c Release

Why should you follow this recommendation?

The library may fail intentionally through a developer error.

For example, imagine that the project structure of a developer is:

└── ConsoleApp/
    ├── Reports/
    │   ├── products.sql
    │   └── orders.sql
    ├── ConsoleApp.csproj
    └── Program.cs

A developer can execute the following command:

dotnet publish -o MyOutput -c Release

A directory called MyOutput is created in /ConsoleApp and this directory will have a yesql folder with the SQL files.
A bin folder is also created with the yesql folder.

└── ConsoleApp/
    ├── bin/Release/net8.0/
    │   └── yesql/
    │       └── Reports/
    │           ├── products.sql
    │           └── orders.sql
    ├── Reports/
    │   ├── products.sql
    │   └── orders.sql
    ├── MyOutput/
    │   ├── yesql/
    │   │   └── Reports/
    │   │       ├── products.sql
    │   │       └── orders.sql
    │   ├── ConsoleApp.dll
    │   ├── ConsoleApp.exe
    │   └── ConsoleApp.pdb
    ├── ConsoleApp.csproj
    └── Program.cs

When the developer executes the dotnet build -c Release command, the MyOutput folder will also be copied to bin/Release/net8.0/yesql.

└── ConsoleApp/
    ├── bin/Release/net8.0/
    │   └── yesql/
    │       ├── Reports/
    │       │   ├── products.sql
    │       │   └── orders.sql
    │       └── MyOutput/
    │           └── yesql/
    │               └── Reports/
    │                   ├── products.sql
    │                   └── orders.sql
    ├── Reports/
    │   ├── products.sql
    │   └── orders.sql
    ├── MyOutput/
    │   ├── yesql/
    │   │   └── Reports/
    │   │       ├── products.sql
    │   │       └── orders.sql
    │   ├── ConsoleApp.dll
    │   ├── ConsoleApp.exe
    │   └── ConsoleApp.pdb
    ├── ConsoleApp.csproj
    └── Program.cs

This is normal behavior, it cannot be avoided, however, this causes the library to load the same SQL files, so it leads to an exception for having duplicate tags. This exception occurs when using this method: YeSqlLoader.LoadFromDefaultDirectory (this loads the SQL statements from a default directory called yesql).

The one that is recommended is not to create the publish directory inside the project folder, after all git would track the changes and it should not be like that.