MyFlat app. (MVC_Razor+TS+ADO+TSQL)

=== Subfolders / projects (compilations etc.): ===
1) AssemblyRef — intermediate assemblies (MyFlat.Base) and dependencies (DotNetHelpers);
2) Auxiliary — auxiliary commands (.cmd);
3) MyFlat — ASP-project in C# (MyFlat app.; net5.0-windows; VS-2019);
4) MyFlat.Base — DB-access incapsulation (library in C#; net5.0-windows; VS-2019);
5) MyFlat.TS — compiled scripts in TypeScript, for MyFlat-project (+jQuery JavaScript Library v3.3.1; VS-2019);
6) MyFlat.Unused — currently unused files from MyFlat project(s);
7) QUERIES (ORM) — shared folder for C# and pure SQL projects;
8) SQL (DB-modelling) — T-SQL project (pure SQL programming inside database).

All C# projects may be compiled as in Visual Studio 2019 so by “dotnet build”-command
and correspondent MSBUILD-tool (accessed by appropriate path).
(Environment property “#UseMsBuild” is neutralized by default — in “#settings.cmd”.)

TypeScript project “MyFlat.TS\MyFlat.TS.njsproj” is for Visual Studio 2019.
But its compilation is unnecessary, because it is allready compiled:
*.ts => *.js ("outDir": "../MyFlat/wwwroot/ts" in “MyFlat.TS\tsconfig.json”).
Thus, only .NET 5.0 SDK and runtime are required to build MyFlat-application.

(SDK version 5.0.100 is explicitly specified in “global.json”.)

=== Dependencies (.NET + some Win32): ===
MyFlat assemblies are dependent on DotNetHelpers library.
In AssemblyRef subfolder there are following library files:
1) CommonHelpers.dll, CommonHelpers.pdb, CommonHelpers.xml;
2) CommonHelpers.2.dll, CommonHelpers.2.pdb, CommonHelpers.2.xml;
3) CommonHelpers.3.dll, CommonHelpers.3.pdb, CommonHelpers.3.xml
(Applied CommonHelpers assemblies are compiled for netstandard2.1.)

=== Requirements (start, re-build): ===

.NET 5.0
SDK 5.0.100
MSBUILD (desirable)
Visual Studio Community 16.8.0+ (desirable)
TypeScript SDK 3.7.4.0+ (desirable)

Microsoft SQL Server 2017 (140)+
SQL-Server database:
– compatibility level: Microsoft SQL Server 2017 (140);
– collation: Cyrillic_General_CI_AS;
– name: TEST (DB logical names: TEST, TEST_log).

=== Dependencies (packages, DLLs): ===

___ MyFlat.Base.csproj: ___
: : : : :
<PackageReference Include="System.Data.SqlClient" Version="4.8.2" />
: : : : :

___ MyFlat.csproj: ___
: : : : :
<PackageReference Include="Microsoft.AspNetCore.Mvc.NewtonsoftJson" Version="5.0.0" />
<PackageReference Include="System.Data.SqlClient" Version="4.8.2" />
: : : : :

=== Internal DLLs (DotNetHelpers from HandicraftSDK): ===
AssemblyRef\CommonHelpers.dll
AssemblyRef\CommonHelpers.2.dll
AssemblyRef\CommonHelpers.3.dll

– – –