Handicraft Toolkit (aggregative package)
Package version: 2023-01-04

Handicraft Toolkit is a package of downloads available at Handicfart-CODE public pages,
which are the original software resource (https://handicraft.remelias.ru/).
The package contains tools (libs, utilities) and samples of so-called “handicraft programming”,
alternative programing style implemented on base of Microsoft platforms (.NET, Win32, SQL Server etc.).
This is a set of primitive templates which demonstrate how we can organize extension of base official framework(s),
to implement our own elementary technologies etc.
The idea is how to be able to create own special program engine (simplified framework, libs and so on).

Here you'll find following:
— SQL-File Technology, a way to organize SQL-project on base of file/directory tree, for effective translation from SQL sorce files to database objects;
— Transact-SQL enhanced with macro-keywords, SQL helper objects (SP and functions), command-line utilities for integration with alternative IDE(s);
— Big set of useful .NET-helpers packed into special DLLs (as application satellite libs) provided with corresponding source code;
— Examples of experimental pseudo-micro-ORM to SP and queries (explicit mapping from/to SQL) accompained with sample progs;
— Experimental Application Start Technology for Windows network file system (e.g. Windows domain), so-called Viventics (shared desktop apps);
— A lot of interesting uncommon things which are potentially useful and are deserving to be applied somewhere or re-implemented for somebody's purposes.

=== List of subpacks (included folders): ===
I. HandicraftSDK (subpack-version: 2023-01-04) — Handicraft-SDK, toolkit (C#, .NET, Win32, CMD, MSBuild, MS-Windows, Windows Domain, ...);
II. BookRegistry (subpack-version: 2022-11-28) — Client-Server Web-engine together with full-stack sample application (C#, WASM-Blazor, T-SQL, SP, CRUD, JWT, ...);
III. TEST (DB) (subpack-version: 2022-11-26) — binary images of TEST database (MSSQL) which is used in corresponding samples (BookRegistry app., MyFlat app., ...).

=== See description pages on Handicfart-CODE (public pages): ===
https://handicraft.remelias.ru/ — Handicraft-CODE public pages;
https://handicraft.remelias.ru/sdk/handicraft_sdk.html — Handicraft-SDK;
https://handicraft.remelias.ru/handicraft_code.html — Client-Server.WEB (idea).

=== See introductory article about BookRegistry app. (sample program): ===
Client-Server WASM-Application In C#, TypeScript And Transact-SQL (article)
https://blog-hc.remelias.ru/ — in author's blog (at https://remelias.ru/, parent Web-domain)
https://www.c-sharpcorner.com/article/client-server-wasm-application-in-c-sharp-typescript-and-transact-sql/
(at C#-Corner / Technologies / Blazor)

=== Root pages (software publisher's domains): ===
https://handicraft.remelias.ru/ — Handicraft-CODE (public pages);
https://blog-hc.remelias.ru/ — Handicraft-CODE author's blog;
https://remelias.ru/ (or https://www.remelias.ru/) — site root.


*** LIST OF SAMPLES (MAIN DEMO SOURCES): ***

= I.=
[BookRegistry] — WASM-Blazor+TS+ASP.NET+ADO.NET+MSSQL, compiled, requires amendments to run (see "!ReadMe.txt")
Project folders:
– "BookRegistry\Client";
– "BookRegistry\Server";
– "BookRegistry\TypeScript";
– "BookRegistry\SQL (DB-modelling)";
– "BookRegistry\SHARED\$ClientServer\!DB-queries (application SP)".

= II.=
[MyFlat app.] — MVC+Razor+TS+ADO.NET+MSSQL, compiled, ready to run
Project folders:
– "HandicraftSDK\SQL\Extralight-ORM test sample (En+Ru)\MyFlat app. (MVC_Razor+TS+ADO+TSQL)\MyFlat";
– "HandicraftSDK\SQL\Extralight-ORM test sample (En+Ru)\MyFlat app. (MVC_Razor+TS+ADO+TSQL)\MyFlat.Base";
– "HandicraftSDK\SQL\Extralight-ORM test sample (En+Ru)\MyFlat app. (MVC_Razor+TS+ADO+TSQL)\MyFlat.TS";
– "HandicraftSDK\SQL\Extralight-ORM test sample (En+Ru)\MyFlat app. (MVC_Razor+TS+ADO+TSQL)\SQL (DB-modelling)".

= III.=
1) [ConsoleCalculator] — simple calculator (most old DotNetHelpers sample), compiled, ready to run
Project folders:
– "HandicraftSDK\DotNetHelpers\Samples\ConsoleCalculator";
– "HandicraftSDK\DotNetHelpers\Samples\.LEGACY\ConsoleCalculator";
– "HandicraftSDK\DotNetHelpers\Samples\.WIN32\ConsoleCalculator".
2) [LnkConverter utility] — .LNT/.TXT converter, component of CMD-utilities
Project folders:
– "HandicraftSDK\DotNetHelpers\Samples\.LEGACY\LnkConverter utility\LnkConverter" (.NET 4.6, reliable);
– "HandicraftSDK\DotNetHelpers\Samples\.WIN32\LnkConverter utility (NativeLib)\LnkConverter" (experimental).
3) [XDeviceAccess.InterSys] — example of C++/CLI-library for COM-port access (based on Win32)
Project folders:
– "HandicraftSDK\DotNetHelpers\Samples\.LEGACY\XDeviceAccess.InterSys".

= IV.=
[Programming samples (SQL-file)] — miscellaneous samples related to SQL-File Technology
Project folders:
– "HandicraftSDK\SQL\Programming samples (SQL-file)\GUID-list generation";
– "HandicraftSDK\SQL\Programming samples (SQL-file)\Lists downloading (sys-info)";
– "HandicraftSDK\SQL\Programming samples (SQL-file)\Nested transaction test";
– "HandicraftSDK\SQL\Programming samples (SQL-file)\Trigger test";
– "HandicraftSDK\SQL\Programming samples (SQL-file)\Uploading to DB (used buildings)".

— — —