Extralight-ORM test sample (En+Ru)

Author: Sergei Y.Kitáev
Document date: November 01, 2019

=== Subfolders: ===
1) “Illustration (screenshots, fragments)” — demonstrative files (JPG, CS, SQL, TXT);
2) “MyFlat app. (MVC_Razor+TS+ADO+TSQL)” — ASP Web.application: “Flat owner personal cabinet” (rudimentary functionality);
3) “Satellites (lib.sources etc.)” — additional resources

This sample contains very simple Web-program: MyFlat app. (draft of flat owner cabinet service).
Demo-package has two main objectives:
-I.-
   To master some ORM-like techniques, which allows to access traditional SQL-database
   (SP, tables, views etc.) without usage of any official/commercial/… (heavy of lightweight)
   ORM. The functionality is based on ADO (as foundation for Extralight-ORM superstructure).
   Project “MyFlat.Base” incapsulates database access, originally based on “$Data”-package of
   DotNetHelpers library. It provides implementation of some abstractions, which are involved
   in query buiding on client-side (explicit queries and/or SP-based queries).
   MyFlat app. complex project has shared sources folder (whose sources are included into
   “MyFlat.Base” C#-project) — "QUERIES (ORM)" (subfolders: “$DB_META”, “$DB_QUERIES”, ”$DB_SP”).
   The queries are implemented in so-called imperative style.
   They are located in “$DB_QUERIES” and ”$DB_SP” subfolders (C#-side query sources).
-II.-
   The package contains subfolder: “SQL (DB-modelling)”.
   Here you can observe, how to use SQL-file technology, — a set of lightweight tools,
   templates/libs:
   - $SqlTrans (SQL-translation utility, based on SQLCMD);
   - $SqlUpload (SQL-uploading utility, based on BCP);
   - SQLAUX scripting library (extended T-SQL);
   - etc.
   The purpose of “SQL (DB-modelling)”-folder are:
   - Table structure deployment;
   - Filling tables with simple data (minimal content);
   - Development of programmatics (stored procedures etc.) with help of traditional
     file-based storage (how we do in conventional 1st-class languages), with all correspondent
     advantages: SQL-file tree, import files for SQL-preprocessor — on base of env.variables
     (in some extent it is similar to H-files usage in C-lang.), group/single script translation
     (compilation of procedural subsystem) etc.
   SQL-file technology is a way of intensive programming inside SQL-DB.
   It has been using for a long time for T-SQL coding in real database(s) of middle-size.

— — —